Excel 2007:

Topic-Level Outline

                         Days:  1

         Prerequisites:  Windows XP: Basic or equivalent experience

                         Unit 1 :  Getting started

                               Topic A: 0  Spreadsheet terminology

                               A-1:                               Discussing spreadsheet terminology

                               Topic B: 0  Exploring the Excel window

                               B-1:                               Examining Excel window components

                               Topic C: 0  Getting help

                               C-1:                               Using Help

                               Topic D: 0  Navigating workbooks

                         D-1:                         Navigating a worksheet

                         Unit 2 :  Entering and editing data

                               Topic A: 0  Entering and editing text and values

                               A-1:                               Entering text and values

                               A-2:                               Editing text

                               A-3:                               Using AutoFill to fill a series

                               Topic B: 0  Entering and editing formulas

                               B-1:                               Entering a formula by typing

                               B-2:                               Entering cell references with the mouse

                               B-3:                               Editing a formula

                               Topic C: 0  Working with pictures

                               C-1:                               Inserting and modifying a picture

                               Topic D: 0  Saving and updating workbooks

                         D-1:                         Saving a workbook

                         D-2:                         Changing and updating a workbook

                         D-3:                         Using the Compatibility Checker

                         Unit 3 :  Modifying a worksheet

                               Topic A: 0  Moving and copying data

                               A-1:                               Moving data in a worksheet

                               A-2:                               Copying data in a worksheet

                               A-3:                               Moving and copying data by using drag-and-drop

                               A-4:                               Copying data by using the Clipboard

                               Topic B: 0  Moving and copying formulas

                               B-1:                               Moving a formula

                               B-2:                               Copying a formula

                               B-3:                               Using AutoFill to copy a formula

                               Topic C: 0  Absolute and relative references

                               C-1:                               Observing the limitations of relative references

                               C-2:                               Using absolute references

                               Topic D: 0  Inserting and deleting ranges, rows, and columns

                         D-1:                         Inserting a range

                         D-2:                         Inserting rows

                         D-3:                         Deleting a range

                         Unit 4 :  Using functions

                               Topic A: 0  Entering functions

                               A-1:                               Entering a SUM function

                               A-2:                               Using the mouse to enter a function argument

                               A-3:                               Inserting a SUM function

                               Topic B: 0  AutoSum

                               B-1:                               Using the AutoSum button

                               Topic C: 0  Other useful functions

                         C-1:                         Using AVERAGE

                         C-2:                         Using MIN

                         C-3:                         Using MAX

                         C-4:                         Using COUNT and COUNTA

                         Unit 5 :  Formatting worksheets

                               Topic A: 0  Formatting text

                               A-1:                               Using the Font group to format text

                               A-2:                               Formatting non-contiguous ranges

                               A-3:                               Using the Format Cells dialog box to format text

                               Topic B: 0  Formatting rows and columns

                               B-1:                               Changing column width and row height

                               B-2:                               Applying color to a row

                               B-3:                               Setting alignment

                               B-4:                               Applying borders to ranges

                               B-5:                               Using the border-drawing pencil

                               B-6:                               Using the Paste Special option

                               B-7:                               Removing a border

                               Topic C: 0  Formatting numbers

                               C-1:                               Using the Number group to format numbers

                               C-2:                               Exploring the Number tab

                               Topic D: 0  Conditional formatting

                               D-1:                               Creating a conditional format

                               D-2:                               Editing and deleting a conditional format

                               Topic E: 0  Copying formats and applying table formats

                         E-1:                         Copying formats

                         E-2:                         Using AutoFill to copy a format

                         E-3:                         Applying cell and table styles

                         E-4:                         Using Find and Replace to change cell formats

                         Unit 6 :  Printing

                               Topic A: 0  Preparing to print

                               A-1:                               Checking spelling in a worksheet

                               A-2:                               Using the Research task pane

                               A-3:                               Finding and replacing text

                               A-4:                               Previewing a worksheet

                               Topic B: 0  Page Setup options

                               B-1:                               Setting page orientation

                               B-2:                               Setting margins

                               B-3:                               Creating and editing headers and footers

                               B-4:                               Hiding gridlines and headings

                               Topic C: 0  Printing worksheets

                         C-1:                         Printing a worksheet

                         C-2:                         Working with the print area

                         Unit 7 :  Creating charts

                               Topic A: 0  Chart basics

                               A-1:                               Creating a chart

                               A-2:                               Moving a chart within a workbook

                               A-3:                               Examining chart elements

                               A-4:                               Using an embedded chart

                               Topic B: 0  Modifying charts

                               B-1:                               Changing a chart type

                               B-2:                               Applying Quick Layouts and Quick Styles

                               B-3:                               Formatting chart elements

                               B-4:                               Modifying an embedded chart

                               Topic C: 0  Printing charts

                         C-1:                         Printing a chart

                         Unit 8 :  Managing large workbooks

                               Topic A: 0  Viewing large worksheets

                               A-1:                               Using the Freeze Panes command

                               A-2:                               Splitting a worksheet into panes

                               A-3:                               Hiding and unhiding columns and worksheets

                               A-4:                               Minimizing the Ribbon

                               Topic B: 0  Printing large worksheets

                               B-1:                               Setting print titles

                               B-2:                               Adjusting page breaks

                               Topic C: 0  Using multiple worksheets

  C-1:  Navigating between worksheets

  C-2:  Naming worksheets and coloring tabs

  C-3:  Working with multiple worksheets

  C-4:  Previewing and printing multiple worksheets