VLOOKUP using text strings
How to use VLOOKUP to search for a piece of text and return a matching value. This article also explains what VLOOKUP is and when to use it.
Why you can’t effectively learn Excel 2016/365 using a Video Tutorial
This article explains Microsoft’s new Sofware As A Service strategy for Excel 2016 via Office 365, as well as the future of Excel 2019 and beyond.
Separating text and numbers in Excel
This article shows three different ways of separating text and numbers in Excel. You’ll see how to do this using Flash Fill, Text to Columns and formulas.
Removing gaps between bars in an Excel chart
This article shows you how to change the width of the gaps between bars in Excel column charts, or remove the gaps entirely.
Adding VAT to a value in Excel
This article shows how percentages are handled in Excel workbooks and how to add 20% VAT to a value in Excel, along with an example.
An Excel formula to check if a cell contains some text
Sometimes you need to know whether a cell contains specific, or any text. This article shows how to do this using the SEARCH, ISNUMBER and FIND functions.
Subtracting percentages in Excel
This article explains how Excel handles percentages and shows you how to subtract a percentage from a number in Excel using two different methods.
Why are the sort and filter options greyed out?
Sometimes Excel’s sorting and filtering options become grayed-out and unusable for no apparent reason. This article explains how to fix the problem.
Why does Excel say “The value you entered is not valid”?
This is happening because the cell has a Validation that only allows certain values to be entered. You can remove it by following these steps.
A Keyboard Shortcut for Merge and Center
You can create keyboard shortcuts to any command in Excel 2016 without needing any external tools or macros. This article will show you how.
Excel Versions Explained
This article describes the history of Microsoft Excel, from its earliest versions to the most recent, and the best ways to learn how to use each version.
Office 365 Updates
This article describes the new features added to Excel 365 for each new semi-annual version.
Excel 2016 for Mac vs Excel 2016 for Windows
The most complete existing list of the differences between Excel 2016 for Windows and Excel 2016 for Mac. The Windows and Mac versions are very different.