Microsoft Excel 2007 Explained

Description

If you are a PC user and want to get to grips with Microsoft's Excel 2007 spreadsheet as quickly and easily as possible, then this book is for you.

The book explains:

    * The hardware specification you need to run the package, how to install it , how to become familiar with the Excel environment and how to use the built-in Help system.

    * How to use the New Ribbon interface, build up simple spreadsheet examples, edit entries, format cells and ranges, and save and open workbooks.

    * How to enhance a worksheet using style, how to use headers and footers, how to use 3-D worksheets, how to link them together and how to create and add graphs to a workbook, edit, preview and print the results.

    * How to design and build a management system, how to manage conditional rules and how to set up and query a database.

    * How to use Formula Auditing, the Watch Window, What-if Analysis, Goal Seek, What-if Data Tables and Solver and how to manage What-if scenarios.

    * How to share information with other applications by linking, embedding and using hyperlinks and how to use Excel to publish data to the Web.

    * How to create and edit simple recorder macros, and how to use Excel's inbuilt functions.

      And much more besides

This book will be an invaluable reference long after you have mastered the software.

1. Package Overview

2. The Excel 2007 Environment

3. The Excel 2007 Spreadsheet

4. Filling in a worksheet

5. Enhancing worksheets

6. Spreadsheet charts

7. The Excel Database

8. Other tools and capabilities

9. Sharing information

10. Excel Macro Basics

11. Exercises Using Excel

12. Excel 2007 Functions

13. Glossary of Terms

Index