Sold Out
Book Categories |
- Using This Book
A Word about Doing the Exercises
Special Icons and Features in the Book
Getting Started: What You Need to Do
- 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
- 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
- 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
Login|Complaints|Blog|Games|Digital Media|Souls|Obituary|Contact Us|FAQ
CAN'T FIND WHAT YOU'RE LOOKING FOR? CLICK HERE!!! X
You must be logged in to add to WishlistX
This item is in your Wish ListX
This item is in your CollectionDummies 101
X
This Item is in Your InventoryDummies 101
X
You must be logged in to review the productsX
X
X
Add Dummies 101, You don't have to spend weeks taking an expensive class to learn how to use Excel 97 for Windows. Dummies 101: Excel 97 For Windows takes you step by step though all the essentials of using this popular and powerful spreadsheet program in the offic, Dummies 101 to the inventory that you are selling on WonderClubX
X
Add Dummies 101, You don't have to spend weeks taking an expensive class to learn how to use Excel 97 for Windows. Dummies 101: Excel 97 For Windows takes you step by step though all the essentials of using this popular and powerful spreadsheet program in the offic, Dummies 101 to your collection on WonderClub |