Excel 2007 On Your Side: User Manual

Description

This practical guide teaches you how to get the most out of Microsoft Excel 2007.

After a description of the new environment, which has been improved from the previous versions, and learning how to manage files, templates and datasheets, you will quickly become familiar with entering and editing data (numbers, dates, calculation formulas, data series). You will then learn how to use the tools for formatting data (fonts, colours, borders, AutoFormats, styles, etc), create outlines, use worksheet auditing, and print your tables replete with various graphics and charts.

The guide also explains the different ways you can use Excel to create tables and pivot charts by using datasheets. As a portion of this guide focuses on working with multiple users, it includes all you need to know about sharing and protecting your data.

The latter chapters discuss techniques for improving data entry (creating custom data series or drop-down lists), and how to insert hyperlinks, import and export data, use macro commands, and create Web pages.

CONTENTS:

Microsoft Excel 2007

Managing Documents

Entering/Editing Data

Worksheets

Calculations

Presenting Data

Organising Data

Printing Data

Charts and Objects

Graphic Objects

Excel Tables and Pivot Tables

Group Work

Various Advanced Features