Microsoft Office Excel 2007: Basic

Description

Excel 2007 is the most popular spreadsheet program for both business and personal use. Well designed spreadsheets enable you to organize complex data, but more importantly they make it possible to analyze and share information clearly and securely. Whether you're reviewing complex financial statements or simply creating editable phone lists, start with a thorough understanding of all the features and tools within this powerful program.

CONTENTS:

Getting started

Topic A: Spreadsheet terminology

Topic B: Exploring the Excel window

Topic C: Getting help

Topic D: Navigating workbooks

Unit summary: Getting started

Entering and editing data

Topic A: Entering and editing text and values

Topic B: Entering and editing formulas

Topic C: Working with pictures

Topic D: Saving and updating workbooks

Unit summary: Entering and editing data

Modifying a worksheet

Topic A: Moving and copying data

Topic B: Moving and copying formulas

Topic C: Absolute and relative references-

Topic D: ing and deleting ranges, rows, and columns

Unit summary: Modifying a worksheet

Using functions

Topic A: Entering functions

Topic B: AutoSum

Topic C: Other useful functions

Unit summary: Using functions

Formatting worksheets

Topic A: Formatting text

Topic B: Formatting rows and columns

Topic C: Formatting numbers

Topic D: Conditional formatting

Topic E: Copying formats and applying table formats

Unit summary: Formatting worksheets

Printing

Topic A: Preparing to print

Topic B: Page Setup options

Topic C: Printing worksheets

Unit summary: Printing

Creating charts

Topic A: Chart basics

Topic B: Modifying charts

Topic C: Printing charts

Unit summary: Creating charts

Managing large workbooks

Topic A: Viewing large worksheets

Topic B: Printing large worksheets

Topic C: Using multiple worksheets

Unit summary: Managing large workbooks

Course summary

Topic A: Course summary

Topic B: Continued learning after class

Glossary

Index