Microsoft Excel: Advanced

in Media Training (England)

Classes Course

Place:

London

Price:

Ask the course provider

Duration:

On request

Start:

consult dates and times
See course programme

Course objectives:

This course is designed for those who require a greater knowledge of the more advanced features of Excel including Goal Seek, What-if scenarios and pivot tables. This is a ¿power-user' course and you will leave able to create and customise your own macros and utilise Excel's auditing tools. This outline is based on Microsoft Excel 2007 (or Excel 2008 if you...

See course programme
Course details
venues and dates
Course alerts similar to these

More courses Subject area

Place

Request information

Contact directly and with no obligation with

Media Training

You must complete all fields on this form in order for us to send it to the course provider.
We have highlighted incomplete/ incorrect details in red.

* Compulsory fields

*Name *Surname

*E-mail

*Country/ region *Area/ County

*I would like more information on

By clicking "Email request / Telephone" you registering and accepting the Terms of Use and privacy policy of Emagister.

I wish to receive the personalised newsletter (during a maximum period of 15 days)

Availability?
How do I enrol?
Where can I get more information?

The person in charge of this course will receive your information request instantly.

Response time:

:| :) ;)

Average Fast Very fast

Course details

Type Course Duration On request

Method / place Contact course provider Classes in London where

Course objectives This course is designed for those who require a greater knowledge of the more advanced features of Excel including Goal Seek, What-if scenarios and pivot tables. This is a ¿power-user' course and you will leave able to create and customise your own macros and utilise Excel's auditing tools. This outline is based on Microsoft Excel 2007 (or Excel 2008 if you...

Price

Ask
the
course provider

back
Course programme
ex-students and opinions

Get direct information on how to enrol, venues and availability...

Excel courses (from other course providers)

Excel Advanced
Pass training
London - £210 + VAT

Advanced Microsoft Excel
Reed Learning
London - £495 + VAT

Excel Advanced
Nobleprog Limited
London - £630 + VAT

MS Excel Level 3: Advanced
Wise Ltd.
London - £210 + VAT

Excel XP Advanced
2e2 Training
London - £250 + VAT

Compare the selected courses

+ excel Courses + Excel Courses in London + Courses in London + Media Training Courses

Course programme

Microsoft Excel: Advanced

Course Overview

This course is designed for those who require a greater knowledge of the more advanced features of Excel including Goal Seek, What-if scenarios and pivot tables.

This is a ¿power-user' course and you will leave able to create and customise your own macros and utilise Excel's auditing tools.

This outline is based on Microsoft Excel 2007 (or Excel 2008 if you are a Mac user). If you are using a different version, please give us a call on 020 7359 9855.
Course content

Introduction
· Problem solving
· Using Goal Seek
· Using Solver
· Using Scenario Manager
· Merging scenarios

Advanced features
· Lookup functions
· Nesting functions
· Data functions
· Financial functions

Advanced data management
· Advanced filters
· Using formulas as filters
· Creating Pivot tables
· Using analysis tools
· Smart documents
· Creating histograms
Forms
· Understanding how forms work
· Text boxes and list boxes
· Combo boxes
· Check and option boxes
· Command buttons

Macros
· Understanding macros
· Recording a macro
· Customising a macro

Auditing
· Excel's auditing tools
· Data entry validation
· Error checking
· Watch window

Questions and answers

see the full course programme