Advanced Microsoft Excel
This comprehensive Excel lab provides hands-on experience with advanced Excel features essential for data analysis, collaboration, and automation. Students will progress through six interconnected exercises that build practical skills used in professional business environments.
Course Curriculum
Lesson 1: Using PivotTables
In this lesson, you will master PivotTable creation and customization techniques. You'll learn to implement interactive filters, create calculated fields, group data effectively, and build corresponding PivotCharts for dynamic data analysis.
Estimated Duration: 2 h 0 m
Hands-On Exercises
Exercise 1: Using PivotTables
In this exercise, you will master PivotTable creation and customization techniques. You'll learn to implement interactive filters, create calculated fields, group data effectively, and build corresponding PivotCharts for dynamic data analysis.
Estimated Time: 30 minutes
Lesson 2: Advanced Functions
In this lesson, you will master Excel's most sophisticated functions for data manipulation, including array formulas, lookup functions, and dynamic data processing capabilities.
Estimated Duration: 2 h 0 m
Hands-On Exercises
Exercise 2: Advanced Functions
In this exercise, you will master Excel's most sophisticated functions for data manipulation, including array formulas, lookup functions, and dynamic data processing capabilities.
Estimated Time: 30 minutes
Lesson 3: Auditing Workbooks
In this lesson, you will develop skills to inspect, debug, and validate Excel workbooks using built-in auditing tools and advanced debugging techniques.
Estimated Duration: 2 h 0 m
Hands-On Exercises
Exercise 3: Auditing Workbooks
In this exercise, you will develop skills to inspect, debug, and validate Excel workbooks using built-in auditing tools and advanced debugging techniques.
Estimated Time: 30 minutes
Lesson 4: Data Tools
In this lesson, you will master Excel's data import, transformation, and analysis tools for working with external data sources and performing advanced data operations.
Estimated Duration: 2 h 0 m
Hands-On Exercises
Exercise 4: Data Tools
In this exercise, you will master Excel's data import, transformation, and analysis tools for working with external data sources and performing advanced data operations.
Estimated Time: 30 minutes
Lesson 5: Recording and Using Macros
In this lesson, you will learn to automate repetitive tasks using Excel macros, from basic recording through editing and deployment strategies.
Estimated Duration: 2 h 0 m
Hands-On Exercises
Exercise 5: Recording and Using Macros
In this exercise, you will learn to automate repetitive tasks using Excel macros, from basic recording through editing and deployment strategies.
Estimated Time: 30 minutes
Lesson 6: Working with Others
In this lesson, you will master Excel's collaboration features including comments, protection, sharing, and version control for team-based work environments.
Estimated Duration: 2 h 0 m
Hands-On Exercises
Exercise 6: Working with Others
In this exercise, you will master Excel's collaboration features including comments, protection, sharing, and version control for team-based work environments.
Estimated Time: 30 minutes