Site Map | Privacy | Careers | FAQ | Contact Us

Computer Training: MS Excel®

Click here for the PDF Course Outline

When you complete any of these MS Excel® training courses, you'll receive a certificate to confirm your proficiency. You can also "pick and choose" topics from any of these courses for Q&A sessions or Project Kickstarts (no certificates issued for Q&A or Kickstart sessions).

Advanced Macro Workshop

You can also purchase the workbooks for these courses separately.

Would you like more information about how our Excel® sessions can be tailored to your needs?

Click here to have us call you. OR Take a skill assessment.

Level 1 Computer Literacy

Note: To get the most out of your Microsoft Excel® instruction, we recommend that you first master the skills in our Computer Literacy course.

Microsoft Excel® Level 2

Using spreadsheets in MS Excel® will simplify routine calculations and help you present numeric information in a way that's easy to understand and manipulate.

Average course time: 3 - 4 hours

You'll need:

Computer Literacy or equivalent experience
A working computer with Windows® installed on it
Microsoft Excel® 6.0 or higher or Microsoft Office® 97 or higher

You'll learn:

What is a spreadsheet
What is a workbook
Cell references and ranges
Navigating between sheets
Columns vs rows
Inserting rows and columns
Formatting text
Formatting worksheets
Autoformat
Data types
Basic formulas
Locked cells and protection
Sizing cells
Introduction to 3D references
Printing and emailing worksheets

Microsoft Excel® Level 3

Take the next step! When you've completed this course, you'll feel confident and competent working with most spreadsheets that are regularly used in business.

Average course time: 3 - 4 hours

You'll need:

A working computer with Windows® installed on it
Microsoft Excel® 6.0 or higher or Microsoft Office® 97 or higher
Microsoft Excel® Level 2 or equivalent experience

You'll learn:

Formulas: IF, SUMIF, COUNT, COUNTIF, MIN, MAX, AVERAGE
Autocalculate average, count, min, max, count num
Absolute values
External references and linked workbooks
Inserting pictures and graphics
Hyperlinks
Smart tags
Sorting
Subtotals
Formula vs Value displays
Conditional formatting
Find and replace
Current date and date formats
Basic filters and AutoFilter
Freeze and split window
Naming cells and ranges
Headers/footers
Merge and centre button
Rotating text in a cell
Saving worksheets as web pages

Microsoft Excel® Level 4

If you deal with complex documents, you need more advanced skills:

Average course time: 3 - 4 hours

You'll need:

A working computer with Windows® installed on it
Microsoft Excel® 6.0 or higher or Microsoft Office® 97 or higher
Microsoft Excel® Level 3 or equivalent experience

You'll learn:

Charts and Graphs
Templates
Auditing
Databases
Database entry forms
Advanced Filters
Macros
Web queries to import external data
Goal seek
Scenarios
Basic pivot tables
Lookup
Data validation, input and error messages
Comments

Microsoft Excel® Advanced Macro Workshop

If you want to go beyond simple macro recording, the Advanced Macro Workshop will make you a whiz! You'll learn how to create and customize macros within Microsoft Visual Basic, so that you can automate and simplify repetitive but complex activities.

Average course time: 6 hours

You'll need:

A working computer with Windows® installed on it
Microsoft Excel® 6.0 or higher or Microsoft Office® 97 or higher
Advanced Microsoft Excel® macro training or equivalent experience

You'll learn:

About macro structures
How to create and modify macros using the Visual Basic for Excel interface
Hands-on experience and examples in creating complex macros