header

Microsoft Office Excel

Lack of training holding you back?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, 2003 and 2007 are available.

Introduction - Course content

Spreadsheet terminology Entering and Editing data
Exploring the Excel window Creating workbooks
Getting help Entering and editing labels and values
Opening and navigating workbooks Entering and editing formulas
Closing workbooks Saving and updating workbooks
Modifying a Worksheet Using Functions
Moving and copying data Entering functions
Moving and copying formulas Using AutoSum
Using absolute references Using AVERAGE, MIN, and MAX
Inserting and deleting ranges Using Autocalculate
Formatting Worksheets Printing
Formatting text rows and columns Preparing to print
Number formatting Page Setup options
Using Format Painter and AutoFormat Printing worksheets
Creating Charts Web Features
Chart basics Saving workbooks as Web pages
Modifying charts Hyperlinks
Printing charts Sending workbooks via email
 

Intermediate - Course content

Working with Large Worksheets List Management
Viewing options Working with lists
Hiding and displaying data Sorting and filtering lists
Printing large worksheets Advanced filtering
Multiple Worksheets and Workbooks Advanced Formatting
Using multiple worksheets Borders and shading
Linking worksheets by using 3-D formulas Using special number formats
Consolidating data Working with dates
Linking workbooks Working with styles
Managing workbooks Other advanced formatting
Customising Excel Using Templates
Changing options Built-in templates
Customising toolbars and menus Creating and managing templates
Advanced Charting Documenting and Auditing
Chart formatting options Comments and text boxes
Creating combination charts Auditing features
Using graphic elements Protection and collaboration
 

Advanced - Course content

Working with Advanced Formulas Pivot Tables and Pivot Charts
Using names Working with Pivot Tables
Using decision-making functions Rearranging Pivot Tables
Creating nested functions Formatting Pivot Tables
Using financial functions Working with Pivot Charts
Working with Macros Interactive Web Pages
Running and recording a macro Creating interactive Web spreadsheets
Viewing VBA code Publishing Pivot tables on the Web
Function procedures  
Lookups and Data Tables Exporting and Importing
Working with lookup functions Exporting and importing text files
Creating data tables Querying external databases
Advanced List Management Using Analytical Options
Creating subtotals Working with Goal Seek and Solver
Validating cell entries Working with scenarios
Exploring database functions Working with views
 

Business Analysis - Course content

Working with Advanced Formulas Pivot Tables and Pivot Charts
Using named rangess Creating and formatting Pivot Tables
Using decision-making functions Working with Pivot Charts
Creating nested functions Condensing large amounts of data
Using financial functions Publishing Pivot tables on the Web
Lookups and Data Tables Exporting and Importing
Working with lookup functions Exporting and importing text files
Single and double variable data tables Querying external databases
Advanced List Management Using Analytical Options
Creating subtotals Working with Goal Seek and Solver
Data Validation Working with scenarios
Exploring database functions Working with views
Outlining What If analysis