\ Home ► Catalogue ► Course Information
| |
|
|
Course description |
|
A short course for advanced Microsoft Office Excel 2003 users. The course is divided in 3 topics providing training on advanced cell formatting, creating charts and graphs, headers and footers, and using macros; how to manage large spreadsheets, use advanced functions, import external data, use grouping, outline and list functions; use conditional statements and formatting, advanced formulas, PivotTables and PivotChart Reports, and using various keyboard shortcuts and Excel toolbars. |
| |
Course classification |
|
| Category: |
Microsoft Excel |
| Type: |
Short Course |
| Credits: |
NA |
| Keywords: |
Microsoft, Excel, Office, Computing |
| Part of: |
|
|
| |
Course details |
| Duration: |
6 Hours |
| Next start date: |
2009-12-03 |
| Language: |
English |
| Target audience: |
Advanced Microsoft Office Excel 2003 users |
| Requirements: |
Access to Microsoft Office Excel 2003. Completion of the Microsoft Office Excel 2003 (Novice) and Microsoft Office Excel 2003 (Intermediate) courses may assist. |
|
| |
Course outcomes |
After completion of this course you will have an advanced understanding of Microsoft Office Excel 2003. In completing this course you will also have achieved the following outcomes:
- You will have an advanced understanding of cell formatting, creating charts and graphs, inserting headers and footers and using macros;
- You will know how to manage large spreadsheets, use advanced Excel functions, import external data into your spreadsheet, use grouping and outline functions and create lists;
- You will know how to create conditional statements, apply conditional formatting, use advanced formulas, insert PivotTables and PivotChart Reports, use keyboard shortcuts, and the various Excel toolbars.
|
| |
Pricing |
|
| |
Available discounts |
|
No bulk discounts are available.
|
| |
Referral commission |
|
| |
Provider and course managers |
|
| |
| |
|
|
|
|
|
