Formulas

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

LAMBDA Explained

Formulas

The LAMBDA Function Explained – How to Create Custom Functions in Excel

September 15, 2021

Manual Calc Mode

Formulas

How to Fix Excel Formulas that are Not Calculating or Updating

July 20, 2021

3 Ways to Combine Text

Formulas, Power Query

3 Ways to Combine Text in Excel – Formulas, Functions & Power Query

June 15, 2021

How to Split Text in Cells Using Formulas

Formulas

How to Split Text in Cells Using Formulas

May 26, 2021

UNIQUE Formula for Non-Adjacent Columns

Formulas

UNIQUE Formula for Non-Adjacent Columns

February 16, 2021

Formulas

Seating Chart Planner – Excel Hash – Episode 3

February 2, 2021

XLOOKUP Go To Source Macro

Formulas, Macros & VBA

Go To Source Cell of XLOOKUP Formula

January 20, 2021

FILTER Non-Adjacent Columns

Formulas

FILTER Formula to Return Non-Adjacent Columns in Any Order

November 11, 2020

3 Ways to Fill Down Blank Cells

Formulas, Macros & VBA

3 Ways to Fill Down Blank Cells in Excel

October 21, 2020