Advanced Microsoft Excel Training

If you know the basics of Excel, including entering data, formatting cells, using functions and formulae and inserting charts and graphs, this Advanced Excel course will really unlock the power of the programme and its advanced functionality.

Microsoft Excel is a very powerful spreadsheet application designed to save you time and make easy work of calculating, displaying and sharing data.

This Advanced Excel training course will introduce you to some of excels more powerful features.

Need help NOW?! Learn Excel basics step-by-step with our Free Microsoft Excel 2007 Tutorial

We also provide private and in-company Microsoft Excel courses. Call +44 (0) 1273 622272 to discuss.

VIDEO: Using Goal Seek in Excel

What our clients say about our Advanced Excel Training Course

The Advanced Excel course was well paced so you learnt along the way and the course ran very smoothly.
Dr Eric Rirsch - Safeguard Europe

Advanced Excel Course Objectives

This one-day Excel Training course shows how you can use Excel to manage a spreadsheet, create advanced charts, use some of the advanced functions of MS Excel.

Advanced Excel Training Course Prerequisites

Delegates attending this excel course should understand the basic concepts of creating an Excel Spreadsheet, or have attended our Beginners Excel training course.

Advanced Excel Course Content

Absolute Cell Addressing

• Using Absolute References

Naming Cells and Ranges

• Using the Create Method to Name Cells
• Using the Names Box to Name Cells
• Using Insert Name Define
• Working with Named Ranges

Data Consolidation

• Consolidating Data across Worksheets
• Consolidating Data across Workbooks

Conditional Functions

• Introduction to If
• Using Nested If's
• Using SumIf and CountIf

Lookup Functions

• Using Vlookup
• Using Hlookup

Data Validation

• Using the Data Validation feature
• Finding Invalid Data

Conditional Formatting

• Setting Up Conditional Formats
• Using Formulae in Conditional Formats
• Using Conditional Formats to find MIN and MAX

Working with Data Lists

• Sorting
• Subtotals
• Filtering

Pivot Tables

• Using the Pivot Table Wizard
• Modifying the Pivot Table

Data Tables

• Creating Data Tables
• One Way and Two Way Tables

Advanced Excel Course Recommended Reading

Learn Excel 2007 Expert skills With The Smart Method: Courseware Tutorial teaching Advanced Techniques

Excel 2007 Bible