The Unofficial Guide to Microsoft Office Excel 2007

Marketplace (New and Used)
from
$1.99
$18.99 List Price (Save 90%)
All (22)  
Used (13)  
New (9)  
Close
Sort by
Page 1 of 3
Showing 1 – 10 of 22 (3 pages)
$1.99
(Save 90%)
Seller since 2012

Feedback rating:

(1010)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

Acceptable
Free State Books. Never settle for less.

Ships from: Halethorpe, MD

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$1.99
(Save 90%)
Seller since 2009

Feedback rating:

(4450)

Condition: Acceptable
Book selection as BIG as Texas.

Ships from: Dallas, TX

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$1.99
(Save 90%)
Seller since 2009

Feedback rating:

(8063)

Condition: Good
Book shows minor use. Cover and Binding have minimal wear and the pages have only minimal creases. A tradition of southern quality and service. All books guaranteed at the ... Atlanta Book Company. Our mailers are 100% recyclable. Read more Show Less

Ships from: Atlanta, GA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$1.99
(Save 90%)
Seller since 2010

Feedback rating:

(3293)

Condition: Good

Ships from: Lakewood, WA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$1.99
(Save 90%)
Seller since 2007

Feedback rating:

(5906)

Condition: Good
Light shelf wear and minimal interior marks. Millions of satisfied customers and climbing. Thriftbooks is the name you can trust, guaranteed. Spend Less. Read More.

Ships from: Auburn, WA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$4.14
(Save 78%)
Seller since 2007

Feedback rating:

(3210)

Condition: Good
Buy with confidence. Excellent Customer Service & Return policy.

Ships from: Richmond, TX

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
$7.10
(Save 63%)
Seller since 2005

Feedback rating:

(305)

Condition: Good
2007-02-05 Paperback Good Clean condition. All pages and cover are intact (including the dust cover if applicable). May have worn edges and cover and may have small creases. ... Satisfaction guaranteed. USPS tracking included at no additional charge. Read more Show Less

Ships from: Deltona, FL

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$10.72
(Save 44%)
Seller since 2007

Feedback rating:

(21685)

Condition: New
BRAND NEW

Ships from: Avenel, NJ

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
$10.82
(Save 43%)
Seller since 2008

Feedback rating:

(14111)

Condition: New
Brand New, Perfect Condition, Please allow 4-14 business days for delivery. 100% Money Back Guarantee, Over 1,000,000 customers served.

Ships from: South Bend, IN

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
$12.12
(Save 36%)
Seller since 2008

Feedback rating:

(135)

Condition: New
0470045949 BRAND NEW NEVER USED IN STOCK 125,000+ HAPPY CUSTOMERS SHIP EVERY DAY WITH FREE TRACKING NUMBER

Ships from: fallbrook, CA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 3
Showing 1 – 10 of 22 (3 pages)
Close
Sort by

Overview

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

See more details below
Sending request ...

Overview

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!

Product Details

  • ISBN-13: 9780470045947
  • Publisher: Wiley, John & Sons, Incorporated
  • Publication date: 1/30/2007
  • Edition number: 1
  • Pages: 487
  • Series: Unofficial Guides Series
  • 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.

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.

Scenarios.

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.

Labels.

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.

Glossary.

Index.

Customer Reviews

Be the first to write a review
( 0 )

Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or Leave Anonymously

Barnes & Noble.com 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 & Noble.com 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 & Noble.com 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 BN.com 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

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com 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 identiy on BN.com. 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

We're sorry, but penname is already taken.

Please select one of the following:
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

penname is available!

By visiting the BN.com website or marking a purchase on BN.com, a User is deemed to have accepted the Terms of Use.

Continue Anonymously

Welcome, penname

You have successfully created your Pen Name. Start enjoying the benefits of the BN.com Community today.


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