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 (no certificates issued for Q&A sessions).
You can also purchase the
workbooks for these courses separately.
Introduction to
Microsoft Excel®
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 hours
You'll need:
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
Intermediate
Microsoft Excel®
Take the next step! When you've completed this
Intermediate
level 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
- Introduction to
Microsoft Excel® 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
Advanced Microsoft
Excel®
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
- Intermediate Microsoft
Excel® 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® Power User
These are the skills that make you stand out at the
office!
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
- Advanced Microsoft
Excel® or equivalent experience
You'll learn:
- Advanced pivot tables
- Pivot charts
- Drawing toolbar
- Control toolbox
- Database functions
- Online collaboration
- Customization
- Watch window
- Data consolidation
- Group and outline
- List
- Track changes
- Text to speech
|
