Quick, Simple Microsoft Excel 2000 / Edition 1

Quick, Simple Microsoft Excel 2000 / Edition 1

by Linda Ericksen
     
 

Product Details

ISBN-13:
9780130813336
Publisher:
Pearson
Publication date:
06/07/1999
Edition description:
SPIRAL
Pages:
240
Product dimensions:
8.27(w) x 10.87(h) x 4.33(d)

Table of Contents

1. Getting Started.
Introduction to Spreadsheets. Starting the Software. Moving Around a Spreadsheet. Using Help. Closing and Opening Spreadsheets. Exiting Excel and Shutting Down Windows.

2. Creating a Spreadsheet.
Placing Text and Numbers in a Spreadsheet. Creating Formulas. Editing the Spreadsheet. Saving the Spreadsheet. Previewing the Spreadsheet. Using Page Set Up. Printing the Spreadsheet. Printing the Formulas.

3. Formatting the Spreadsheet.
Using AutoFormat. Using Bold, Italic, and Underline. Formatting Text. Formatting Numbers. Adjusting Column Widths. Alighting Data in Cells. Adding a Border and Shading. Adding a Graphic. Running the Spell Check. Copying, Cutting and Pasting.
Check Point 1.

4. Calculating the Spreadsheet.
Using AutoSum. Using MIN. Using MAX. Using AVERAGE. Using AutoCalculate. Using PRODUCT. Using Fill to Copy Formulas. Understanding Relative and Absolute Formulas. Recalculating the Spreadsheet.

5. Using Financial Functions.
Using PMT. Using PPMT. Using IPMT. Using FV. Using SLN.

6. Using Various Types of Functions.
Using TODAY. Using IF. Using SUMIF. Using COUNT, COUNTA, and COUNTBLANK. Using COUNTIF.
Check Point 2.

7. Working with Multiple Screens.
Inserting and Deleting Sheets. Naming Sheet Tabs. Copying and Moving Sheets. Calculating Between Sheets.

8. Enhancing the Spreadsheet.
Creating Charts. Copying the Spreadsheet Data to Microsoft Word. Linking Spreadsheet Data to Microsoft Word. Linking to the Internet.
Check Point 3.
Appendix A: Alphabetized List of Tasks.

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >