Essential to Expert Skills progression

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, 2019, 2016 and Mac versions more…

Category: Formulas

Search again:

VLOOKUP inexact match illustration (chicken and egg).

VLOOKUP inexact match

VLOOKUP lesson with sample file that will teach you everything there is to know when creating a VLOOKUP inexact match Excel function.

VLOOKUP exact match

Simple VLOOKUP tutorial with sample file that will teach you everything there is to know when creating a VLOOKUP function with an exact match.

x-lookup-tutorial-part-one

Excel XLOOKUP function (part two)

This is the second of a two-part series of XLOOKUP lessons.  If you haven’t already done so I recommend that you begin with part one by clicking this link. Excel

x-lookup-tutorial-part-one

Excel XLOOKUP function (part one)

The new Excel XLOOKUP function was introduced in the July 2020 Excel 365 semi-annual update.  It isn’t available in older versions (Excel 2019 and earlier).  The July 2020 update was

excel-sequence-function-tutorial

Excel SEQUENCE Function

This tutorial uses a single Excel SEQUENCE function to create a perpetual calendar. Includes sample files and a step-by-step guide.

Calculating loan payment dates

Calculating Loan Payment Dates

This article shows how to calculate loan payment dates in Excel, using a formula that can calculate loans of any length and number of periods.

Dice used to illustrate how to use factorial in Excel

How to use factorial (!) in Excel

This article shows how to calculate factorials and other combinatorials in Excel, showing how to calculate the probability of winning the lottery.

Working with HEX values in Excel

Working with HEX values in Excel

This article explains the Hexadecimal counting system and how to work with it in Excel, as well as the four different counting systems supported by Excel.

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 vaile in Excel

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.

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.