Formulas

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

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

UNIQUE & FILTER Functions Dashboard Part 3 of 6

Formulas

Return Multiple Values for a Lookup Formula in Excel with FILTER and UNIQUE

January 22, 2020

How to Use XLOOUKUP for Reverse Order Search

Formulas

How to Use XLOOKUP for Reverse Order Search

January 14, 2020

XOR Explained Dashboard Part 1 of 6

Formulas

How to use the XOR Function

January 8, 2020