Spreadsheet Nation
I teach people Excel so they can further their career. Visit my website for more extended tutorials.
Extract Data in Excel Using LEFT, RIGHT, MID & FIND | Excel Mini-Course: Data Cleanup Part 5
Clean Up Extra Spaces in Excel Using TRIM | Excel Mini-Course: Data Cleanup Part 4
2 Ways to Remove Duplicates in Excel | Excel Mini-Course: Data Cleanup Part 3
Use Flash Fill in Excel to Automate Data Entry | Excel Mini-Course: Data Cleanup Part 2
Split Text into Columns in Excel (Text to Columns Tool) | Excel Mini-Course: Data Cleanup Part 1
Manage & Edit Conditional Formatting Rules Easily | Excel Mini-Course: Conditional Formatting Part 7
Formula-Based Conditional Formatting in Excel | Excel Mini-Course: Conditional Formatting Part 6
Add Icons to Cells with Conditional Formatting | Excel Mini-Course: Conditional Formatting Part 5
Color Scales in Excel Conditional Formatting | Excel Mini-Course: Conditional Formatting Part 4
Data Bars in Excel: Visualize Your Numbers Fast | Excel Mini-Course: Conditional Formatting Part 3
Use Top/Bottom Rules in Excel to Find Trends | Excel Mini-Course: Conditional Formatting Part 2
Highlight Cells with Conditional Formatting | Excel Mini-Course: Conditional Formatting Part 1
More PivotTable Practice | Excel Mini-Course: PivotTables Part 10
PivotTable Practice | Excel Mini-Course: PivotTables Part 9
PivotTable Design Tips for Better Reports | Excel Mini-Course: PivotTables Part 8
How to Use the Analyze Tab in PivotTables | Excel Mini-Course: PivotTables Part 7
Use Calculated Fields in PivotTables | Excel Mini-Course: PivotTables Part 6
How to Update PivotTable Data | Excel Mini-Course: PivotTables Part 5
Change Value Field Settings in PivotTables | Excel Mini-Course: PivotTables Part 4
Create Multi-Level PivotTables in Excel | Excel Mini-Course: PivotTables Part 3
Add Filters & Columns to Your PivotTable | Excel Mini-Course: PivotTables Part 2
Create a Basic PivotTable in Excel in Under 5 Minutes | Excel Mini-Course: PivotTables Part 1
VLOOKUP, INDEX/MATCH, AND XLOOKUP Step-by-Step Examples | Excel Mini-Course: Lookup Functions Part 7
VLOOKUP Tricks You Wish You Knew Sooner | Excel Mini-Course: Lookup Functions Part 6
VLOOKUP Approximate Match Explained Simply | Excel Mini-Course: Lookup Functions Part 5
XLOOKUP in Excel: WAY better than VLOOKUP | Excel Mini-Course: Lookup Functions Part 4
INDEX + MATCH in Excel: Better Than VLOOKUP? | Excel Mini-Course: Lookup Functions Part 3
What is HLOOKUP in Excel? When to Use It | Excel Mini-Course: Lookup Functions Part 2
How to Use VLOOKUP in Excel (Beginner Tutorial) | Excel Mini-Course: Lookup Functions Part 1
Change Case in Excel (UPPER, LOWER, PROPER) | Excel Mini-Course: Essential Functions Part 12