Microsoft Excel 2000 Book

Overview of Windows.
Overview of Windows.
Identifying the Desktop Elements.
Using a Mouse.
Using the Basic Features of Windows.
Using Menus and Toolbars.
Working with Multiple Programs.
Getting Help.
Exiting Windows.
Common Elements in Office 2000.
Project 1 Basic Common Elements.
Launching Applications.
Performing Basic File Management Tasks.
Changing File Properties.
Using Help.
Selecting Printers and Printing.
Exiting Applications.
Project 2 Common Text and Art Elements.
Working with Text.
Using Proofing Tools.
Adding Art in Office 2000.
Creating and Manipulating Drawings.
Projects for Microsoft Excel 2000.
Introducing Excel 2000.
Worksheets and Workbooks.
Planning Excel Workbooks for Timely, Useful, and Accurate Information.
Launching Excel 2000.
The Excel 2000 User Interface.
Project 1 Designing Worksheets and Workbooks.
Designing a Workbook.
Navigating in a Workbook.
Entering Text in a Worksheet.
Filling in Data Based on Adjacent Cells.
Adjusting Column Width and Entering Additional Text.
Saving Your Workbook.
Entering Numbers.
Creating Formulas.
Previewing and Printing Worksheets.
Closing Your Workbook.
Project 2 Modifying Worksheets and Workbooks.
Opening anExcel Workbook.
Working with Worksheets.
Editing a Workbook by Inserting Worksheets.
Repositioning Worksheets in a Workbook.
Editing Worksheet Data.
Editing Worksheets by Copying and Moving Data.
Editing Worksheets by Revising Existing Data.
Entering Additional Text and Number Data.
Constructing Linking Formulas with 3-D References.
Entering Formulas to Sum the Sales Summary Data.
Project 3 Formatting Worksheets and Workbooks.
About Worksheet Formats.
Formatting Numbers.
Modifying Formats.
Copying Formats.
Applying Font Formats.
Creating and Applying Styles.
Working with Rows and Columns.
Adding Borders to Cells.
Applying Cell Formats to the Sales Summary Worksheet.
Using the Web Page Preview.
Project 4 Creating More Complex Workbooks.
Naming Ranges.
Using Ranges to Select Data.
Using Range Names in Formulas.
Using Logical Functions.
Modifying the Page Setup of Worksheets.
Setting and Clearing Print Areas.
Setting Other Print Options.
Project 5 Analyzing and Distributing Worksheet Data.
Using Charts to Analyze and Summarize Worksheet Data.
Modifying Charts.
Deleting Charts.
Previewing Charts.
Printing Charts.
Adding Graphics to Workbooks.
Publishing Workbooks to the Web.
Project 6 Using Financial Functions.
Using Excel to Amortize a Loan.
Defining the Structure of the Amortization Schedule.
Entering Numeric Constants.
Calculating the Beginning Balance Using Excel's PV Function.
Calculating the Principal Paid in Each Payment Using Excel's PPMT Function.
Calculating the Interest Paid in Each Payment Using the IPMT Function.
Constructing Formulas to Calculate the Cumulative Principal, Cumulative Interest, Total Payments, and Ending Balance.
Using the Fill Handle to Complete the Amortization Schedule.
Freezing Worksheet Panes to Assist in Viewing Large Worksheets.
Changing the Loan Scenario.
Excel 2000 Function Reference Guide.
Glossary.
Index.