Course Features

Interactive Quizzes
High Quality Video
Learn On The Go
You Choose The Pace

Overview

This course is designed for frequent users of Excel. Techniques used enable participants to become more productive in the workplace.

Objectives

Upon successful completion of the course users will be able to utilise the features of Excel to create scenarios and customise Excel matching a given criteria using set exercises.

Requirements

Users who have attended Excel Level 1 and Level 2 courses or who have a good working knowledge of Excel.

Course Information

Lessons: 13

Pre-Requisites: Excel Basic & Intermediate

Content Length: TBD

Recommended Time To Complete: 14 hours

Tutor

Linda Boyham
Linda Boyham

With over 25 years of experience, Linda is the perfect tutor to learn from. You are guaranteed to pick up useful hints and tips that are invaluable to you and that you're unlikely to receive anywhere else

Course Outline

Customising the Workspace
Lessons
Existing Toolbars
Creating New Toolbars
Creating & Using Styles
Creating Templates
Creating a Workspace
'What If' Scenarios
Lessons
Goal Seeker
Scenario Manager
Create a Scenario
Scenario Summary
Solver
Auditing
Lessons
Audit a Worksheet
Trace Dependents
Trace Precedents
Trace Errors in Cells
Custom Views
Lessons
Grouping & Outlining
Creating Views
Show Views
Report Manager
Lessons
Create Reports
Insert Scenarios
Insert Views
Pivot Tables
Lessons
Creating Pivot Tables
Manipulating
Formatting
Formulae within Pivot Tables
PivotCharts
Macros
Lessons
Record Macros
Assign to the toolbar
Assign to a shortcut key
800*600 SPECIALIST TRAINING