Problem Solving with Microsoft Excel for Windows 95 (Version 7.0)

Introduction: Overview of Problem-Solving and Spreadsheets.
I. CREATING AND PRINTING BASIC WORKSHEETS.

 1. Overview of Microsoft Windows 95.
 2. Getting Started with Excel 7.0.
 3. Designing and Entering Data on a Worksheet.
 4. Entering Formulas and Functions.
 5. Editing a Worksheet.
 6. Printing Documents.
 7.Changing the Look of a Worksheet.
 8. Formatting Worksheet Data.
II. ORGANIZING AND CONTROLLING WORK.

 9. Organizing and Documenting a Worksheet.
10. Organizing Worksheet Information Into Lists.
11. Organizing Sheets Into Workbooks.
12. Controlling and Troubleshooting Worksheets.
13. Power Worksheet Features.
III. CREATING CHARTS AND GRAPHIC OBJECTS.

14. Creating Charts and Graphs.
15. Editing and Formatting Charts.
16. Creating and Using Graphic Objects.
IV. USING ANALYSIS TOOLS TO SOLVE PROBLEMS.

17. Using Goal Seek and Data Tables.
18. Using Solver and Scenario Manager.
19. Using Other Analysis Tools.
V. AUTOMATING WORK WITH TEMPLATES, MACROS, AND QUERIES.

20. Creating and Using Templates.
21. Creating and Using Macros.
22. Using Microsoft Visual Basic.
23. Using Microsoft Query.
REFERENCE.

APPENDICES.

Appendix A: Exchanging Information with Other Software.
Appendix B: From Lotus 1-2-3 to Exel 7.0.
Appendix C: Customizing Excel 7.0.
Appendix D: Using Excel 7.0 in a Networking Environment.