Topic Slide Number
Lesson 1: Welcome and Excel Basics Course Procedures.................................... 3 Course Plan.......................................... 7 Why Use MS Excel..................................... 10 Starting Excel....................................... 11 Excel Layout......................................... 14 Workbook............................................. 29 Active Cell.......................................... 33 Moving Active Cell................................... 34 Entering a Value..................................... 37 Text......................... 38 Numbers...................... 43 Formulas..................... 50 Saving a Workbook.................................... 63 Lesson 2: Building a Worksheet Review Exercise (Start a worksheet).................. 69 Lesson Overview...................................... 70 Annotating a Worksheet with Comments................. 71 Ranges............................................... 81 Adjacent Ranges.............. 83 Non-adjacent Ranges.......... 86 Naming Ranges................ 88 Moving Cell Contents................................. 94 Changing Column Width & Row Height................... 101 Copying Cell Contents................................ 106 AutoFill............................................. 111 Formula References (Pasting Formulas)................ 120 Selecting Whole Worksheet............................ 129 Moving/Copying Worksheets............................ 130 Deleting/Inserting Cells, Columns, Rows.............. 135 Accessing Help....................................... 141 Lesson 3: Formatting a Workbook Review Exercise (Building a Worksheet)............... 147 Lesson Overview...................................... 149 Formatting Numbers................................... 150 Dates in Excel....................................... 156 Custom Formats....................................... 161 Character Formatting................................. 166 Font......................... 166 Font Size.................... 169 Font Appearance.............. 172 Horizontal Alignment......... 177 Vertical Alignment........... 184 Rotating Orientation......... 188 Indenting Cell Contents...... 191 Borders & Gridlines.................................. 192 Shading/Colors....................................... 199 AutoFormat........................................... 204 Format Painter....................................... 207 Conditional Formatting............................... 211 Spell Checking....................................... 222 AutoCorrect.......................................... 225 Lesson 4: Managing Workbooks Review Exercise (Formatting a worksheet)............. 227 Lesson Overview...................................... 229 Move Among Worksheets................................ 230 Renaming Worksheets.................................. 235 Moving/Copying Worksheets............................ 240 Inserting/Deleting Worksheets........................ 254 Printing Worksheets.................................. 262 Paper Size/Orientation....... 263 Margins...................... 265 Header/Footer................ 267 Repeating Rows/Columns....... 273 Print Preview........................................ 278 Manual Page Breaks................................... 283 Lesson 5: Using Functions Lesson Overview...................................... 292 Defining Functions................................... 293 AutoSum Function..................................... 301 Conditional Sum Function............................. 303 Function Wizard (Paste Function)..................... 309 Examples of Functions................................ 316 Financial.................... 318 Date & Time.................. 323 Math & Trig.................. 328 Statistical.................. 332 Lookup & Reference........... 335 Text......................... 337 Logical...................... 338 Informational................ 340 What Next? Course Suggestions........................ 343 Outline of MS Excel Intermediate..................... 344

Beginning Excel - A Power Point Presentation

MS Excel Introduction

Table of Contents: MS Excel Introduction