Banner
Your banner contains a hero image with text overlay. You can also add call to action buttons.
John's Welcome
Oz's Welcome
Course Introduction
Connect with John & Oz
MyExcelOnline Resources
Terms & Conditions - Video Sharing Limitations
DOWNLOADABLE EXCEL WORKBOOKS
TEXT - Intro
CLEAN - Intro
CONCATENATE - Intro
FIND - Intro
LEFT - Intro
RIGHT - Intro
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
MID - Intro
MID - Extract Numbers Between Hyphens
MID - Extract Cell Contents into Separate Rows
SUBSTITUTE - Intro
SUBSTITUTE - Add Comma After The Surname
SUBSTITUTE - Remove Second Hyphen
SUBSTITUTE - Count Text Occurrences in a Cell
SUBSTITUTE - Report Name
TRIM - Intro
TIP - Convert Formulas to Values
TIP - Convert Text to Numbers
Text Function Quiz
DOWNLOADABLE EXCEL WORKBOOKS
VLOOKUP FALSE - Intro
VLOOKUP TRUE - Explained
VLOOKUP TRUE - Categorizing Data
MATCH - Intro
DOWNLOADABLE EXCEL WORKBOOKS
IF - Change Negative Values Using the IF function
Comparing Lists
Filling Holes
Filling in City Holes
Filling Many Holes in Data
Formula Case Study Quiz
Data Cleansing v Data Shaping
Data Shaping and Flat Files
Data Shaping & Flat Files Quiz
DOWNLOADABLE EXCEL WORKBOOKS
One Click Dates
Regional Dates
Remove Emails
Split Full Names
Text to Columns Quiz
Explain how different pricing options might be valuable to different segments of your audience.
Regular price
The Ultimate Excel Power Query & Data Cleansing Online Course