Course curriculum
-
1
Sort & Filter
-
2
Excel Tables
-
3
Data Validation
-
4
Importing & Exporting Data
-
5
Working With Large Data
-
6
Text to Columns
-
7
Go to Special
-
8
Find & Replace
-
9
Conditional Formatting
-
10
Flash Fill
-
11
Tips & Tricks!
-
Download Workbook List Design Quick Sorts Multi Level Sorts Custom Sort AutoFilter List Subtotals -
Excel Tables Find Duplicates with Conditional Formatting Remove Duplicates -
Data Validation Intro Data Validation - List Data Validation - Custom Errors Data Validation - List Formulas -
Download Workbooks Importing from Text Importing from Access Export to Text -
Download Workbook Freeze Panes Group & Outline Printing Large Docs 3D Formulas Consolidate -
Download Workbooks Convert Text Dates to Excel Dates with Text To Columns Regional Dates with Text To Columns Remove Emails from Names with Text To Columns Split Full Names with Text To Columns -
Download Workbooks Go To Blanks by Color Delete Empty Rows Go to Constants Row Differences -
Download Workbook Find & Replace Intro -
Download Workbooks Conditional Formatting a Cell's Value Conditional Formatting to Find Blank Cells -
Download Workbooks What is Flash Fill? Different Ways to Flash Fill Extract Names Combine Names Hyphen Between Numbers Move Text & Numbers Create Emails Excel Dates Fix Incorrect Formatting Extract Numbers from Text Reformat Sales Data Extract Hours & Minutes -
Download Workbooks Special Number Formats Fill In Empty Cells
Pricing options
Explain how different pricing options might be valuable to different segments of your audience.
-
Get started now
Free
Regular price