Advanced Microsoft Excel 2007 / 2010

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

This course is sutiable for people who have attended the intermediate course or have good knowledge and understanding of Excel 2007 and would like to explore the more complex functionality it can offer.

• Learn how to use advanced 'if' statements and macros to automate repetitive tasks.
• Be able to 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.

• group and outline features
• linking worksheets
• goal seek to reverse calculate a formula
• creating single input data tables
• setting up and manipulating scenarios for what-if? analysis
• named ranges
• consolidating data by position
• text functions in Excel 2007
• nested if statements
• use of lookup functions
• use of logical functions
• create a pivot table report
• analysing data with pivot tables
• manipulate the pivot table
• formatting pivot tables
• creating pivot charts
• grouping data in pivot tables
• setting up database querieis
• connecting Excel to the web to import data
• recording macros
• edit a macro
• creating buttons to run the macros
• creating your own menu.

A working knowledge of Microsoft intermediate topics, which can be gained at Intermediate Microsoft Excel 2007 / 2010.

General information

This course is held by Reed Learning and endorsed by CIMA as suitable for members and their staff and colleagues.

The course starts at 9.30 and ends at 16.30 each day. Lunch and refreshments are included. It is non-residential.

12 CPD hours (where applicable)

CIMA Mastercourses held in partnership with BPP

Find out more
If you have any queries please email or phone us on +44 (0)845 026 4722.

CIMA on demand
CIMA on demand is a high quality online professional development solution, specifically designed for busy finance and business professionals. Find out more.