Tutorials
How to highlight duplicate values in a range
Problem How do I highlight all of the duplicate values in a cell range? Background You can use Excel to easily identify duplicate values in a range. We will look at two simple methods. Download the...
How to use the CONCATENATE function in Microsoft Excel
In a Nutshell To CONCATENATE is to "Join" or "Combine" data together. Assume you have numerous columns of data to combine, and manually combining the data isn't a possibility. You can use the...
Video: 7 Essential Excel Functions
Dead Mouse Challenge – 40 Excel Keyboard Shortcuts and No Mouse!
In the video above, I demonstrate just how powerful keyboard shortcuts can be when using Microsoft Excel. I put the mouse aside and just fly through them one by one. If you've been meaning to learn...
Character code list for Excel CHAR function (on a PC)
The CHAR function returns a character specified by the code number from the character set for your computer. For example, CHAR(34) returns a double quotation mark (") and CHAR(10) returns a line...
How to display double quotation marks in an Excel formula
Problem How do I display double quotation marks in an Excel formula? Background Usually, the purpose of double quotes in an Excel formula is to indicate the beginning and end of...
What is a Pivot Table and How Can it Help Me?
Microsoft’s own definition of a Pivot Table is “a powerful tool to calculate, summarize, and analyse data that lets you see comparisons, patterns, and trends in your data”. Whenever you have...
How to Create a Pivot Table in Excel
What is a Pivot Table? A Pivot Table is defined by Microsoft as “a powerful tool to calculate, summarize, and analyse data that lets you see comparisons, patterns, and trends in your data”. Whenever...
Basic Cell Formatting in Excel
Summary Never again present a spreadsheet to your boss that is purely black and white. Change the formatting within cells by adding colours and changing the size of the text to make it more...
The Excel Interface Explained (3min video)
This short series of videos is designed for the absolute Excel newbie, but if you’ve been using Excel for a while you might still learn something new along the way. I will focus heavily on shortcut...