Microsoft Excel 2003: Intermediate

 

Audience: This course is designed for any student already familiar with Excel and who is interested in learning more advanced skills. This class is the second of an optional three-class set.

 

Syllabus: This course will incorporate both real-life labs and instructor-led lectures and will include 8 hours of total class time. The following is an outline of the syllabus directly from the learning guide:

 

· Working with large worksheets

· Viewing options

· Hiding, displaying, and outlining data

· Printing large worksheets

· Using multiple worksheets and workbooks

· Using multiple worksheets

· Linking worksheets by using 3-D formulas

· Consolidating data

· Linking workbooks

· Managing workbooks

· Customizing Excel

· Using the Options dialog box

· Customizing toolbars and menus

· Advanced formatting

· Borders and shading

· Using special number formats

· Working with dates

· Working with styles

· Other advanced formatting

· List management

· Examining lists

· Sorting and filtering lists

· Advanced filtering

· Advanced charting

· Chart formatting options

· Using combination charts

· Using graphic elements

· Documenting and auditing

· Auditing features

· Comments and text boxes

· Protection

· Workgroup collaboration

· Using templates

· Built-in templates

· Creating and managing templates

· Web discussions

· Creating and responding to Web discussions