Microsoft Excel - Level 3 (10 Hours)

COURSE OBJECTIVES

Once you complete Excel 2016 - Part 3, you’ll be able to perform advanced data analysis, collaborate on workbooks and automate workbook functionality.

This course empowers you to:

• Refer to internal and external worksheets
• Perform LOOKUPs and audit formulas
• Share and protect workbooks
• Automate workbook functionality using validation rules and macros
• Create sparklines and map data
• Forecast data

COURSE OUTLINE

1 - WORKING WITH MULTIPLE WORKSHEETS & WORKBOOKS

• Reference Cells and Groups of Cells Across Worksheets
• Link Cells to External Worksheets
• Consolidate Data Across Worksheets

2 - USING LOOKUP FORMULAS AND FORMULA AUDITING

• Search Rows or Columns Using LOOKUP Functions
• Display Relationships Between Cells and Formulas with the Trace Command
• Watch Cells and Formulas From the Watch Tool

3 - SHARING AND PROTECTING WORKBOOKS

• Collaborate on Workbooks
• Apply Varying Levels of Workbook Access and Protections

4 - AUTOMATING WORKBOOK FUNCTIONALITY

• Create and Manage Validation Rules and Lists
• Search for Invalid Data and Formulas with Errors
• Record Macros to Automate Tasks

5 - CREATING SPARKLINES AND MAPPING DATA

• Create Sparklines to Show Trends
• Map Data

6 - FORECASTING DATA

• Determine Potential Outcomes Using Data Tables and Scenarios
• Solve for Desired Outputs with the Goal Seek Feature
• Forecast Data Trends

Actual course outline may vary depending on Students pace of learning.