Excel 2007 for Starters

by MacDonald, Matthew

• ISBN13: 9780596528324
• ISBN10: 0596528329
• Format: Paperback
• Copyright: 2007-01-01
• Publisher: Oreilly & Associates Inc

Summary

Fast-paced and easy to use, our new guide teaches readers the basics of Excel 2007 so they can start using the program right away. They'll quickly learn how to build spreadsheets, add and format information, print reports, create charts and graphics, and use basic formulas and functions. The new Excel user interface is radically different from previous versions, but with this book, readers can breeze through the basic features in no time. With clear explanations, step-by-step instructions, lots of illustrations, and plenty of friendly advice, this For Starters Manual is the perfect primer for small businesses with no techie to turn to, as well as those who want to organize household and office information.

Author Biography

Matthew MacDonald is an author, educator, and software developer. He is the author of Excel 2007: The Missing Manual and several books about .NET, including The Book of VB .NET (No Starch), ASP.NET: The Complete Reference (McGraw-Hill), Microsoft .NET Distributed Applications (Microsoft Press), and several more. He is a regular columnist for Inside Visual Basic, and has been involved in non-programming writing projects like the classical All-Music Guide.

Table of Contents

The Missing Credits

Introduction

Worksheet Basics

Creating and Navigating Worksheets

Creating a Basic Worksheet

Starting a New Workbook

Adding the Column Titles

Adding Data

Editing Data

Navigating in Excel

The Tabs of the Ribbon

The Formula Bar

The Status Bar

Excel Options

Saving Files

The Excel 2007 File Format

Saving Your Spreadsheet in Older Formats

Saving Your Spreadsheet As a PDF

Disaster Recovery

Opening Files

Opening Multiple Spreadsheets at Once

Adding Information to Worksheets

Adding Different Types of Data

Controlling Your Data Types

Quick Ways to Add Data

Auto Complete

Auto Correct

Auto Fill

Auto Fit Undo and Redo

Moving Data Around a Worksheet

Selecting Cells

Making Continuous Range Selections

Making Non-Contiguous Selections

Automatically Selecting Your Data

Making Selections with the Keyboard

Moving Cells Around

A Simple Cut-and-Paste or Copy-and-Paste

A Fancy Cut-and-Paste or Copy-and-Paste

The Clipboard

Special Pasting

Adding and Moving Columns or Rows

Inserting Columns

Inserting Rows

Inserting Copied or Cut Cells

Deleting Columns and Rows

Managing Worksheets and Workbooks

Worksheets and Workbooks

Adding, Removing, and Hiding Worksheets

Naming and Rearranging Worksheets

Find and Replace

The Basic Find

Find All

More Advanced Searches

Finding Formatted Cells

Finding and Replacing Values

Spell Check

Spell Checking Options

Formatting Cells

Formatting Cell Values

Formatting Numbers

Formatting Dates and Times

Special Formats for Special Numbers

Formatting Cell Appearance

Alignment and Orientation

Fonts and Color

Borders and Fills

Drawing Borders by Hand

Smart Ways to Apply Formatting

The Format Painter

Styles and Themes

Viewing and Printing Worksheets

Controlling Your View

Zooming

Viewing Distant

Parts of a Spreadsheet at Once

Freezing Columns or Rows

Hiding Data

Saving View Settings

Printing

How to Print an Excel File

Quick Printing

Previewing Your Printout

Creating Headers and Footers

Customizing Print Settings

Controlling Pagination

Page Breaks

Scaling

Page Break Preview: A Bird's-Eye View of Your Worksheet

Worksheet power

Building Basic Formulas

Creating a Basic Formula

Excel's Order of Operations Cell

References

How Excel Formats Cells That Contain Cell

References

Functions

Formula Errors

Logical Operators

Formula Shortcuts

Point-and-Click Formula Creation

Point-and-Click Formula Editing

The Formulas Tab

Using the Insert Function Button to Quickly Find and Insert Functions

Copying Formulas

Absolute Cell

References

Partially Fixed

References

Tables: List Management Made Easy

The Basics of Tables

Creating a Table

Formatting a Table

Editing a Table

Selecting Parts of a Table

Sorting and Filtering a Table

Applying a Simple Sort Order

Sorting with Multiple Criteria

Filtering with the List of Values

Creating Smarter Filters

Creating Basic Charts

Charting 101 Embedded and Standalone Charts

Creating a Chart with the Ribbon

The Chart Tools Ribbon Tabs

Basic Tasks with Charts

Moving and Resizing a Chart

Creating a Standalone Chart

Editing and Adding to Chart Data

Changing the Chart Type

Printing Charts

Practical Charting

Charts with Multiple Series of Numbers

Controlling the Data Excel Plots on the X-Axis

Non-Contiguous Chart Ranges

Changing the Order of Your Data Series

Changing the Way Excel Plots Blank Values

Chart Types

Column

BarLine

PieArea

Appendix

Customizing the Quick Access Toolbar

Index"

Table of Contents provided by Publisher. All Rights Reserved.