How to use ipconfig /display dns to view internet history
Did you know Windows 10 keeps a record of the websites you view? It doesn't matter which browser you use, if you use "in private" or "incognito" mode, or if…
CSV
How to export Outlook auto-complete to Excel list
In Outlook when you send an email the address is remembered and added to an 'auto-complete' list. The next time you type the email address into the 'to' field (as…
Excel 2013/2016 – How to change CSV delimiter character
By default when saving a CSV file in Excel, each column will be separated using a comma as the delimiter - hence the name Comma Separated Values (CSV). This can…
How to automatically send weekly registration summary
The following guide shows how to setup an automatic weekly email that includes a summary of site registrations completed through a form in Gravity Forms. The email will have a CSV…
How to automatically export payment summary using Gravity Forms
The following guide shows how to setup an automatic daily email that includes a summary of payments processed through a form in Gravity Forms. The email will have a CSV…
Excel 2013 – How to paste comma-separated values
The steps below show how to paste comma-separated values directly into an Excel 2013 file. This method uses a built in feature of Excel 2013 and does not require creating…
How to merge (combine) multiple CSV files into one CSV file using CMD
Here's a useful tip if you ever need to combine multiple CSV files into one CSV file. For example, if you have multiple CSV files but need to run a…
Server 2008 – Export Active Directory users to excel
The following command can be used to extract a complete list of users objects in your Active Directory environment. csvde -f C:\ADUsers.csv -r objectClass=user To run open the PowerShell…
How to search Active Directory for old computers
The following command prompt commands can be used when auditing Active Directory for old computer objects. Please note, if you're using Windows XP you will need to run the follwing…