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.