Sales Ended

Microsoft Excel Level 3

Event Information

Share this event

Date and Time



2E Room 108

Event description


Excel Level 3

Module 1: Working with Multiple Worksheets and Workbooks Simultaneously

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

Module 2: Sharing and Protecting Workbooks

Collaborate on a Workbook
Protect Worksheets and Workbooks

Module 3: Automating Workbook Functionality

Apply Data Validation
Work with Forms and Controls
Work with Macros

Module 4: Applying Conditional Logic

Use Lookup Functions
Combine Functions
Use Formulas and Functions to Apply Conditional Formatting

Module 5: Auditing Worksheets

Trace Cells
Search for Invalid Data and Formulas with Errors
Watch and Evaluate Formulas

Module 6: Using Automated Analysis Tools

Determine Potential Outcomes by Using Data Tables
Determine Potential Outcomes by Using Scenarios
Use the Goal Seek Feature
Activate and Use the Solver Tool
Analyze Data with Analysis ToolPak Tools

Module 7: Presenting Your Data Visually

Use Advanced Chart Features
Create Sparklines

Date and Time


2E Room 108

Save This Event

Event Saved