Microsoft Excel 2021 Level 3

Categories: Worksafe

Course Prerequisite(s)

Please note that this course has the following prerequisites which must be completed before it can be accessed
Microsoft Excel 2021 Level 2

About Course

This course builds upon the foundational and intermediate knowledge presented in Excel 2021 Level 1 and Excel 2021 Level 2. Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.

Course Content

Working with Multiple Worksheets and Workbooks
➢ Use Links and External References ➢ Use 3-D References ➢ Consolidate Data

Sharing and Protecting Workbooks
➢ Collaborate on a Workbook ➢ Protect Worksheets and Workbooks

Automating Workbook Functionality
➢ Apply Data Validation ➢ Search for Invalid Data and Formulas with Errors ➢ Work with Macros

Using Lookup Functions, Dynamic Arrays, and Formula Auditing
➢ Use Lookup Functions ➢ Use Dynamic Arrays and Dynamic Array Functions ➢ Trace Cells ➢ Watch and Evaluate Formulas

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

Microsoft Excel 2021 Level 3

Course Prerequisite(s)

About Course

What Will You Learn?

Course Content

Working with Multiple Worksheets and Workbooks
➢ Use Links and External References ➢ Use 3-D References ➢ Consolidate Data

Sharing and Protecting Workbooks
➢ Collaborate on a Workbook ➢ Protect Worksheets and Workbooks

Automating Workbook Functionality
➢ Apply Data Validation ➢ Search for Invalid Data and Formulas with Errors ➢ Work with Macros

Using Lookup Functions, Dynamic Arrays, and Formula Auditing
➢ Use Lookup Functions ➢ Use Dynamic Arrays and Dynamic Array Functions ➢ Trace Cells ➢ Watch and Evaluate Formulas

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

Creating Sparklines and Mapping Data
➢ Create Sparklines ➢ Map Data

Course Prerequisite(s)

About Course

What Will You Learn?

Course Content

Working with Multiple Worksheets and Workbooks ➢ Use Links and External References ➢ Use 3-D References ➢ Consolidate Data

Sharing and Protecting Workbooks ➢ Collaborate on a Workbook ➢ Protect Worksheets and Workbooks

Automating Workbook Functionality ➢ Apply Data Validation ➢ Search for Invalid Data and Formulas with Errors ➢ Work with Macros

Using Lookup Functions, Dynamic Arrays, and Formula Auditing ➢ Use Lookup Functions ➢ Use Dynamic Arrays and Dynamic Array Functions ➢ Trace Cells ➢ Watch and Evaluate Formulas

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

Creating Sparklines and Mapping Data ➢ Create Sparklines ➢ Map Data

Working with Multiple Worksheets and Workbooks
➢ Use Links and External References ➢ Use 3-D References ➢ Consolidate Data

Sharing and Protecting Workbooks
➢ Collaborate on a Workbook ➢ Protect Worksheets and Workbooks

Automating Workbook Functionality
➢ Apply Data Validation ➢ Search for Invalid Data and Formulas with Errors ➢ Work with Macros

Using Lookup Functions, Dynamic Arrays, and Formula Auditing
➢ Use Lookup Functions ➢ Use Dynamic Arrays and Dynamic Array Functions ➢ Trace Cells ➢ Watch and Evaluate Formulas

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

Creating Sparklines and Mapping Data
➢ Create Sparklines ➢ Map Data