Microsoft Excel Training Courses:
Four hours per week during 4 weeks
Microsoft Excel is the world's premier spreadsheet software. It boasts an extremely powerful infrastructure incorporating complex tools for data analysis and manipulation with a user-friendly interface and huge range of time-saving shortcuts and helpers.
Microsoft Excel is one of the regular scheduled computer training courses, held at our central North York training centre, and we can also organize in-house training anywhere in GTO. The course comprises:
Part 1: Introduction to Excel
Part 2: Advanced Excel
Tuition: $795 CA
|
Part 1: Introduction to Excel
Our Introduction to Excel assumes no prior knowledge of the program and allows users to grasp key spreadsheet concepts as well as getting to grips with the powerful time-saving features unique to Excel.
Basics |
|
Standard toolbar overview
Formatting toolbar overview
Data entry
Block selection
Copying data
Moving data
Inserting cells, rows and columns
Deleting cells, rows and columns
Resizing rows and columns
Using the AutoFit facility
Undoing and redoing operations
Spell checking
Printing a spreadsheet |
|
Formatting |
|
Setting alignment
Using cell shading
Adding borders to cells
Using Autoformat
Number and date Formats
Creating styles
Applying styles
Modifying Styles
Using conditional formatting
|
|
|
Formulas |
|
Formulas
How formulas work
About cell references
About Excel ranges
Overview of functions
Using the AutoSum facility
Using the formula palette
Using conditionals
Statistical functions
Financial functions
Creating external references
|
Charts |
|
Creating a chart
Setting chart options
Editing chart elements
Editing chart data
Adding logos and graphics
Printing charts |
|
Productivity |
|
Creating reports
Setting print options
Creating custom lists
AutoCorrect
Password protecting documents
Protecting worksheets
Using hyperlinks
Save As Web Page
Web Page Preview |
|
| |
|
|
« Back to menu
|
Part 2: Advanced Excel
Our Advanced Excel course enhances users' knowledge by delving deeper into Excel's powerful data modeling and what-if analysis tools.
Data manipulation |
|
|
Automatic outlining
Group and ungroup
Filtering data
Advanced filtering
Sorting data
Inserting Subtotals
Creating an Advanced Filter
Single input data tables
Double input data tables |
|
|
|
Formulas and functions |
|
|
Complex If statements
Using nested functions
Using named regions
Using lookup functions
Using database functions
The DSUM Function
The DAVERAGE Function
The DCOUNT Function
The DGET Function
The DMIN Function
The DMAX Function |
|
|
|
Tools |
|
|
Creating scenarios
Scenario summary reports
Protecting scenarios
Using Goal Seek
Using the Solver
Working with views |
|
|
|
|
|
|
|
What-if analysis |
|
Overview of PivotTables
The PivotTable Wizard
Formatting PivotTables
Rearranging PivotTables
Sorting data
Grouping data
Using AutoShow
Overview of PivotCharts
The PivotChart Wizard |
|
Macros |
|
Recording a Macro
Running a Macro
Macro buttons |
|
Collaboration |
|
Working with Shared Workbooks
Reviewing Workbooks
Sending Workbooks
Tracking changes
Resolving conflicts
Merging Workbooks |
|
|
|
|
| |
|
« Back to menu
REGISTRATION FORM
REGISTRATION STEPS:
- Fill out our Registration form.
- One of our staff members will contact you at the telephone number you included on
your registration form to confirm your registration.
|
« Back to menu
2 methods of payment
The payment is made:
- by a credit card (VISA, MASTERCARD and AMERICAN EXPRESS)
- from your PayPal account through the system PayPal
 
|
|
« Back to menu
|
