Formulas

Learn how to use functions to write formulas for common tasks like looking up values (VLOOKUP) and summarizing data (SUMIFS).

Vlookup to Other Workbooks - Managing & Sharing Files with Formula Links

Formulas

Vlookup to Other Workbooks – Managing, Updating, & Sharing Files with Formula Links

September 30, 2020

Dynamic Array Formulas

Formulas

Distinct Count Report with Dynamic Array Formulas

September 22, 2020

Total Rows for Dynamic Array Formulas and Spill Ranges in Excel

Formulas

Total Rows for Dynamic Array Formulas & Spill Ranges

August 12, 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

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

Dynamic Drop-down Lists Dashboard

Formulas, Tables & Data

How to Create a Dynamic Drop-down List that Automatically Expands

February 7, 2020

SORT & SORTBY Functions

Formulas

How to Sort with a Formula in Excel Using SORT and SORTBY Functions

February 5, 2020