Microsoft Excel 97 Step by Step (Step by Step (Microsoft))

Work through every lesson to complete the full course, or do individual lessons to learn just the skills you need. Either way, you learn at your optimum pace from the teacher who knows you best -- you.

Prebuilt practice files help you quickly learn by doing.

QuickLook Guide points you right to the information you work.

Lay-flat binding means the book stays open as you work.

- With this book and Microsoft"RM" Excel 97, you'll learn to:

- Enter and format your data, and write formulas.

- Create a template to speed up your work.

- Make your worksheets available over the Internet or intranets with Microsoft FrontPage".TM"

- Manage your tasks with the help of Microsoft Outlook".TM"

- Consolidate data from several worksheets into one.

- Find and organize information by filtering, sorting, and subtotalling.

- Summarize and analyze data using PivotTable"RM" dynamic views.

- Use charting to visualize trends and relationships.

- Print the reports you require.

- Find the optimum answer by using goal Seek and Scenario Manager to compare alternatives.

- Work simultaneously with others dy sharing a workbook via your company intranet.

With this book and Microsoft Excel 97, you'll learn to enter and format your data, and write formulas; create a template to speed up your work; make your worksheets available over the Internet or intranets with Microsoft FrontPage; manage your tasks with the help of Microsoft Outlook; consolidate data from several worksheets into one; find and organize information by filtering, sorting, and subtotaling; summarize and analyze data using PivotTable dynamic views; use charting to visualize trends and relationships; print the reports you require; find the optimum answer by using Goal Seek and Scenario Manager to compare alternatives; and work simultaneously with others by sharing a workbook via your company intranet. This book provides complete preparation for the Certified Microsoft Office User Proficient exam.