Excel 2013 Wednesday, 5 October 2016 by 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. This may be... 27 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... 2 Word 2013 – How to remove links to other files If you see the following message when opening a Word document it means the document has been linked to another... 2 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... Word 2013 – How to disable update linked document message If you see the following message when opening a Word document it means the document has been linked to another... 1 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... 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... Excel 2013 – How to start new paragraph in a cell (add a line break) To add a new paragraph inside a cell all you need to do is hold Alt and press Enter on... Word 2013 – How to link an Excel spreadsheet The steps below show how to link a Word document with an Excel spreadsheet. This allows the data in the Excel... Excel – how to separate first name and last name from a full name The following Excel formulas allow you to take a coumn with a full names (first name and last name) and separate the first and... Word 2013 – How to embed an Excel spreadsheet The steps below show how to embed an Excel spreadsheet in a Word document. This allows the data in the Excel spreadsheet... How to create named cell references in Excel 2016 Cell references in Excel formulas typically use their position in the worksheet – e.g. A2 for a single cell or... Excel 2013 – Formula to count unique numbers in column The following formula will count unique numbers in a column – it does not count text. =SUM(IF(FREQUENCY(A2:A10,A2:A10)>0,1))
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. This may be... 27
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... 2
Word 2013 – How to remove links to other files If you see the following message when opening a Word document it means the document has been linked to another... 2
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...
Word 2013 – How to disable update linked document message If you see the following message when opening a Word document it means the document has been linked to another... 1
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...
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...
Excel 2013 – How to start new paragraph in a cell (add a line break) To add a new paragraph inside a cell all you need to do is hold Alt and press Enter on...
Word 2013 – How to link an Excel spreadsheet The steps below show how to link a Word document with an Excel spreadsheet. This allows the data in the Excel...
Excel – how to separate first name and last name from a full name The following Excel formulas allow you to take a coumn with a full names (first name and last name) and separate the first and...
Word 2013 – How to embed an Excel spreadsheet The steps below show how to embed an Excel spreadsheet in a Word document. This allows the data in the Excel spreadsheet...
How to create named cell references in Excel 2016 Cell references in Excel formulas typically use their position in the worksheet – e.g. A2 for a single cell or...
Excel 2013 – Formula to count unique numbers in column The following formula will count unique numbers in a column – it does not count text. =SUM(IF(FREQUENCY(A2:A10,A2:A10)>0,1))