Microsoft Office Excel

Microsoft Office Excel is deservedly the industry standard in Spreadsheet applications. It is the workhorse of many offices, with such diverse uses as compiling lists, filtering data, performing calculations of staggering complexity, goal seeking, scenarios and so on. But typically, users learn only those features they actually need to complete their jobs, while remaining ignorant of the many ways Excel could actually help them work smarter and faster.

In addition to the Introduction, Intermediate and Advanced courses, we offer an extra Business Analysis course for Excel in which we cover business-specific tasks. Versions for Excel 2000, XP and 2003 are supported, with 2007 being added shortly.

Introduction - Course content

Spreadsheet terminology

Exploring the Excel window
Getting help
Opening and navigating workbooks
Closing workbooks

Entering and Editing data

Creating workbooks
Entering and editing labels and values
Entering and editing formulas
Saving and updating workbooks

Modifying a Worksheet

Moving and copying data
Moving and copying formulas
Using absolute references
Inserting and deleting ranges

Using Functions

Entering functions
Using AutoSum
Using AVERAGE, MIN, and MAX

Formatting Worksheets

Formatting text
Formatting rows and columns
Number formatting
Using Format Painter and AutoFormat

Printing

Preparing to print
Page Setup options
Printing worksheets

Creating Charts

Chart basics
Modifying charts
Printing charts

Web Features

Saving workbooks as Web pages
Hyperlinks
Sending workbooks via email

Intermediate - Course content

Working with Large Worksheets

Viewing options
Hiding and displaying data
Printing large worksheets

Working with Multiple Worksheets and Workbooks

Using multiple worksheets
Linking worksheets by using 3-D formulas
Consolidating data
Linking workbooks
Managing workbooks

Customising Excel

Changing options
Customising toolbars and menus

Advanced Charting

Chart formatting options
Creating combination charts
Using graphic elements

Advanced Formatting

Borders and shading
Using special number formats
Working with dates
Working with styles
Other advanced formatting

List Management

Working with lists
Sorting and filtering lists
Advanced filtering

Documenting and Auditing

Comments and text boxes
Auditing features
Protection
Workgroup collaboration

Using Templates

Built-in templates
Creating and managing templates

Advanced - Course content

Working with Advanced Formulas

Using names
Using decision-making functions
Creating nested functions
Using financial functions

Lookups and Data Tables

Working with lookup functions
Creating data tables

Advanced List Management

Creating subtotals
Validating cell entries
Exploring database functions

Working with Pivot Tables and Pivot Charts

Working with Pivot Tables
Rearranging Pivot Tables
Formatting Pivot Tables
Working with Pivot Charts

Exporting and Importing

Exporting and importing text files
Querying external databases

Using Analytical Options

Working with Goal Seek and Solver
Working with scenarios
Working with views

Working with Macros

Running and recording a macro
Viewing VBA code
Function procedures

Interactive Web Pages

Creating interactive Web spreadsheets
Publishing Pivot tables on the Web

Business Analysis - Course content

Working with Pivot tables and Pivot charts

Working with Pivot tables
Rearranging Pivot tables
Formatting Pivot tables
Working with Pivot charts

Exporting and Importing

Exporting and importing text files
Querying external databases

Using Analytical Options

Working with Goal Seek and Solver
Working with scenarios
Working with views

Working with Macros

Running and recording a macro
Viewing VBA code
Function procedures

Interactive Web Pages

Creating interactive Web spreadsheets
Publishing Pivot tables on the Web

Shortcuts

Navigating large spreadsheets quickly
Go To
Copying filtered and sorted lists into printable worksheets