Microsoft Excel Level 3
Free
Microsoft Excel Level 3

Microsoft Excel Level 3

Event Information

Share this event

Date and Time

Location

Location

2E Room 108

Event description

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

Share with friends

Date and Time

Location

2E Room 108

Save This Event

Event Saved