Professor Teaches Excel 2003
Also compatible with Windows® Vista™, XP & 2000
Custom Tutorial Set
Create 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
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