Topic Slide Number
Lesson 1: Welcome and Review of Excel Intro Course Procedures..................................... 3 Course Plan........................................... 7 Review Exercises...................................... 9 Lesson 2: Creating Charts and Maps Lesson Overview....................................... 13 Elements of a Chart................................... 14 Chart Types........................................... 17 Chart Wizard.......................................... 24 Modifying a Chart..................................... 39 Separate & Embedded Charts.... 43 Modifying Data Series......... 46 Colors and Fill Effects....... 50 Adding a Map.......................................... 65 Editing a Map......................................... 70 Map Features.......................................... 79 Lesson 3: Managing Data Lesson Overview....................................... 86 Definition of Databases............................... 87 Data Form............................................. 90 Sorting............................................... 94 AutoFilter............................................ 103 Lesson 4: Macros & Linking Lesson Overview....................................... 113 Definition of Macro................................... 114 Creating a Macro...................................... 116 Running a Macro....................................... 123 Creating a Macro Button............................... 127 Links between Worksheets/Workbooks.................... 135 Links to Other Applications........................... 144 Hyperlinks............................................ 147 Lesson 5: Summarizing, Consolidating & Analyzing Data Lesson Overview....................................... 157 Subtotals............................................. 158 Consolidation Tables.................................. 162 What-If Analysis...................................... 166 One-Input Tables.................. 167 Two-Input Tables.................. 173 Scenarios............................................. 176 What Next? Course Suggestions......................... 186

Beginning Excel - A Power Point Presentation

MS Excel Intermediate

Table of Contents: MS Excel Intermediate