Class Length: 6 hrs./l day (Standard); 12 hrs./2 days (Beginner)
Class Cost: $300 (Standard); $600 (Beginner)
Target Student: Students with a foundational understanding of Excel 2019 levels 1 and 2 but also desiring to utilize higher-level functionality. Students are likely need to troubleshoot large, complex workbooks, automate repetitive tasks, engage in collaborative partnerships involving workbook data, construct complex Excel functions, and use those functions to perform rigorous analysis of extensive, complex datasets.
Course Prerequisites: To ensure success, students should have completed Microsoft Excel 2019 levels 1 and 2, have the equivalent knowledge/experience or pre-test with the required knowledge.
- Work with multiple worksheets and workbooks
- Share and protect workbooks
- Automate workbook functionality
- Use Lookup functions and formula auditing
- Forecast data
- Create sparklines and map data