INTRODUCTION TO EXCEL
click below for
The Fundamentals
Lesson 1 1: Starting Excel
Lesson 1 2: What’s New in Excel 2002?
Lesson 1 3: Understanding the Excel Program Screen
Lesson 1 4: Using Menus
Lesson 1 5: Using Toolbars and Creating a New Workbook
Lesson 1 6: Filling Out Dialog Boxes
Lesson 1 7: Keystroke and Right Mouse Button Shortcuts
Lesson 1 8: Opening a Workbook
Lesson 1 9: Saving a Workbook
Lesson 1 10: Moving the Cell Pointer
Lesson 1 11: Navigating a Worksheet
Lesson 1 12: Entering Labels in a Worksheet
Lesson 1 13: Entering Values in a Worksheet and Selecting a Cell Range 2
Lesson 1 14: Calculating Value Totals with AutoSum
Lesson 1 15: Entering Formulas
Lesson 1 16: Using AutoFill
Lesson 1 17: Previewing and Printing a Worksheet
Lesson 1 18: Getting Help from the Office Assistant
Lesson 1 19: Changing the Office Assistant and Using the “What’s This” Button
Lesson 1 20: Closing a Workbook and Exiting Excel
Editing a Worksheet
Lesson 2 1: Entering Date Values and using AutoComplete
Lesson 2 2: Editing, Clearing, and Replacing Cell Contents
Lesson 2 3: Cutting, Copying, and Pasting Cells
Lesson 2 4: Moving and Copying Cells with Drag and Drop
Lesson 2 5: Collecting and Pasting Multiple Items
Lesson 2 6: Working with Absolute and Relative Cell References
Lesson 2 7: Using the Paste Special Command
Lesson 2 8: Inserting and Deleting Cells, Rows, and Columns
Lesson 2 9: Using Undo, Redo, and Repeat
Lesson 2 10: Checking Your Spelling
Lesson 2 11: Finding and Replacing Information
Lesson 2 12: Advanced Printing Options
Lesson 2 13: File Management
Lesson 2 14: Inserting Cell Comments
Lesson 2 15: Understanding Smart Tags
Lesson 2 16: Recovering Your Workbooks
Formatting a
Worksheet
Lesson 3 1: Formatting Fonts with the Formatting Toolbar
Lesson 3 2: Formatting Values
Lesson 3 3: Adjusting Row Height and Column Width
Lesson 3 4: Changing Cell Alignment
Lesson 3 5: Adding Borders
Lesson 3 6: Applying Colors and Patterns
Lesson 3 7: Using the Format Painter
Lesson 3 8: Using AutoFormat
Lesson 3 9: Creating a Custom Number Format
Lesson 3 10: Creating, Applying, and Modifying a Style
Lesson 3 11: Formatting Cells with Conditional Formatting
Lesson 3 12: Merging Cells, Rotating Text, and using AutoFit
Lesson 3 13: Finding and Replacing Formatting
Creating and Working
with Charts
Lesson 4 1: Creating a Chart
Lesson 4 2: Moving and Resizing a Chart
Lesson 4 3: Formatting and Editing Objects in a Chart
Lesson 4 4: Changing a Chart’s Source Data
Lesson 4 5: Changing a Chart Type and Working with Pie Charts
Lesson 4 6: Adding Titles, Gridlines, and a Data Table
Lesson 4 7: Formatting a Data Series and Chart Axis
Lesson 4 8: Annotating a Chart
Lesson 4 9: Working with 3-D Charts
Lesson 4 10: Selecting and Saving a Custom Chart
Lesson 4 11: Using Fill Effects
Managing Your
Workbooks
Lesson 5 1: Switching Between Sheets in a Workbook
Lesson 5 2: Inserting and Deleting Worksheets
Lesson 5 3: Renaming and Moving Worksheets
Lesson 5 4: Working with Several Workbooks and Windows
Lesson 5 5: Splitting and Freezing a Window
Lesson 5 6: Referencing External Data
Lesson 5 7: Creating Headers, Footers, and Page Numbers
Lesson 5 8: Specifying a Print Area and Controlling Page Breaks
Lesson 5 9: Adjusting Page Margins and Orientation
Lesson 5 10: Adding Print Titles and Gridlines
Lesson 5 11: Changing the Paper Size and Print Scale
Lesson 5 12: Protecting a Worksheet
Lesson 5 13: Hiding Columns, Rows and Sheets
Lesson 5 14: Viewing a Worksheet and Saving a Custom View
Lesson 5 15: Working with Templates
Lesson 5 16: Consolidating Worksheets