Excel 2007 : Basic Topic-Level Outline or equivalent experience Prerequisites: Windows XP: Basic Unit 1 : Getting started 0 Spreadsheet terminology Topic A: Discussing spreadsheet terminology 0 A-1: Topic B: Exploring the Excel window Examining Excel window components 0 Getting B-1: Topic C: help Using Help 0 Navigating workbooks C-1: Topic D: Navigating a worksheet Unit 2 : Entering and editing D-1: data 0 Entering and editing text and values Topic A: Entering text and values A-1: Editing text A-2: Using AutoFill to fill a series 0 Entering and A-3: Topic B: editing formulas Entering a formula by typing B-1: Entering cell references with the mouse B-2: Editing a formula 0 Working with pictures B-3: Topic C: Inserting and modifying a picture 0 Saving C-1: Topic D: and updating workbooks Saving a workbook D-1: Changing and updating a workbook D-2: Unit 3 : Using the Compatibility Checker D-3: Modifying a worksheet 0 Moving and copying data Topic A: Moving data in a worksheet A-1: Copying data in a worksheet A-2: Moving and copying data by using drag-and-drop A-3: Copying data by using the Clipboard 0 Moving A-4: Topic B: and copying formulas Moving a formula B-1: Copying a formula B-2: Using AutoFill to copy a formula 0 B-3: Topic C: Absolute and relative references Observing the limitations of relative references C-1: Using absolute references 0 Inserting and C-2: Topic D: deleting ranges, rows, and columns
Excel 2007 : Basic Topic-Level Outline 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
Excel%202007-%20Basic.docx