Feedback

Feedback to trainingforit.co.uk


Site comment Site ratings
Email (optional)

Content

Design

Ease of use

Overall

Advanced Microsoft Excel 2007™

Summary
Length:
2 days
Price:
350 GBP excl. VAT
Training Provider:
Reed Learning PLC plusReed Learning PLC
Location:
Training Method:
Startdate:  
London: 23/02/2012, 26/03/2012, 26/04/2012

About Advanced Microsoft Excel 2007™

Microsoft Excel 2007 offers a vast array of functionality to assist in manipulating and analysing data. This course looks at importing data using queries, whether from the web or databases, prepping the data and analysing it with What If, Scenario building and Pivot tables. You will also discover how to record and run your own macros.Course Overview
  • Text functions in Excel 2007
  • Count functions
  • Advanced ‘If’ statements
  • Create a pivot table reports from new
  • Analysing data with pivot tables
  • Manipulate the pivot table
  • Formatting pivot tables
  • Creating pivot charts
  • Grouping data in pivot tables

  • Auditing Worksheets
  • Trace cell precedents & cell dependents
  • Locate errors in formulas
  • Locate invalid data and formulas
  • Watch and evaluate formulas
  • Goal seek to reverse calculate a formula
  • Creating single input data tables
  • Dual input data tables
  • Setting up and manipulating scenarios for What-If? analysis
  • Consolidating data by position
  • Consolidate by label
  • Group And outline features
  • 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

Delegates should have a good grounding in Excel (any version, but Excel 2007 is preferable) either from experience or attending our Intermediate Microsoft Excel training course. If your job involves manipulating and analysing data in Excel, you will find this course very advantageous. You will also find it useful if you spend most of your working day using Excel and would like to fill in gaps in your knowledge.
Not sure if this level is right for you? Why don't you take our quick online test to find out >

What will I get out of it?

  • The skills to import data into Excel, prepare it and set up pivot tables to analyse it
  • The knowledge to record macros and create icons on the toolbars to run them
  • Understand how to locate errors in formulas and evaluate them
  • Be able to use analysis tools to forecast figures based on a range of scenarios
  • Ensure important data is highlighted by summarising large workbooks and sorting data into key elements
  • Useful practical exercises
  • Free attendance on a refresher course within a year

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 2007™, please fill out the following details:

What happens now?
Be Inspired - watch the training videos
   
Write a course review
Have you studied » Advanced Microsoft Excel 2007™ 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