Skip to content
If you need to create a pivot table chart on a range that includes blank rows you’ll end up with...
The following steps show how to remove empty rows from an Excel spreadsheet using Excel 2016. Note: this process does...
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 split comma separated values from one column into many. In this example we’ll focus...
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 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...
In these examples we’re going to show how to calculate the percent of a total using Microsoft Excel. The basic...
Problem One of the more frustrating features in Excel is its ability to automatically change a cells format – based...