Dummies 101 Book

Introduction

Using This Book
A Word about Doing the Exercises
Special Icons and Features in the Book
Getting Started: What You Need to Do

Part I: Creating the Spreadsheet

Unit 1: Entering the Spreadsheet Data
Lesson 1-1: Starting Excel and Opening a New Workbook

Exercise 1-1: Starting Excel from the Taskbar
Starting Excel from the Microsoft Office Shortcut Bar
Starting Excel by creating an Excel shortcut
Exercise 1-2: Creating an Excel shortcut
Starting Excel by opening an existing workbook
Opening a new workbook within Excel
Exercise 1-3: Opening a bunch of blank workbooks
Exercise 1-4: Switching between the open workbooks
Closing workbooks
Exercise 1-5: Closing up the open workbooks
Using the Office Assistant
Exercise 1-6: Getting help from the Office Assistant

Lesson 1-2: Moving the Cell Pointer

Moving the cell pointer with the mouse
Exercise 1-7: Changing the active cell with the mouse
Scrolling the worksheet
Scrolling with IntelliMouse
Exercise 1-8: Selecting cells in hidden parts of the worksheet
Moving the cell pointer with the keyboard
Exercise 1-9: Using the keyboard to move one cell at a time
Exercise 1-10: Using the keyboard to make larger moves
Moving the cell pointer with the Go To feature
Exercise 1-11: Making a cell active with Go To
Moving between the sheets of the workbook

Lesson 1-3: Adding Data to a Cell

Exercise 1-12: Entering the title for the spreadsheet
Exercise 1-13: Entering the headings for the sales table
Entering numeric data in a spreadsheet
Entering dates and times
Exercise 1-14: Entering the values in the sales table

Lesson 1-4: Calculating Values with Formulas

Exercise 1-15: Totaling values with AutoSum
Copying cell entries with the fill handle
Exercise 1-16: Copying SUM formulas with the fill handle
Introducing the Formula Palette
Exercise 1-17: Entering functions with the Formula Palette

Lesson 1-5: Saving Your Sales Spreadsheet

Exercise 1-18: Saving your sales table spreadsheet
Recess

Lesson 1-6: Using AutoFill to Enter a Data Series

Exercise 1-19: Creating a simple data series
Exercise 1-20: Creating a more complex data series
Exercise 1-21: Creating a custom AutoFill list

Unit 1 Quiz
Unit 2: Formatting the Spreadsheet
Lesson 2-1: Opening the Workbook for Formatting

Exercise 2-1: Changing the default file location
Exercise 2-2: Opening your MGE Quarterly Sales workbook

Lesson 2-2: Widening Columns and Rows

Exercise 2-3: Adjusting the column width with AutoFit
Exercise 2-4: Adjusting the column width with AutoFit Selection
Exercise 2-5: Adjusting the column width manually
Exercise 2-6: Adjusting the row height

Lesson 2-3: Formatting Cells from the Formatting Toolbar

Exercise 2-7: Indenting Total row headings on a P&L statement
Exercise 2-8: Changing the font and font size of the table headings
Exercise 2-9: Changing the alignment of the table headings
Exercise 2-10: Applying number formats to the sales figures
Exercise 2-11: Using borders and color in the sales table

Lesson 2-4: Formatting Cells from the Format Cells Dialog Box

Exercise 2-12: Changing the text wrap, vertical alignment, and orientation of cell entries
Exercise 2-13: Formatting column heading orientation
Exercise 2-14: Applying the Special number format

Lesson 2-5: Using AutoFormat on a Table of Data

Exercise 2-15: Using AutoFormat on the MGE 1st Quarter 1997 Sales table
Recess

Unit 2 Quiz

Unit 3: Printing the Spreadsheet
Lesson 3-1: Printing Spreadsheet Data

Exercise 3-1: Previewing the page layout
Exercise 3-2: Printing the worksheet with the Print button
Exercise 3-3: Printing the worksheet with the Print command
Exercise 3-4: Printing the entire workbook
Exercise 3-5: Printing selected worksheets
Exercise 3-6: Printing a range of cells in a worksheet

