Home » Training Courses » Microsoft Office and Desktop Applications Training » Advanced Microsoft Excel Training

Advanced Microsoft Excel Training

1 days - £215 + vat

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

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.

Microsoft Excel Course Objectives

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

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

Excel Course Recommended Reading

Excel 2007 Step by Step by Curtis D. Frye - buy from amazon

Download course outline as pdf.

+44 (0)1273 622272

Advanced Microsoft Excel Training course dates

31 Mar 2010
21 May 2010
7 Jul 2010
25 Aug 2010
11 Oct 2010
29 Nov 2010