The Unofficial Guide to Microsoft Office Excel 2007


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...

See more details below
Other sellers (Paperback)
  • All (21) from $1.99   
  • New (7) from $9.91   
  • Used (14) from $1.99   
Sending request ...


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!

Read More Show Less

Product Details

  • ISBN-13: 9780470045947
  • Publisher: Wiley
  • Publication date: 1/30/2007
  • Series: Unofficial Guides Series
  • Edition number: 1
  • Pages: 487
  • Product dimensions: 6.10 (w) x 9.00 (h) x 1.10 (d)

Meet the Author

Julia Kelly lives in rural north Idaho with horses, cats, small garden dogs, assorted wild animals, free-range chickens, and bird dogs who’ve finally learned not to “retrieve” the free-range chickens.

Curt Simmons lives in Saint Jo, Texas, with his wife and two daughters. The author of more than 50 computing books on a wide range of topics, he primarily writes about Microsoft products. When he is not writing, Curt enjoys gardening and working on his 107-year-old home.

Read More Show Less

Table of Contents

I Starting Out with Excel 2007.

1 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.

2 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.

3 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.

4 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.

5 Excel Functions.

Using functions.

Common and useful functions.

Combining functions for more power.

Just the facts.

III Dressing Up Your Data.

6 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.

7 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.

8 Organizing Data.

Sorting lists.

Filtering records.

Calculating filtered records.

The Query Wizard — A better filter.

Query a Web page.

Just the facts.

9 Finding and Comparing Answers.

Consolidating a table.

Subtotaling a table.


Compare answers with data tables.

Goal seeking for simple answers.

Answering complex questions with Solver.

Just the facts.

10 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.

11 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.

12 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.

13 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.

14 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.

15 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.

16 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.

17 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.

18 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.

19 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.

20 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.


Just the facts.

21 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.

Appendix A: Build Creative Worksheets.

Appendix B: Recommended Resources.



Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)