Skip to content
If you need to create a pivot table chart on a range that includes blank rows you’ll end up with...
Problem When updating an Excel spreadsheet, formulas do not update automatically as values are entered or updates. Instead – the...
The following formulas show how to calculate an age group from an age. This may be useful if you need...
By default when saving a CSV file in Excel, each column will be separated using a comma as the delimiter...
The following steps show how to remove empty columns from an Excel spreadsheet using Excel 2016. Note: this process does...
The following steps show how to remove empty rows from an Excel spreadsheet using Excel 2016. Note: this process does...
The following steps show how to split comma separated values from one column into many. In this example we’ll focus...
The following steps show how to edit a worksheet header/footer in Microsoft Excel. With the Excel document open, click on...
The steps below will show how to hide data from a pivot table based on the value. In this example...
The #DIV/0! error message means “divide by zero” – a division which is mathematically impossible, hence the error. When you see...
The following formulas show how to calculate the difference between two dates. The difference can be measured by: days months...
Cell references in Excel formulas typically use their position in the worksheet – e.g. A2 for a single cell or...
Problem In an Excel document, you’re unable to insert a new row. The ‘Insert’ option is greyed out. Solution This...
Problem One of the more frustrating features in Excel is its ability to automatically change a cells format – based...
In these examples we’re going to show how to calculate the percent of a total using Microsoft Excel. The basic...