Excel 2016 – How to have pivot chart show only some columns
The following steps show how to create a pivot table and chart that has two values (value and percent of total) but the chart only displays one value. This process…
Excel
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…
The idiots guide to installing WordPress on DigitalOceans $5 a month plan
I'm not interested in getting into the technical aspects of setting up a VPS as a web server - instead I choose to use DigitalOcean and ServerPilot to get me…
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…
Excel 2013/2016 – How to split comma separated values into columns
The following steps show how to split comma separated values from one column into many. In this example we'll focus on comma separated values, but the same process can be…
Excel 2013 – How to create drop down lists
A drop down list allows you to enter data into an Excel spreadsheet from a pre-set list of entries. This can be done to make data entry easier or to…
Excel 2016 – Auto-sum not working until edit formula or save spreadsheet
Problem When updating an Excel spreadsheet, formulas do not update automatically as values are entered or updates. Instead - the formula only updates after the formula is edited or the…
Excel 2016 – How to delete all empty columns
The following steps show how to remove empty columns from an Excel spreadsheet using Excel 2016. Note: this process does not account for partially empty columns. For example if a…
Excel 2016 – How to delete empty rows
The following steps show how to remove empty rows from an Excel spreadsheet using Excel 2016. Note: this process does not account for partially empty rows. For example if a…