Skip to content
Here’s a useful tip if you ever need to combine multiple CSV files into one CSV file. This may be...
If you need to create a pivot table chart on a range that includes blank rows you’ll end up with...
If you see the following message when opening a Word document it means the document has been linked to another...
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 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...
If you see the following message when opening a Word document it means the document has been linked to another...
A drop down list allows you to enter data into an Excel spreadsheet from a pre-set list of entries. This...
To add a new paragraph inside a cell all you need to do is hold Alt and press Enter on...
The steps below show how to link a Word document with an Excel spreadsheet. This allows the data in the Excel...
The steps below show how to embed an Excel spreadsheet in a Word document. This allows the data in the Excel spreadsheet...
The following Excel formulas allow you to take a coumn with a full names (first name and last name) and separate the first and...
Cell references in Excel formulas typically use their position in the worksheet – e.g. A2 for a single cell or...
The following formula will count unique numbers in a column – it does not count text. =SUM(IF(FREQUENCY(A2:A10,A2:A10)>0,1))