Microsoft Excel 2003 - Advanced Guides

Aims

This course is a flexible, workshop style session, which covers either one or some of the advanced features of Excel. 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:

• Adding_Comments_in_Microsoft_Excel_2003
• Cell_Formats_and_Styles_in_Microsoft_Excel_2003
• Cell Validation in Microsoft Excel 2003
• Dealing_with_Dates_and_Times_in_Microsoft_Excel_2003
• Extending_a_Series_and_Creating_a_Custom_List_in_Microsoft_Excel_2003
• Getting_Data_using_MS_Query_in_Microsoft_Excel_2003
• Goal_Seek_and_Solver_in_Microsoft_Excel_2003
• Iteration_and_Animation_in_Microsoft_Excel_2003
• Setting_Options_and_Customising_Microsoft_Excel_2002
• Setting_Security_in_Microsoft_Excel_2003
• Some_Useful_Functions_in_Microsoft_Excel_2003
• Sorting, Subtotals and Outlines in Microsoft Excel 2003
• Splitting_Windows_and_Fixing_Panes_in_Microsoft_Excel_2003 
• Templates_in_Microsoft_Excel_2003
• Using_Filters_in_Microsoft_Excel_2003
• Using_Forms_in_Microsoft_Excel_2003
• Using_Pivot_Tables_in_Microsoft_Excel_2003
• Writing_Macros_in_Microsoft_Excel_2003

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.