MyExcelOnline

Course Intro

Creating a Dynamic SUM() Using INDEX() - Part 1

Creating a Dynamic SUM() Using INDEX() - Part 2

Combine Multiplication with INDEX() and MATCH() - Part 1

Combine Multiplication with INDEX() and MATCH() - Part 2

Create a Dynamic VLOOKUP() with MATCH() - Part 1

Create a Dynamic VLOOKUP() with MATCH() - Part 2

Create a Dynamic VLOOKUP() with MATCH() - Part 3

Turn INDEX() and MATCH() into an ARRAY - Part 1

Turn INDEX() and MATCH() into an ARRAY - Part 2

Returning Multiple Values with INDEX() - Part 1

Returning Multiple Values with INDEX() - Part 2

Returning Multiple Values with INDEX() - Part 3

Returning Multiple Values with INDEX() - Part 4

Adding Criteria to INDEX() and MATCH() - Part 1

Adding Criteria to INDEX() and MATCH() - Part 2

Return an Associated Value Using INDEX() and MATCH() - Part 1

Return an Associated Value Using INDEX() and MATCH() - Part 2

Conditional Formatting Using MATCH() - Part 1

Conditional Formatting Using MATCH() - Part 2

CLEAN - Intro

FIND - Intro

MID - Extract Numbers Between Hyphens

PROPER - Intro

REPLACE - Intro

REPLACE - Phone Area Codes

REPLACE - Insert Hyphens In Your Serial Number

REPLACE - Extract Last Name

REPLACE - Clear Everything Before the Hyphen

REPLACE - Insert New Code within Old Part Numbers

SUBSTITUTE - Intro

SUBSTITUTE - Add a Comma after the Surname

SUBSTITUTE - Remove Second Hyphen

SUBSTITUTE - Count Text Occurrences in a Cell

SUBSTITUTE - Report Name

TEXT - Intro

TRIM - Intro

Convert Formulas to Values

Convert Text to Numbers

MID {ARRAY FORMULA} - Extract Cell Contents in Separate Rows

VLOOKUP - A TAX TABLE WITH APPROXIMATE MATCH

VLOOKUP - SUM MULTIPLE COLUMNS WITH DATA VALIDATION DROP DOWN MENUS

VLOOKUP - MULTIPLE CRITERIA

SUMIFS WITH DATA VALIDATION DROP DOWN MENUS

CONCAT

IFS

MAXIFS

SWITCH

TEXTJOIN

FILTER

LAMBDA

LET

RANDARRAY

SEQUENCE

SORT

SORTBY

UNIQUE

XLOOKUP

XLOOKUP - More Examples

How to use the XLOOKUP function in Excel with 7 Examples!

LAMBDA Function in Excel - Create Custom Functions in Excel

Dynamic Search List using Data Validation & Formulas

Nested IF Formula with VLOOKUP Formula

MATCH, HLOOKUP & VLOOKUP

[Quiz] - Advanced - Formulas

Unlock your Certificate of Completion