Course curriculum
-
1
Workbooks
-
2
Sort & Filter
-
3
Excel Tables
-
4
Data Validation
-
5
List Formulas
-
6
Importing & Exporting Data
-
7
Working With Large Data
-
8
Text to Columns
-
9
Go to Special
-
10
Find & Replace
-
11
Conditional Formatting
-
12
Flash Fill
-
13
Tips & Tricks!
-
14
What If Analysis
-
15
Quiz Test
-
16
Certificate of Completion
-
Download Workbooks -
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 -
DSUM DAVERAGE DCOUNT SUBTOTAL Data Validation - List Formulas -
Importing from Text Importing from Access Export to Text -
Freeze Panes Group & Outline Printing Large Docs 3D Formulas Consolidate -
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 -
Go To Blanks by Color Delete Empty Rows Go to Constants Row Differences -
Find & Replace Intro -
Conditional Formatting a Cell's Value Conditional Formatting to Find Blank Cells -
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 -
Special Number Formats Fill In Empty Cells -
Goal Seek Solver Data Table Scenario Manager -
[QUIZ] Intermediate - Analysis -
Unlock your Certificate of Completion
Pricing options
Explain how different pricing options might be valuable to different segments of your audience.
-
Free
Regular price