...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 2010 Course

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

Become an expert user of new Excel 2010 at an advanced level with the latest techniques and features.

Book now >

Cost £350.00 Duration 2 days Code ADE10

Course rating:

(0  vote)

What's this?

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

Who is it for

This course is suitable for people who have attended the Intermediate Microsoft Excel 2010 course or have good knowledge and understanding of Excel 2010 need to discover how pivot tables and macros are set up.
Not sure if this level is right for you? Contact our team on 0800 170 7777 to discuss it.

What is it about

This course focuses on advanced methods of data management.

Course Overview

  • What are pivot tables
  • Creating a pivot table from scratch
  • Setting up pivot charts
  • Updating pivot tables
  • Utilising the new slicers features
  • Adding formulas to pivots
  • Using pivot tables to analyse data
  • New features added in Excel 2010
  • Advanced 'if' statements
  • Utilising count functions
  • Data consolidation by position
  • Consolidating data using labels
  • Goal seeking
  • Building your first scenario
  • Data projection using 'what if'
  • Adding new sparklines
  • Setting up data tables
  • Using the worksheet as a database
  • Building advanced filters
  • Using outlining to handle large worksheets
  • What is a macro?
  • Recording macros
  • Running macros from a shortcut
  • Editing macros
  • Creating icons to run macros
  • Customising the ribbon

What will I get out of it?

  • Learn how to summarise large workbooks with pivot tables including new and updated options for Office Excel 2010
  • Discover how to apply the new sparklines features to highlight trends in the data
  • Learn how to use analysis tools to forecast figures based on a range of scenarios and use consolidation to bring together information from separate spreadsheets and workbooks
  • Gain a complete understanding of the database features
  • How to apply filters and sort data into key elements including the new slicers introduced in 2010
  • Find out how you can utilise advanced 'If' statements and macros to automate repetitive or tedious tasks and customise the ribbon interface

Accredited by

This course is accredited for CPD

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

Other  options

Interested in a 75 minute Virtual Classroom on this topic?

Find out more here

What's new this month >