Description

Unit Standard: 258876

Course Schedule

1. Importing and Exporting Data
2. Consolidating and Linking Data
3. Working with Filtered Data (including subtotals)
4. Advanced Filtering
5. Using Forms to input data
6. Creating and using Macros
7. Conditional Formatting
8. Editing Macros in VBA
9. Creating Pivot Tables
10. Working with Pivot Tables
11. Using the Pivot Table Tabs
12. Creating Pivot Charts
13. Working with Pivot Charts
14. Using charts for data analysis
15. Creating and using PowerPivots to build reports