# Microsoft Excel Workbook

**Topics:**Microsoft Office, Microsoft Excel, Microsoft

**Pages:**362 (100971 words)

**Published:**May 15, 2011

e

This Course Covers: • • • • • • Spreadsheet fundamentals: How to open, create, and work with a spreadsheet How to enhance spreadsheets using formatting techniques How to create and work with charts How to create formulas to perform a variety of calculations How to manage workbooks and advanced printing options How to analyze data using Excel’s list features

Microsoft

®

Table of Contents

Introduction .......................................................................................................................... 7 Chapter One: The Fundamentals...................................................................................... 11 Lesson 1-1: Starting Excel...................................................................................................12 Lesson 1-2: What’s New in Excel 2002?.............................................................................14 Lesson 1-3: Understanding the Excel Program Screen........................................................16 Lesson 1-4: Using Menus ....................................................................................................18 Lesson 1-5: Using Toolbars and Creating a New Workbook...............................................20 Lesson 1-6: Filling Out Dialog Boxes .................................................................................22 Lesson 1-7: Keystroke and Right Mouse Button Shortcuts .................................................24 Lesson 1-8: Opening a Workbook .......................................................................................26 Lesson 1-9: Saving a Workbook..........................................................................................28 Lesson 1-10: Moving the Cell Pointer.................................................................................30 Lesson 1-11: Navigating a Worksheet .................................................................................32 Lesson 1-12: Entering Labels in a Worksheet .....................................................................34 Lesson 1-13: Entering Values in a Worksheet and Selecting a Cell Range .........................36 Lesson 1-14: Calculating Value Totals with AutoSum ........................................................38 Lesson 1-15: Entering Formulas..........................................................................................40 Lesson 1-16: Using AutoFill ...............................................................................................42 Lesson 1-17: Previewing and Printing a Worksheet ............................................................44 Lesson 1-18: Getting Help from the Office Assistant..........................................................46 Lesson 1-19: Changing the Office Assistant and Using the “What’s This” Button.............48 Lesson 1-20: Closing a Workbook and Exiting Excel .........................................................50 Chapter One Review............................................................................................................52 Chapter Two: Editing a Workbook.................................................................................. 59 Lesson 2-1: Entering Date Values and using AutoComplete ...............................................60 Lesson 2-2: Editing, Clearing, and Replacing Cell Contents...............................................62 Lesson 2-3: Cutting, Copying, and Pasting Cells ................................................................64 Lesson 2-4: Moving and Copying Cells with Drag and Drop .............................................66 Lesson 2-5: Collecting and Pasting Multiple Items .............................................................68 Lesson 2-6: Working with Absolute and Relative Cell References .....................................70 Lesson 2-7: Using the Paste Special Command ..................................................................72 Lesson 2-8: Inserting...

Please join StudyMode to read the full document