Microsoft Excel 2007 - Advanced Guides (Level 3)
Aims
This course is a flexible, workshop style session, which covers either one or some of the advanced features of Excel (Level 3). It is suitable for users who have been using Excel for some time, and feel confident with using it. Depending on what is wanted by those attending a particular session, users may be taught as a large group, in smaller groups, or you may need to work through the documentation provided yourself, with support from the course trainers.
There are advanced sessions for specific topics, and a general one in which participants can expect to cover between 2 and 4 topics from those described below, in a 2 hour session.
Objectives
By the end of the session, participants should be able to use between 2 and 4 of the features from the list below, using the notes provided to help them (all PDF documents unless otherwise stated):
- Microsoft Excel 2007 Cell Formats and Styles
- Microsoft Excel 2007 Cell Validation
- Microsoft Excel 2007 Charts
- Microsoft Excel 2007 Comments
- Microsoft Excel 2007 Dates and Times
- Microsoft Excel 2007 Filters
- Microsoft Excel 2007 Forms
- Microsoft Excel 2007 Functions
- Microsoft Excel 2007 Goal Seek and Solver
- Microsoft Excel 2007 Iteration and Animation
- Microsoft Excel 2007 Macros
- Microsoft Excel 2007 Microsoft Query
- Microsoft Excel 2007 Pivot Tables
- Microsoft Excel 2007 Security
- Microsoft Excel 2007 Series and Custom Lists
- Microsoft Excel 2007 Sorting, Subtotals and Outlines
- Microsoft Excel 2007 Splitting Windows and Fixing Panes
- Microsoft Excel 2007 Templates
Format
2 hour hands-on session, on PCs either in groups, or working individually from notes with support from the trainers with further demonstration via overhead projection.