The Unofficial Guide^® to Microsoft^® Office Excel^® 2007

by Julia Kelly; Curt Simmons (St. Jo, Texas)

• ISBN13: 9780470377536
• ISBN10: 0470377534
• Format: eBook
• Copyright: 2008-02-01
• Publisher: Wiley

Summary

The inside scoop...for when you want more than the official line! Microsoft Office Excel 2007 may be just what you need to crunch numbers, but to use it with confidence, you'll need to know its quirks and shortcuts. Find out what the manual doesn't always tell you in this insider's guide to using Excel in the real world. What are the secrets of pro users? Are there shortcuts for repetitive tasks? From writing formulas to using charts, first get the official way, then the best way from two experts. Unbiased coverage of how to get the most out of Excel 2007, from creating workbooks and writing formulas to comparing data Savvy, real-world advice to help you set up, enter, format, and organize your data Time-saving techniques and practical guidance on creating custom macros with VBA and using PivotTables and PivotCharts Tips and hacks with practical ways to save time, avoid pitfalls, and increase your output Sidebars, tables, and illustrations featuring toolbar buttons and more ways to be productive in Excel Watch for these graphic icons in every chapter to guide you to specific practicalinformation. Bright Ideas are smart innovations that will save you time or hassle. Hacks are insider tips and shortcuts that increase productivity. When you see Watch Out! heed the cautions or warnings to help you avoid commonpitfalls. And finally, check out Inside Scoops for practical insights from the author. It's like having your own expert at your side!

Table of Contents

I Starting Out with Excel 2007.

Getting In and Out

Starting Excel

The Excel environment

Getting help

Opening workbook files

Using hyperlinks

Saving workbook files

Creating and using templates

Closing workbook files

Quitting Excel

Just the facts

All About Worksheets

Worksheet basics

Selecting worksheets

Naming worksheets

Color-coding workbook contents

Rearranging worksheets

Adding and deleting worksheets

Moving around in a worksheet

Multiple windows

Zooming your view

Just the facts

II Crunching Numbers.

Entering and Editing Data

Entering data directly

Using data entry techniques

Creating a dynamic list/table

Validating data during entry

Editing cell entries

Finding and replacing data

Moving and copying data

Inserting, deleting, and rearranging

Breaking a column into multiple columns

Adding worksheet comments

Checking your spelling

Just the facts

Working Data Magic with Calculations

Simple calculations, quick answers

About cell references

Writing formulas

Moving and copying formulas

Linking worksheets and workbooks

Using cell names

Editing formulas

Tracing a formula

Locating worksheet errors

Just the facts

Excel Functions

Using functions

Common and useful functions

Combining functions for more power

Just the facts

III Dressing Up Your Data.

Formatting Cells

The Font and Alignment Ribbon groups

Formatting the font

Working with borders

Adding colors

Fitting the text in the cell

Copying formatting with Format Painter

Just the facts

Formatting Numbers and Using Styles

Applying number formats to cells

Ribbon buttons for formats

The Format Cells dialog box

Formatting dates and times

Formatting text entries

Creating custom formats

Applying conditional number formats

Converting actual values to displayed values

Hiding zeroes

Using styles to streamline formatting

Just the facts

IV Organizing Data.

Organizing Data

Sorting lists

Filtering records

Calculating filtered records

The Query Wizard ù A better filter

Query a Web page

Just the facts

Finding and Comparing Answers

Consolidating a table

Subtotaling a table

Scenarios

Compare answers with data tables

Goal seeking for simple answers

Answering complex questions with Solver

Just the facts

Summarizing Data Dynamically with PivotTables

Using PivotTables

PivotTable terms

Creating a PivotTable

The PivotTable Tools tab

Changing PivotTable arrangement

Changing PivotTable calculations

Showing underlying details

Formatting numbers

Just the facts

Displaying PivotTables Graphically with PivotCharts

PivotCharts versus normal charts

Creating PivotCharts

Rearranging PivotCharts

Formatting PivotCharts

Embedding a PivotChart on a worksheet

Just the facts

V Presenting Your Data.

Presenting Data Visually with Charts

Creating a chart

The Charts group

Types of charts

Changing chart data

Quickly changing chart layout

Moving and resizing an embedded chart

Changing the chart location

Just the facts

Formatting Charts

Chart formatting possibilities

Formatting chart elements

Changing axis scale

Reordering the series

Enlarging and exploding a pie chart

Changing 3-D perspective

Adding a trendline

Adding a secondary axis

Working with data labels

Creating picture markers

Saving and reusing your custom chart format

Just the facts

Adding Pictures and Graphic Objects

Using the Shapes group

Drawing basic shapes

Formatting for all graphic objects

Creating AutoShapes

Drawing text boxes

Creating WordArt

Inserting pictures and clip art

Creating SmartArt

Pasting pictures of cells

Just the facts

VI Sharing Excel Data.

Printing Just What You Need

Previewing printed pages

Printing a quick copy of a worksheet

Printing part of a worksheet

Printing a chart

Printing several worksheets

Just the facts

Formatting the Printed Page

Setting page breaks

Changing the page layout

Printing a specific number of pages

Printing row/column labels on every page

Creating a header or footer

Printing worksheet gridlines

Printing in black and white

Formatting printed charts

Just the facts

Sharing a Workbook with Other Users

Sharing a workbook

Reviewing changes in a shared workbook

Sending and routing workbooks

Protecting workbooks and worksheets

Just the facts

Sharing a Workbook Between Programs

Shared-data terminology

Sending data between Excel and Word

Sending data between Excel and Access

Pasting Excel data into PowerPoint

Dragging a hyperlink into Excel

Saving a worksheet as a Web page

Just the facts

VII Making Excel Your Own.

Customizing Your Workspace

Changing your screen display

Minimizing the Ribbon

Customizing the Quick Access toolbar

Personalizing features

Proofing options

Setting Advanced options

Just the facts

Adding Controls to a Worksheet

What can worksheet controls do?

Forms Controls

All worksheet controls

List boxes and combo boxes

Option buttons and group boxes

Scroll bars and spinners

Check boxes

Button controls

Labels

Just the facts

Using Macros to Automate Repetitive Work

Introducing macros

Recording a macro

Running a macro

Exploring the Visual Basic Editor

Editing a macro

Deleting a macro

Setting macro virus protection

Just the facts

VIII Appendixes

Build Creative Worksheets

Recommended Resources

Glossary

Index.

Table of Contents provided by Publisher. All Rights Reserved.