Training
Topics
Access
Excel
Microsoft Office
Open Office
Outlook
Powerpoint
Publisher
Word
|
Training Overview: Intermediate Microsoft Excel
This course is designed for existing Microsoft Excel users, or those that have attended the Microsoft Excel Introduction training course, who wish to explore the application further.
Course Content
Review of Excel Basics
- Basic formulae: +, -, *, /
- Autosum
- Autofill
- Charts
- Exporting worksheets and charts into a document
Working with Worksheets
- Renaming, inserting, deleting, moving and copying worksheets
- Grouping worksheets
- Creating links between worksheets and performing calculations
Data Lists
- Sorting & filtering
- Sub-totals
Functions
Other Formulae
- % calculations
- Absolute cell referencing
Other
- Freeze panes
- Word wrap
- Diagonal text
- Using autosum for sub totals and grand totals
- Comments
Format
This course is instructor led in a classroom environment. We recommend a maximum of 8 delegates per course to ensure that all delegates gain the maximum benefit from the course.
Duration
This is a one day course. Standard hours are 9:30 to 16:30, with a one hour lunch break, and short breaks mid morning and mid afternoon. It may be possible to change this arrangement by request.
|
