Excel 2003 Basic + Certblaster, 2nd Edition Study Guide

1-4188-8931-8 © 2007 Publish date: January 26, 2006 212 pages

Buy Now: $25.99

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

CBT Planet has a series of computer training books designed to teach you how to use Microsoft Excel. The Excel 2003 Basic study guide, which has earned a 4.9/5.0 rating in overall quality from ProCert Labs, will teach you basic functions and features of Microsoft Excel 2003.

You will learn the basics of using spreadsheets, how to enter and edit data, how to work with labels, and how to use formulas. You will also learn about functions, formatting cells, printing Excel worksheets, creating charts, and saving workbooks as Web pages.

The Excel 2003 Basic courseware is approved curriculum for the Microsoft Office Specialist certification. This study guide is an excellent choice for learning the foundation-level knowledge of this powerful spreadsheet application. You can set your own pace and progress through the course's eight comprehensive units according to your own goals and needs.

By studying each section and doing the included activities, you will get an overview of how to begin using Microsoft Excel for a variety of functions. By the end of the Microsoft Excel training course, you will be comfortable with the Excel environment and be able to create workbooks with simple formulas. You will also be able to examine your data graphically by creating basic charts.

Course Objectives

You will learn about Excel's main components, how to create a workbook, and how to use the Help feature. The course teaches you how to enter and edit labels, values, and formulas as well as how to find and replace formulas. You will learn about working with relative and absolute references, moving and copying data, inserting and deleting ranges, using functions to perform calculations such as SUM, AVERAGE, and MIN. You will also learn shortcuts such as the AutoSum feature.

Formatting of text, numbers, rows, and columns is covered along with controlling the Page Setup options and printing worksheets.

Other topics of this courseware include creating, formatting, modifying, and printing charts, saving worksheets as Web pages, using the AutoRepublish feature, inserting and editing hyperlinks, and sending workbooks over e-mail.

Course Contents

Unit 1 introduces Microsoft Excel

• Spreadsheet terminology
• The Excel window
• Getting help
• Opening and navigating around workbooks
• Closing workbooks

Unit 2 covers data entry and editing data

• Creating workbooks
• How to enter and edit labels and values
• How to enter and edit formulas
• Saving and updating workbooks

Unit 3 discusses modifying worksheets

• How to move and copy data
• How to move and copy formulas
• Working with absolute references
• How to insert and delete ranges

Unit 4 covers working with functions

• Entering functions
• Working with AutoSum
• Working with AVERAGE, MIN, and MAX

Unit 5 discusses formatting worksheets

• Formatting text
• Formatting rows and columns
• Number formatting
• Using Format Painter and AutoFormat

Unit 6 covers printing

• Preparing to print a worksheet
• Setting Page Setup options
• Printing Microsoft Excel worksheets

Unit 7 talks about creating charts

• Chart basics
• Modifying charts
• Printing charts

Unit 8 covers Web features

• Saving workbooks as Web pages
• Hyperlinks
• Sending workbooks via e-mail

Appendix A covers instant messaging

Appendix B discusses alternative user input

• Speech recognition
• Handwriting recognition

Appendix C details the Microsoft Office Specialist exam objectives maps

• Specialist exam objectives
• Expert exam objectives