Excel 2003 Intermediate, 2nd Edition + Certblaster Study Guide

1-4188-8934-2 © 2007 Publish date: January 18, 2006 210 pages

Buy Now: $25.99

Course ID: excel-2003-int-2nd-sg

If you have the basics of using Microsoft Excel down and are ready to learn intermediate skills, choose the Excel 2003 Intermediate study guide from our line of computer training books dedicated to teaching you Microsoft Excel.

This intermediate course is rated 4.9/5.0 in overall quality from the professionals at ProCert Labs. By choosing the Excel 2003 Intermediate courseware, you will learn how to use the intermediate-level features and functions of Excel 2003. This course focuses on teaching you how to work with large worksheets, how to use 3-D formulas, how to customize the toolbars and menus, how to apply special cell formatting, and how to sort and filter lists. Other topics include creating combination charts and trend lines, using auditing features, and working with templates.

Not only is this course highly rated, it is also approved courseware for the Microsoft Office Specialist certification. If you are seeking this credential, choosing the Excel 2003 Intermediate courseware is an excellent tool for preparing for your certification exam.

Due to the self-directed nature of this Microsoft Excel training program, you can take as long as you need to fully learn the concepts and techniques. It may take just one day of focused studying or you can learn at a slower pace. The only person you have to answer to is yourself.

Course Objectives

By following the course, you will learn how to navigate large worksheets by enabling magnification, freezing panes, and splitting panes. You will also learn how to control printing these large worksheets.

In this courseware you'll learn about navigating, managing, and printing a set of multiple worksheets, linking workbooks with 3-D formulas, and using the Consolidate command to summarize data. Other topics discuss how you can change view settings, general settings, and calculation settings, customizing toolbars and menus, adding borders and shading, working with styles, sorting and filtering using complex criteria, formatting data points, working with combination charts and trend lines, and using graphic elements.

In addition, you'll learn how to work with the auditing features, how to add comments and text boxes, how to protect worksheets, how to use the built-in templates, and how to create custom templates.

Course Contents

Unit 1 introduces large worksheets

• Viewing options
• How to hide, display, and outline data
• How to print large worksheets

Unit 2 covers working with multiple worksheets and workbooks

• Working with multiple worksheets
• Linking worksheets with 3-D formulas
• Consolidating data
• How to link workbooks
• Managing workbooks

Unit 3 discusses customizing Excel

• Working with the Options dialog box
• Customizing Excel's toolbars and menus

Unit 4 covers advanced formatting

• Borders and shading
• Working with special number formats
• Using dates
• Using styles
• Other advanced formatting topics

Unit 5 discusses list management

• Examining lists
• How to sort and filter lists
• Advanced filtering topics

Unit 6 covers advanced charting topics

• Chart formatting options
• Working with combination charts
• Working with graphic elements

Unit 7 talks about documenting and auditing

• Auditing features
• Comments and text boxes
• Enabling protection
• Workgroup collaboration

Unit 8 covers working with templates

• Microsoft Excel's built-in templates
• Creating and managing templates

Appendix A talks about integrating with the Web

Appendix B covers the Microsoft Office Specialist exam objectives maps

• Specialist exam objectives
• Expert exam objectives