Course Outline

Excel 2003/2007/2010: Intermediate

Days: 1

Prerequisites: Excel Introduction or equivalent experience

Unit 1 : Working with large worksheets

· Viewing options

· Hiding/displaying data

· Printing large worksheets

Unit 2 : Multiple worksheets and workbooks

· Using multiple worksheets

· Linking worksheets using 3-D formulas

· Consolidating data

· Linking workbooks

Unit 3 : Customizing Excel

· Changing options

· Customizing toolbars and menus

Unit 4 : Advanced charting

· Formatting chart options

· Creating combination charts

· Adding graphic elements

Unit 5 : Advanced formatting

· Borders and shading

· Special number formats

· Dates

· Styles

· Other advanced formatting

Unit 6 : List management

· Creating lists

· Sorting and filtering lists

· Advanced filtering

Unit 7 : Documenting and auditing

· Comments and text boxes

· Auditing features

· Protection

Unit 8 : Using templates

· Built-in templates

· Creating and managing templates

Appendix A : Collaborating with a workgroup

· Sharing workbooks

· Managing changes

· Merging a shared workbook

Appendix B : Additional functions

· IF, PMT, and FV