Working with Excel Windows

Working with Worksheets

Using Menu Commands

Moving and Resizing Toolbars

Changing Menu and Toolbar Options

Using the Task Pane

Displaying/Hiding the Office Assistant

Using the Office Assistant

Finding an Answer

Changing the Office Assistant Options

Using Ask a Question

Entering Text into Cells

Entering Numbers into Cells

Saving a New Workbook

Closing a Workbook

Creating a New Workbook

Using a Template

Opening an Existing Workbook

Using Data Entry Shortcuts

Editing Cell Entries

Checking Worksheet Spelling

Creating a New Folder

Renaming an Existing Workbook

Working with Ranges

Selecting Ranges with Keyboard & Mouse

Selecting Non-adjacent Ranges

Entering Values into a Range

Using the Auto Fill Feature

Using Formulas

Entering Formulas

Using Functions

Using the AutoSum button

Using the AutoSum List

Entering Basic Functions

Inserting Functions in Formulas

Editing Functions

Using the AutoCalculate Feature

Using Range Borders to Modify Formulas

Checking Errors

Copying/Cutting and Pasting Data

Using the Paste Options Button

Using the Paste List

Using the Clipboard Task Pane

Creating an Absolute Reference

Filling Cells

Using Drag-and-Drop Editing

Using Undo and Redo

Previewing a Worksheet

Printing the Current Worksheet

Printing a Selected Range

Printing Multiple Copies

Printing a Page Range

Setting Margin and Centering Options

Changing the Page Orientation

Creating Headers and Footers

Customizing Headers and Footers

Changing Print Gridlines

Repeating Row and Column Labels

Scaling a Worksheet

Using Page Break Preview

Setting/Removing a Print Area

Using Number Formats

Using the Currency Style

Using the Percent Style

Using the Comma Style

Changing Decimal Places

Formatting Cell Text

Changing the Font Colour

Rotating Text in a Cell

Wrapping Text in a Cell

Shrinking Text in a Cell

Changing Cell Alignment

Changing Text Indentation

Selecting Columns and Rows

Changing the Width of Columns

Changing the Height of Rows

Adjusting Columns Automatically

Hiding / Unhiding Columns and Rows

Inserting a Column

Insert a Row

Deleting a Column

Deleting a Row

Using the Merge and Centre Button

Changing the Vertical Alignment

Splitting Cells

Using the Borders Button

Drawing Cell Borders

Using the Fill Colour Button

Pasting Formats

Using the Format Painter Button

Copying Formats to Non-Adjacent Cells

Clearing Formats

Inserting Selected Cells

Inserting Cut or Copied Cells

Deleting Selected Cells

Using Automatic Formatting Features

Applying an AutoFormat

Changing AutoFormat Options

Extending List Formats and Formulas

Creating a Style by Example

Applying a Style

Creating a New Style

Editing an Existing Style

Merging Styles

Using Charts

Creating Charts with the Chart Wizard

Moving and Resizing Charts

Identifying Chart Objects

Changing the Chart Type

Changing the Chart Type and Sub-type

Changing the Plot Direction

Removing/Adding a Legend

Moving the Legend

Charting Non-adjacent Ranges

Changing the Chart Range

Changing the Data Source

Changing the Chart Location