Advanced Microsoft Excel 2007

Duration: 1 Day

Objectives

To provide greater data management skills and to build more advanced function-based formulae. Delegates will also learn how to analyse data with Goal Seek and Scenario features.

Pre-requisites

Good knowledge of Excel, or previous attendance on the Intermediate Excel course.

Course includes

A comprehensive set of reference notes covering course topics, follow-up telephone support and, for training on Transmedia premises, lunch and refreshments.

This course is available as a private or customised course. Please phone us on 0208 269 4260 or email us for further information and to customise this course to your exact requirements.

"An enjoyable and productive day. A flexible content and pace of work which suited our needs"

Guardian News & Media

Course outline

Data manipulation
• Advanced Data techniques
• Advanced Sorting techniques
• Advanced Filtering techniques
• Creating Outlines
• Subtotals
• Pivot Tables & Charts

Advanced Formulae
• More advanced functions using the Formulas Tab
• The Lookup Function
• VLookup
• Statistical Functions
• Combining Extraction with Statistics

Advanced Tools
• Custom Number Formats
• Array Formulae
• What If Analysis
• Overview of Using Scenario Manager
• Scenario Command
• Setting a Scenario
• Using Goal Seek
• Connections with other data sources
• Importing Data
• Data Validation