Excel Tutorials (Blog)

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

Data Analysis Challenge

Tables & Data

Excel Data Analysis Challenge

August 26, 2020

Filter by Selected Cells Value

Keyboard Shortcuts, Tips, Tips & Shortcuts

Shortcut to Filter by Cell’s Value in Excel

August 19, 2020

Total Rows for Dynamic Array Formulas and Spill Ranges in Excel

Formulas

Total Rows for Dynamic Array Formulas & Spill Ranges

August 12, 2020

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