Excel 2007:
Basic
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