Lesson 3-2: Adding Headers, Footers, and Print Titles to a Report

Exercise 3-7: Modifying the default header and footer
Exercise 3-8: Adding a custom header and footer to a report
Exercise 3-9: Adding column headings as print titles
Exercise 3-10: Adding row headings as print titles

Lesson 3-3: Changing the Print Settings for a Report

Exercise 3-11: Centering the printing and changing the margins
Exercise 3-12: Adding manual page breaks to a report using Page Break Preview
Recess

Unit 3 Quiz
Part I Review

Unit 1 Summary
Unit 2 Summary
Unit 3 Summary

Part I Test
Part I Lab Assignment

Step 1: Creating the MGE 1st Quarter 1999 projected sales worksheet

Step 2: Formatting the MGE 1st Quarter 1999 projected sales worksheet

Step 3: Printing the MGE 1st Quarter sales worksheets

Part II: Modifying the Spreadsheet

Unit 4: Working with Cell Ranges
Lesson 4-1: Selecting Cell Ranges

Making cell selections with the mouse
Making cell selections with the keyboard
Exercise 4-1: Selecting cell ranges with the mouse
Exercise 4-2: Selecting cell ranges with the keyboard
Exercise 4-3: Selecting a cell range with Go To

Lesson 4-2: Using AutoCalculate

Exercise 4-4: Calculating totals on the fly with AutoCalculate

Lesson 4-3: Naming Cell Ranges

Exercise 4-5: Creating the retail price table
Exercise 4-6: Defining the markup constant for the retail price table
Exercise 4-7: Defining cell range names in the retail price table
Exercise 4-8: Creating range names from column and row headings
Exercise 4-9: Selecting various named ranges in the price table
Exercise 4-10: Applying column and row names to formulas
Exercise 4-11: Using Natural Formulas

Lesson 4-4: Copying and Moving Cell Ranges

Exercise 4-12: Copying and moving cell ranges with drag and drop
Exercise 4-13: Copying and moving cells with cut and paste
Exercise 4-14: Using Paste Special

Unit 4 Quiz
Unit 5: Editing the Spreadsheet
Lesson 5-1: Editing Data Entries

Exercise 5-1: Revising data entries in their cells
Exercise 5-2: Revising data entries on the formula bar
Exercise 5-3: Clearing cells of their data entries and using Undo/Redo

Lesson 5-2: Locating the Areas that Need Editing

Exercise 5-4: Zooming in and out on a worksheet
Exercise 5-5: Freezing panes as worksheet titles
Exercise 5-6: Dividing the worksheet into panes

Lesson 5-3: Inserting and Deleting Cell Ranges

Exercise 5-7: Deleting cells
Exercise 5-8: Inserting new cells

Lesson 5-4: Adding Notes to Cells

Exercise 5-9: Creating and selecting text notes in cells

Lesson 5-5: Finding and Replacing Data

Exercise 5-10: Finding data entries in the worksheet
Exercise 5-11: Replacing data entries in the worksheet

Lesson 5-6: Checking the Spelling of Spreadsheet Data

Exercise 5-12: Spell checking the worksheet

Lesson 5-7: Editing Worksheets in a Workbook

Exercise 5-13: Renaming worksheets
Exercise 5-14: Adding and deleting worksheets
Exercise 5-15: Rearranging the worksheets in a workbook
Exercise 5-16: Totaling the worksheets in a workbook
Exercise 5-17: Copying worksheets from different workbooks into a single, new workbook

Unit 5 Quiz
Part II Review

Unit 4 Summary
Unit 5 Summary

Part II Test
Part II Lab Assignment

Step 1: Copying the 1997 Mother Hubbard Dog Goodies income statement into the MGE 97 P&Ls workbook
Step 2: Adding a new worksheet to the MGE 97 P&Ls (totals) workbook
Step 3: Totaling the income statements in the MGE 97 P&Ls (totals) workbook

