Instructor Led Toolbar Training Classes in Canada
From Last Minute Training
Microsoft Excel 2003 XP Level I
Start with the basics, including elements of Excel screen, simple formulas (Sales-Expenses=Profit), operators: + - = / * ^, cut, copy, paste using toolbar, menu bar, mouse and keyboard, working with workbooks, worksheets, tabs, moving/ copying worksheets, formatting labels and values, AutoFormat; basic functions (SUM, AVG, MIN, MAX, NOW), printing, calculating percentages, relative/ absolute cell
more...
Microsoft Excel 2003 XP Level II
Start with the basics, including elements of Excel screen, simple formulas (Sales-Expenses=Profit), operators: + - = / * ^, cut, copy, paste using toolbar, menu bar, mouse and keyboard, working with workbooks, worksheets, tabs, moving/ copying worksheets, formatting labels and values, AutoFormat; basic functions (SUM, AVG, MIN, MAX, NOW), printing, calculating percentages, relative/ absolute cell
more...
Microsoft Excel 2003 Level 3

...
Recording a Macro
Running a Macro
Adding a Macro to a Toolbar
Understanding the Macro Code
Absolute and Relative References
The Personal Macro Workbook
Section 3 - Outlines
Outline Basics
Creating an Outline
Collapsing and Expanding an Outline
Manual Outline
Section 4 - Excel Functions
Function Basics
The PMT Function
The Goal Seek Function
The IF Function
The VLOOKUP Function
more...
Microsoft Access 2003 Level 3 (1 Day)

...
Outline
Section 1
Formatting Fonts with the Formatting Toolbar
Changing Text Alignment
Using AutoFormat
Changing Colors
Applying Special Effects
Using the Format Painter
Adding Pictures and Lines
Aligning Controls with One Another
Changing a Control s Formatting Properties
Section 2
Creating and Running a Macro
Editing a Macro
Working with Macro Groups
Assigning a Macro to an
more...
Microsoft Excel 2003 Level 3
...
Recording a Macro
Running a Macro
Adding a Macro to a Toolbar
Understanding the Macro Code
Absolute and Relative References
The Personal Macro Workbook
Section 3 - Outlines
Outline Basics
Creating an Outline
Collapsing and Expanding an Outline
Manual Outline
Section 4 - Excel Functions
Function Basics
The PMT Function
The Goal Seek Function
The IF Function
The VLOOKUP
more...
