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