Advanced Microsoft Excel 2007 / 2010

This course is aimed at learners who have a good grounding in Excel (any version, but Excel 2007 or 2010 are 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 useful. You will also find it helpful if you spend most of your working day using Excel and would like to fill in gaps in your knowledge.

This course focuses on the vast array of functionality Microsoft Excel 2007/10 offers focused on manipulating and analysing data. This course goes into detail on how to normalise data and analyse it with Pivot Tables.

The programme also covers importing data using queries, preparing and analysing data with What If functions and Scenario building. You will also discover how to record and run your own macros.

• 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

• Understanding of how to locate errors in formulas and evaluate them

• The ability 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

• Text functions in Excel

• Count functions

• Advanced ‘If’ statements

• Create a pivot table reports from new

• Analysing data with pivot tables

• Manipulating pivot tables

• Formatting pivot tables

• Creating pivot charts

• Grouping data in pivot tables

• Adding Slicers (2010)

• 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

• Editing macros

• Creating buttons to run macros

• Customising access to Excel commands

• Adding icons to the toolbars

• Creating your own tab (2010)

• Editing menus

• Adding options to menus to run macros

All of our courses are worth 6 hours of CPD per day.

I really enjoyed the course, the trainer was excellent, facilities were perfect and I feel I learned more than I expected to, I’d highly recommend it. “

- Martin Eaton

Copyright Licensing Agency