Excel Advanced 2003 & 2007

Excel Advanced 2003 & 2007

About the Course

Who is the course for?
Users who want to improve their knowledge of Excel and follows on directly from our intermediate course where many of the topics are introduced.
Study Mode
Short Course

Introduction Course Outcome:
Participants will be able to use Excel to present information in different financial modals

Key Objectives To introduce the more advanced techniques available in Excel spreadsheets.

Course Units
· Use "If", "With", "And/Or" nested functions
· Working with named cell ranges
· Goal Seek
· Advanced Functions
· Lookup Tables
· Macros
· Scenarios builder
· Pivot Tables

Duration 1 day

Tuition Fees(Cost) £99

Progression Route Excel VBA