Part III: Beyond the Spreadsheet

Unit 6: Charting Spreadsheet Data
Lesson 6-1: Creating Charts

Exercise 6-1: Creating a chart with the Chart Wizard
Exercise 6-2: Creating a chart on its own Chart Sheet

Lesson 6-2: Editing a Chart

Exercise 6-3: Resizing the Chart Titles and Legend
Exercise 6-4: Formatting the plot area and changing the orientation of the data series

Lesson 6-3: Printing Charts

Exercise 6-5: Printing the embedded chart alone and with its spreadsheet data
Exercise 6-6: Printing the Q1 97 Chart sheet

Unit 6 Quiz
Unit 7: Building and Maintaining a Database
Lesson 7-1: Creating a Database

Exercise 7-1: Creating the field names for a new database
Exercise 7-2: Entering and formatting the first record in the Address Database

Lesson 7-2: Adding Records to the Database

Exercise 7-3: Adding a record with the data form
Exercise 7-4: Adding a record directly to the database table

Lesson 7-3: Editing the Database Records

Exercise 7-5: Moving from record to record in the database
Exercise 7-6: Locating the records with the Criteria form
Exercise 7-7: Modifying field entries within records
Exercise 7-8: Deleting records from the database

Lesson 7-4: Sorting the Records in a Database

Exercise 7-9: Sorting the Client List alphabetically
Exercise 7-10: Sorting the Client List by anniversary date
Exercise 7-11: Sorting the Client List by city, state, and zip code

Lesson 7-5: Selecting the Records in a Database

Exercise 7-12: Filtering the Client List with AutoFilter
Exercise 7-13: Filtering the Client List with an either/or Custom AutoFilter
Exercise 7-14: Filtering a range of values with Custom AutoFilter

Unit 7 Quiz
Unit 8: Using Hyperlinks and Adding Excel Data to Web Pages
Lesson 8-1: Adding Hypertext Links

Exercise 8-1: Creating a cover worksheet for the hypertext links
Exercise 8-2: Adding hypertext links to the cell entries
Exercise 8-3: Testing the hypertext links

Lesson 8-2: Adding Hyperlinks to Graphics

Exercise 8-4: Inserting a graphic image to use as a hyperlink
Exercise 8-5: Adding the hyperlink to the imported graphic image
Exercise 8-6: Copying the graphic hyperlink to the other worksheets

Lesson 8-3: Creating Hyperlinks that Open Other Office Documents

Exercise 8-7: Creating a hypertext link to a Word 97 document
Exercise 8-8: Testing the hyperlink to the Word 97 document
Exercise 8-9: Editing a hypertext link

Lesson 8-4: Creating Hyperlinks to Web Pages

Exercise 8-10: Adding a hyperlink to the mind over media Web site

Recess
Lesson 8-5: Outputting Worksheet Data and Charts to Web Documents

Exercise 8-11: Adding worksheet data and a chart to a new HTML document
Exercise 8-12: Viewing the HTML document with your Web browser
Exercise 8-13: Adding worksheet data to an existing HTML document

Unit 8 Quiz
Part III Review

Unit 6 Summary
Unit 7 Summary
Unit 8 Summary

Part III Test
Part III Lab Assignment

Step 1: Creating an embedded 3-D pie chart for the 1997 projected sales data
Step 2: Creating a 3-D bar chart on its own sheet for the 1997 projected sales data
Step 3: Sorting and filtering the Client List in the Bo-Peep Client List workbook

Appendix A: Answers

Unit 1 Quiz Answers
Unit 2 Quiz Answers
Unit 3 Quiz Answers
Part I Test Answers
Unit 4 Quiz Answers
Unit 5 Quiz Answers
Part II Test Answers
Unit 6 Quiz Answers
Unit 7 Quiz Answers
Unit 8 Quiz Answers
Part III Test Answers

Appendix B: About the CD

Index

Coupon

Disc License Agreement

Installation Instructions

Reader Response Card