Publishers of the world’s most comprehensive and up-to-date Excel tutorials

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…

Search all of our articles and free tutorials

Power Pivot

Excel Power Pivot – 2 minute overview

Power Pivot causes great confusion. This simple 2-minute overview completely de-mystifies Power Pivot and its associated technologies.

Excel modern data analysis

This article describes a new way of working with Excel called “modern data analysis” enabled by the new Get & Transform and Power Pivot tools.

Excel OLAP pivot tables

This article explains the difference between a regular Excel pivot table and the new OLAP pivot table used by Power Pivot.

Excel Power Pivot window

This lesson discusses the Power Pivot window and how it differs from the regular Excel window. A sample file is included.

Excel Get & Transform overview

Get & Transform (or Power Query) is an advanced ETL tool. ETL is an acronym for Extract, Transform and Load. This article simply explains this amazing tool.

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

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

An Excel formula to get the week of the month

This article shows you how to create an Excel formula to get the week of month from a date, as well as how to get the week of year from a date.

Use the LAMBDA function and DYNAMIC ARRAYS to construct a roulette simulator

In this step-by-step tutorial Excelâ€™s Lambda function and Dynamic Array feature are used to develop a full professional-grade Excel application.

Use the SUMIF and COUNTIF functions to create conditional totals

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.

Excel linear and exponential series

Linear and exponential series are explained in this short tutorial that also shows how to model them using Excel. Sample file included.

Horizontal scrolling with the mouse in Excel

Most users know how to use the “mouse wheel” to scroll in a vertical direction.This article explains how you can also scroll horizontally using Auto Scroll.

Can Excel Slicers be used in PowerPoint?

This article discusses Excel Slicers and how to integrate them with PowerPoint presentations and other Office applications.

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.

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.