Microsoft Excel Level 3

Prerequisites: To ensure success, students should have practical, real-world experience creating and analyzing datasets using Excel 2021. Specific tasks students should be able to perform include: creating formulas and using Excel functions; creating, sorting, and filtering datasets and tables; presenting data by using basic charts; creating and working with PivotTables, slicers, and PivotCharts; and customizing the Excel environment. To meet these prerequisites, students can take the following Logical Operations courses, or should possess the equivalent skill level:

• Microsoft® Office Excel® 2021: Part 1
• Microsoft® Office Excel® 2021: Part 2

Lesson 1: Working with Multiple Worksheets and Workbooks

• Use Links and External References
• Use 3-D References
• Consolidate Data

Lesson 2: Sharing and Protecting Workbooks

• Collaborate on a Workbook
• Protect Worksheets and Workbooks

Lesson 3: Automating Workbook Functionality

• Apply Data Validation
• Search for Invalid Data and Formulas with Errors
• Work with Macros

Lesson 4: Using Lookup Functions, Dynamic Arrays, and Formula Auditing

• Use Lookup Functions
• Use Dynamic Arrays and Dynamic Array Functions
• Trace Cells
• Watch and Evaluate Formulas

Lesson 5: Forecasting Data

• Determine Potential Outcomes Using Data Tables
• Determine Potential Outcomes Using Scenarios
• Use the Goal Seek Feature
• Forecast Data Trends

Lesson 6: Creating Sparklines and Mapping Data

• Create Sparklines
• Map Data