Using Excel version 5 for Windows / Ron Person.

Introduction

Everyday Worksheet Tasks

1. What's New in Excel 5 for Windows

2. Getting Around in Excel and Window

3. Navigating and Selecting in a Workbook

4. Entering and Editing Data

5. Working with Formulas

6. Using Functions

7. Moving or Copying Data and Formulas

8. Reorganizing workbooks and Sheets

9. Managing Files

10.Formatting Worksheets

11. Printing Worksheets

Creating and Formatting Charts

12. Creating Charts

13. Modifying Charts

14. Building Complex charts

15.Formatting Charts

Optimizing Excel

16. Managing the Worksheet Display

17. Adding Graphic Elements to sheets

18. Outlining Worksheets

19. Creating Automatic Subtotal

20.Publishing Worksheets and Charts

21.Creating Slide show and Presentations

22. Taking advantage of Excel's Add-Ins

Analyzing the Worksheet

23. Manipulating and Analyzing Data

24. Building Forms with Controls

25.Linking Imbedding and Consolidating worksheets

26.Auditing workbooks and Worksheets

27.Solving and Goal seeking and Solver

28. Testing Multiple Solutions with Scenarios

29.Using the Analysis Tool Pak

Managing Lists or Databases

30. Designing a List or Database

31. Entering Data in a List or Database

32.Sorting Data

33. Finding, Filtering, and Editing Lists and Databases

34. Working with Filtered Data

35. Retrieving Data from External Databases

36. Using Pivot Tables

37. Analyzing and Reporting with Pivot Tables

Integrating Excel with Other Applications

38. Using Excel with Windows Applications

39. Using Excel with DOS and Mainframe Applications

Customizing Excel

40. Customizing Excel

41. Creating Custom Toolbars and Menu

42. Creating Templates and Controlling Excel's Start up

Automating With Visual Basics for Applications

43. Introducing Visual Basic for Applications

44. Recording and Modifying VBA Modules

45. Programming in Visual Basic for Applications

46. Exploring Visual Basic for Applications Examples

Appendix

Index

Includes index.