Excel tutorials

The only Excel books you will ever need

  • The only constantly updated Excel 365 titles more…
  • Thoroughly covers Power Pivot and Power Query more…
  • Covers business intelligence and OLAP features more…
  • Simple, easy, understandable, 2-page lessons more…
  • Available as both printed books and e-Books more…
  • Used by schools, colleges and universities  more…
  • Available for 365, 2021, 2019, 2016 and Mac versions more…

VLOOKUP using text strings

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.

Separating text and numbers in Excel

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.

Adding VAT to a value in Excel

Adding VAT to a vaile 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.

Subtracting percentages in Excel

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.

Excel Versions Explained

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

Office 365 update history

This article describes the new features added to Excel 365 for each new semi-annual version.

Which tutorial do you need?