Course Outline
Microsoft Excel 2007 - Intermediate
Hands-on training in an instructor-led environment. One workstation per
delegate and exercises to consolidate learning.
Training Method:
Existing users of Microsoft Excel 2007, or as a follow on from our Introduction to
Excel 2007 course.
One day
Upon successful completion of the course, delegates will have an understanding of and be able to use
Excel for charting, and utilise essential features to enable them to create more complex worksheets
and workbooks and advanced formatting.
Existing users of Microsoft Excel 2007.
Designed for:
Module 1: Multiple Worksheets and
Using multiple worksheets
Inserting new worksheets
Renaming worksheets
Deleting worksheets
Creating multiple views
Freezing panes
Viewing & arranging multiple worksheet windows
Navigating in multiple workbooks
Selecting and viewing multiple workbooks
Creating and opening a workspace
Managing multiple worksheets and workbooks
Selecting multiple worksheets
Moving and copying data between worksheets
Linking data between worksheets
Creating a 3-D formula
Module 2: Charting
Using charts
Creating a chart, Moving a chart, Resizing a chart
Changing the layout and style
Labelling chart elements
Formatting chart text and chart elements
Changing the chart type
Showing or hiding gridlines
To modify chart gridlines
Customising axes
Creating a pie chart
Changing, adding and deleting a chartís source
Moving a chart to a different worksheet
Saving a chart template
Printing charts
Module 3: Advanced Functions
Creating and using functions
Using built-in functions
Use formula auto complete
Working with arguments: the PMT function
Using dates and times
Using dates in calculations
Using nested functions
Auditing worksheets
Identifying the auditing commands
The watch window
The formula evaluator
Tracing and correcting worksheet errors
Module 4: Advanced Formatting
Using comments in a worksheet
Reviewing, showing and hiding comments
Deleting a comment
Applying or customising document themes
Working with cell styles
Using format painter
Applying table styles
Excel tables
Filtering data using auto filter
Creating custom filters
Advanced filtering
Using templates
Creating a template
Editing a template
Verifying your work
Using auto correct
* Public Courses
* Private Courses
* Customised Courses
* On site training available
Tel: 01625 549287