Feedback

Feedback to trainingforit.co.uk


Site comment Site ratings
Email (optional)

Content

Design

Ease of use

Overall

Advanced Microsoft Excel XP / 2003

Summary
Length:
2 days
Price:
350 GBP excl. VAT
Training Provider:
Reed Learning PLC plusReed Learning PLC
Location:
Training Method:
Startdate:  
London: 21/03/2012, 12/04/2012, 02/05/2012
Edinburgh: 02/05/2012, 31/07/2012, 29/10/2012

About Advanced Microsoft Excel XP / 2003

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

Suitability and application

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 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

Expenses

£350.00 + VAT

About Reed Learning PLC

Reed Learning Short Courses and Professional Qualifications

Reed Learning

Short Courses and Professional Qualifications

Reed Learning is one of the biggest business training companies in the UK. We’re part of the Reed group of companies, founded 50 years ago and still family-run.

Public, scheduled training courses

We run more than 250 different short courses. In the last 10 years we’ve trained over 150,000 people, including 20,000 new managers, 12,000 people who were scared of doing presentations, and 14,000 who needed to learn to prioritise.

Our core areas are:

  • Management & leadership
  • Personal Development including Communication, Anger, Stress & Time Management
  • Project Management
  • Health & Safety
  • Microsoft & Google
  • Sales, Customer Service & Marketing
  • HR & Training
  • PA & Secretarial

We also offer a brand new range of virtual classrooms on our most requested topics. These 75 minute sessions provide tutor-led, concentrated tuition in core subjects."

People choose us because our trainers are experienced, we have a vast choice of programmes, our rates are very reasonable and because our training makes people feel motivated and full of ideas to use back at work. 

Try one of our courses – we guarantee you’ll feel it's worthwhile, or your money back. 

Professional qualifications

Reed Learning offers one of the widest choices of professional qualifications in the UK, including:

  • Chartered Management Institute management qualifications at levels 3 to 5, new CMI one-day qualifications and Chartered Manager qualification
  • Postgraduate Certificate in International Business from Royal Holloway, University of London
  • ASTD & CIPD qualifications in training, L&D and HR
  • Senior management accelerated route to Chartered Banker status
  • The UK’s first Certificate in Professional PA & Secretarial Skills, in partnership with the Institute of Professional Administrators
  • ISMM Diploma in Advanced Sales and Marketing
  • NEBOSH national certificate and the IOSH Managing Safely programme

In-house / on-site training

As well as our scheduled courses, we can come to you. We run successful on-site training for some huge organisations like Sky, the AA and Pepsi, and some smaller ones like the Welsh Language Board, Webworks and London Borough of Brent

Outsourcing & Managed Services

We run outsourced training services, providing trainers, scheduling courses and taking care of all the administration. Our clients span the banking, local government and media sectors, and in the past five years we’ve helped them save hundreds of thousands of pounds.

Get in touch

Whether you want to book a short course, arrange something in-house or discuss your organisation’s learning strategy, we’ll bend over backwards to deliver the right training programme at the right price.

Contact us and tell us what you’re looking to achieve this year here.


plus Show all courses with Reed Learning PLC

Request information - obligation free

Get more information from Reed Learning PLC by filling out the following form. This is a free service for you and the course provider to help you find the most suitable training.
To request information from Reed Learning PLC, please fill out the following details:
* =  Required field
Email Address*
First Name*
Last Name*
Company
Position
Town/City*
Telephone*
Start date
Number of participants
Message*
Rules

Contact information for Reed Learning PLC

Reed Learning PLC

9 Kingsway
WC2B 6XF London

Phone no: 020 7520 5100
www.reedlearning.co.uk

More Information
Request Information
To request information from Advanced Microsoft Excel XP / 2003, please fill out the following details:

What happens now?
Be Inspired - watch the training videos
   
Reviews by course participants
Number of reviews 1
Number of grades: 1

Course Materials

Networking with other delegates

Trainer / Provider

Venue / Facilities


Do you recommend the provider:
100% - Yes
0% - No

Show all reviews Show all reviews
Write a course review
Have you studied » Advanced Microsoft Excel XP / 2003 at » Reed Learning PLC? Share your experience & help others to pick the right course. Set grades (1-5) where 1= very poor & 5 = excellent.
V. Poor | Poor | OK | Good | Excellent
Trainer / Provider
Venue / Facilities
Course Materials
Networking with other delegates

Do you recommend the provider:


Need help finding the right course?

  
By submitting your e-mail, you become a member of Trainingforit.co.uk