Open Learning Guide for Excel 2007 Intermediate

Description

This A4 spiral bound manual has been specifically designed to provide the necessary knowledge and techniques for the successful creation and manipulation of an Excel spreadsheet. The accompanying data files on disk are designed to help demonstrate the features you are learning as you work through the manual step-by-step.

CONTENTS:

Manipulating Worksheet Views

Working with Multiple Windows

Creating and Using Comments

Using Names

Cell and Workbook Protection

Hiding Information

Advanced Formatting

Conditional Formatting

Advanced Cell Editing

Working with Templates

Advanced Printing

Using Advanced Formulas

Using Solver and Goal Seek

Working with Scenarios

Creating Views

Linking

Creating & Using Lists & Database Functions

Filtering Lists

Sorting Data

PivotTables