Playlist | Excel Formulas
18 videos • 338 views • by JasonMorrell
1
XLOOKUP vs VLOOKUP, HLOOKUP, LOOKUP, MATCH and INDEX (full comparison)
JasonMorrell
Download
2
XLOOKUP Express Tour
JasonMorrell
Download
3
2 Column Lookup using a clever Array Formula
JasonMorrell
Download
4
Build a Mortgage Reference Table (in less than a minute)
JasonMorrell
Download
5
Complex Multilevel IF Formulas (With IF, IFS, SWITCH, VLOOKUP, IFERROR, AND & OR)
JasonMorrell
Download
6
How to write a AVERAGEIF formula in Excel (with examples)
JasonMorrell
Download
7
How to write a AVERAGEIFS formula in Excel (with examples)
JasonMorrell
Download
8
Calculate a monthly / fortnightly / quarterly / annual Mortgage Payment using Excel's PMT function
JasonMorrell
Download
9
CEILING and FLOOR Excel Functions (with examples)
JasonMorrell
Download
10
How to calculate and round a person's age in Excel
JasonMorrell
Download
11
Meet The Counts: 5 Simple Count Functions in Excel
JasonMorrell
Download
12
COUNTIF | COUNTIFS | SUMIF | SUMIFS | AVERAGEIF
JasonMorrell
Download
13
VLOOKUP Closest Match (a.k.a. Approximate Match)
JasonMorrell
Download
14
How to write a SUMIF formula in Excel (with examples)
JasonMorrell
Download
15
How to write a SUMIFS formula in Excel (with examples)
JasonMorrell
Download
16
How to write a COUNTIF formula in Excel (with examples)
JasonMorrell
Download
17
How to write a COUNTIFS formula (with examples)
JasonMorrell
Download
18
MROUND formula (with examples)
JasonMorrell
Download