Excel - Intermediate

Course curriculum

1. 1 - Excel Intermediate Introduction
2. 2 - Intermediate Shortcut Keys
1. 3 - What are Lists?
2. 4 - Sorting a List
3. 5 - Sorting - Multiple Criteria
4. 6 - Custom Sort
5. 7 - What are Filters
6. 8 - Format a List as a Table
1. 9 - Introduction to DataBase Functions
2. 10 - DSum Function
3. 11 - DSum Function - Single Criteria
4. 12 - DSum Function - Multiple Criteria
5. 13 - DAverage
6. 14 - DCount Function
7. 15 - Subtotal
1. 16 - Data Validation - List
2. 17 - Data Validation - Decimal
3. 18 - Input and Error Messages
1. 19 - Importing Data from Text Files
2. 20 - Importing Data from MS Access
3. 21 - Exporting Data to a Text File
1. 22 - Creating Basic Charts
2. 23 - The Chart Ribbon
3. 24 - Formatting Charts
1. 25 - Understanding Pivot Tables
2. 26 - Creating Pivot Tables
3. 27 - Pivot Table Calculations
4. 28 - Grouping Pivot Table Data
5. 29 - Formatting Pivot Table Data
6. 30 - Drilling Down into Pivot Table Data
7. 31 - Creating Pivot Charts
8. 32 - Filtering Pivot Table Data
9. 33 - Filtering using the Slicer
1. 34 - Grouping Data
2. 35 - Consolidating Data
1. 36 - VLookUp
2. 37 - HLookUp
3. 38 - Index and Match
1. 39 - FV Function
2. 40 - PMT Function
3. 41 - Hyperlinks
4. 42 - Text to Columns
1. 43 - Excel Intermediate - Conclusion