MS Excel – Level 3

On completion of this course, students will be able to implement high level functions and perform analysis by using standard reports.

Target Audience:

This course is intended for students experienced in Excel who need to advance their skills in working with more advanced Excel features.

View Brochure


Working with Multiple Worksheets and Workbooks SimultaneouslyUse 3-D references
Use links and external references
Consolidate data
Sharing and Protecting WorkbooksCollaborate on a workbook
Protect worksheets and workbooks
Automating Workbook FunctionalityApply data validation
Work with forms and controls
Work with macros
Applying Conditional LogicUse Lookup functions
Combine functions
Use formulas and functions to apply conditional formatting
Auditing WorksheetsTrace cells
Search for invalid data and formulas with errors
Watch and evaluate formulas
Using Automated Analysis ToolsDetermine potential outcomes using data tables
Determine potential outcomes using scenarios
Use the goal seek feature
Activate and use the solver tool
Analyse data with analysis ToolPak tools
Presenting Your Data VisuallyUse advanced chart features
Create Sparklines