Professor Teaches Excel 2003

Custom Tutorial Set Create and purchase your own Custom Tutorial Set that contains just the courses you want.
The Fastest, Easiest Way to Learn Excel 2003!
Professor Teaches courses use real-world settings and accurate simulations to help you apply your new knowledge directly to daily tasks and the knowledge you gain becomes an asset for life.

Chapter #1. Office Workspace Basics
• Basic Window Elements
• Menu Features
• Customizing Menus and Toolbars
• Getting Help

Chapter #2. Introduction to Excel
• What is Excel?
• Starting Excel
• Getting to Know the Excel Screen
• Navigating an Excel Workbook
• Selecting and Moving Cells
• Inserting and Deleting Cells
• Using Cut, Copy, and Paste
• Using Find and Replace
• Saving a Workbook
• Exiting Excel

Chapter #3. Creating and Editing Workbooks
• Creating New Workbooks
• Entering Data
• Working with AutoComplete
• Including Calculations
• Introduction to Functions
• Copying Formulas
• Using Undo and Redo
• Using AutoCalculate
• Working with Worksheets
• Linking Formulas
• Using The Error Checking Smart Tag

Chapter #4. Working with Functions
• Inserting Functions
• Supplying Function Arguments
• Controlling Calculations
• Determining Calculation Accuracy
• Evaluating Formulas
• Introduction to Financial Functions
• Using FV and PMT Functions
• Specifying Conditions with IF
• Using Date and Time Functions

Chapter #5. Formatting Workbooks
• Adjusting Column and Row Sizes
• Changing Cell Alignment
• Using Number Formatting
• Formatting Text
• Using the Format Painter
• Using Styles and AutoFormatting
• Finding and Replacing Formats
• Using the Spelling Checker
• Working with AutoCorrect
• Using AutoFill

Chapter #6. Adding Charts and Pictures
• Creating a Chart
• Formatting Charts
• Modifying Chart Data
• Changing Chart Types
• Using Drawing Tools
• Inserting Graphics
• Printing a Chart
• Adding Hyperlinks

Chapter #7. Viewing and Printing
• Viewing the Worksheet
• Splitting and Freezing a Worksheet
• Using AutoFilter
• Adding Headers and Footers
• Working with Page Setup
• Setting a Print Area
• Using Print Preview and Printing
• Saving a Workbook as a Web Page
• Adding Comments
• E-Mailing a Workbook