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).
You can also purchase the
workbooks for these courses separately.
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®
Introduction
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®
Intermediate
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®
Introduction 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® Advanced
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® Intermediate 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® 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
|
