Excel Tutorials (Blog)

Learn how to use Excel more efficiently with our in-depth articles and videos.

Groups and Outlines

Tips, Tips & Shortcuts

Quickly Hide Rows & Columns with Groups and Outlines in Excel

August 3, 2020

Running Totals Excel Tables

Formulas

3 Ways to Calculate Running Totals in Excel Tables + By Condition

July 21, 2020

IF vs VLOOKUP vs XLOOKUP

Formulas

How to Calculate Commissions in Excel with VLOOKUP, XLOOKUP, or IF

July 15, 2020

Pivot Table Average in Total Row Explained

Pivot Tables

Pivot Table Average of Averages in Grand Total Row

July 8, 2020

How to use the Subtotal Feature and the SUBTOTAL Function in Excel

Formulas

How to Use the Subtotal Feature and the SUBTOTAL Function in Excel

June 30, 2020

SUBTOTAL Function for Excel Tables

Formulas

The SUBTOTAL Function for Excel Tables Total Row Explained

June 24, 2020

Import PDF with Power Query

Power Pivot/Query/BI, Power Query

How to Import PDF Files into Excel with Power Query

June 17, 2020

Power Pivot/Query/BI, Power Query

How to Merge Tables with Power Query – Similar to Vlookup

June 3, 2020

VBA Macro to Create Power Query Connections for All Tables

Macros & VBA, Power Pivot/Query/BI, Power Query

VBA Macro to Create Power Query Connections for All Excel Tables

May 27, 2020