...take part

Don't just take our word for it

We ask all our past delegates to rate our courses so you can decide if this course is really right for you - just click 'Hear what people say' to read ratings. If you've been on a course, log in to 'My Reed Learning' and leave your review to help others decide.

Advanced Microsoft Excel XP/2003 Course

  • Duration:2 Days
  • Cost:£350 + VAT
  • Ref:ADEXP

Expert guidance through MS Excel’s most powerful features

Book now >

Cost £350.00 Duration 2 days Code ADEXP

Course rating:

(0  vote)

What's this?

  • Hear what people say
  • Send to a friend
  • Add to favourites

Who is it for

Suitable for people who have attended the intermediate course or have good knowledge and understanding of Excel and would like to explore the more complex functionality it can offer. Not sure if this is the right level for you? Why not take our short online test to see >

Prerequisites
A working knowledge of Microsoft intermediate topics or attendance to our Intermediate Microsoft Excel course.

What is it about

A detailed coverage of the advanced features of MS Excel providing you with the knowledge and confidence to manage complex and large data sets.

Course Overview

  • Goal Seek to reverse calculate a formula
  • Creating Single Input Data Tables
  • Setting up and manipulating scenarios for What-If? Analysis
  • Consolidating Data by position
  • Consolidate by Label
  • Group And Outline Features
  • Reports from new
  • Analysing Data with Pivot Tables
  • Manipulate the Pivot Table
  • Formatting Pivot Tables
  • Creating Pivot Charts
  • Grouping data in Pivot Tables
  • Importing Text Files
  • Setting Up Database Queries
  • Connecting Excel to the Web to Import Data
  • Recording Macros
  • Edit a Macro
  • Creating Buttons to Run the Macros
  • Customize Access to Excel Commands
  • Adding Icons to the Toolbars
  • Creating your own Menu
  • Editing Menus
  • Adding Options to Menus to run Macros

What will I get out of it?

  • Learn how to use advanced ‘If’statements and macros to automate repetitive tasks
  • Be able to use analysis tools to forecast figures based on a range of scenarios
  • An advanced understanding of the applications of MS Excel and the ability to put them into practice

Accredited by

This course is accredited for CPD

  • Hear what people say
  • Send to a friend
  • Add to favourites

Need help?

Use our <STRONG>LiveChat</STRONG> service to talk directly to one of our operators

Use our LiveChat service to talk directly to one of our operators

Open LiveChat

What's new this month >