Microsoft Office Excel 2007 Step by Step

Overview

Experience learning made easy—and quickly teach yourself how to organize, analyze, and present data with Excel 2007. With Step By Step, you set the pace—building and practicing the skills you need, just when you need them!

  • Create formulas, calculate values, and analyze data
  • Present information visually ...
See more details below
Paperback (REV)
$17.31
BN.com price
(Save 30%)$24.99 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (52) from $1.99   
  • New (12) from $4.28   
  • Used (40) from $1.99   
Microsoft Office Excel 2007 Step by Step

Available on NOOK devices and apps  
  • NOOK Devices
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK Study
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$11.49
BN.com price
(Save 42%)$19.99 List Price

Overview

Experience learning made easy—and quickly teach yourself how to organize, analyze, and present data with Excel 2007. With Step By Step, you set the pace—building and practicing the skills you need, just when you need them!

  • Create formulas, calculate values, and analyze data
  • Present information visually with graphics, charts, and diagrams
  • Build PivotTable dynamic views—even easier with new data tables
  • Reuse information from databases and other documents
  • Share spreadsheets for review and manage changes
  • Create macros to automate repetitive tasks and simplify your work

Your all-in-one learning experience includes:

  • Files for building skills and practicing the book’s lessons
  • Fully searchable eBook
  • Bonus quick reference to the Ribbon, the new Microsoft Office interface
  • Windows Vista Product Guide eReference—plus other resources on CD

For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

Read More Show Less

Editorial Reviews

From Barnes & Noble
The Barnes & Noble Review
If you want to learn Excel quickly and thoroughly, without ever being patronized or bewildered, read Microsoft Office Excel 2007 Step by Step.

We're huge fans of Microsoft's Step-by-Step series. These hands-on software tutorials borrow the best ideas from decades of computer books and add some great innovations of their own. They're a pleasure to use. Even small details are handled well: for example, each task's instructions are formatted and color-coded for easier reading. At a higher level, these books -- and the Excel guide in particular -- are superbly organized and edited. You can learn systematically, end-to-end, or learn just what you need today.

Oh, and if you're worried about the Ribbon, the controversial centerpiece of Excel's new interface, don't. This book will make you right at home. There's even a full-color poster for handy reference. Bill Camarda, from the March 2007 Read Only

Read More Show Less

Product Details

  • ISBN-13: 9780735623040
  • Publisher: Microsoft Press
  • Publication date: 1/31/2007
  • Series: Microsoft Step by Step Series
  • Edition description: REV
  • Pages: 432
  • Sales rank: 186,443
  • Product dimensions: 7.35 (w) x 9.00 (h) x 1.05 (d)

Meet the Author

Curtis Frye is the author of numerous books on Excel and other Office products, most recently Microsoft Excel 2010 Step by Step. He graduated from Syracuse in 1990 with a degree in political science, and then moved to Washington, DC, where he worked as a defense trade analyst for four years and as the director of sales and marketing for an ISP for one year. He moved to Portland, Oregon, in 1995 to launch his freelance writing career. When Curt's not writing, and often while he is writing, he is a keynote speaker, mentalist, and professional improvisational comedian.

Read More Show Less

Table of Contents

About the Author; Curtis Frye; Acknowledgments; Features and Conventions; Using the Book’s CD; What’s on the CD?; Minimum System Requirements; Installing the Practice Files; Using the Practice Files; Uninstalling the Practice Files; Getting Help; Getting Help with This Book and Its Companion CD; Getting Help with Office Excel 2007; The Microsoft Business Certification Program; Selecting a Certification Path; Becoming a Microsoft Certified Application Specialist—Microsoft 2007 Office System; Becoming a Microsoft Certified Application Professional; Taking a Microsoft Business Certification Exam; Quick Reference; 2 Setting Up a Workbook; 3 Working with Data and Data Tables; 4 Performing Calculations on Data; 5 Changing Document Appearance; 6 Focusing on Specific Data Using Filters; 7 Reordering and Summarizing Data; 8 Combining Data from Multiple Sources; 9 Analyzing Alternative Data Sets; 10 Creating Dynamic Lists with PivotTables; 11 Creating Charts and Graphics; 12 Printing; 13 Automating Repetitive Tasks with Macros; 14 Working with Other Microsoft Office System Programs; 15 Collaborating with Colleagues; Chapter 1: What’s New in Excel 2007?; Becoming Familiar with the New User Interface; Managing Larger Data Collections; Using the New Microsoft Office File Format; Formatting Cells and Worksheets; Managing Data Tables More Effectively; Creating Formulas More Easily by Using Formula AutoComplete; Summarizing Data Using New Functions; Creating Powerful Conditional Formats; Creating More Attractive Charts; Controlling Printouts More Carefully; Key Points; Chapter 2: Setting Up a Workbook; Creating Workbooks; Modifying Workbooks; Modifying Worksheets; Customizing the Excel 2007 Program Window; Key Points; Chapter 3: Working with Data and Data Tables; Entering and Revising Data; Moving Data Within a Workbook; Finding and Replacing Data; Correcting and Expanding Upon Worksheet Data; Defining a Table; Key Points; Chapter 4: Performing Calculations on Data; Naming Groups of Data; Creating Formulas to Calculate Values; Summarizing Data That Meets Specific Conditions; Finding and Correcting Errors in Calculations; Key Points; Chapter 5: Changing Document Appearance; Formatting Cells; Defining Styles; Applying Workbook Themes and Table Styles; Making Numbers Easier to Read; Changing the Appearance of Data Based on Its Value; Adding Images to a Document; Key Points; Chapter 6: Focusing on Specific Data Using Filters; Limiting Data That Appears on Your Screen; Manipulating List Data; Defining Valid Sets of Values for Ranges of Cells; Key Points; Chapter 7: Reordering and Summarizing Data; Sorting Data Lists; Organizing Data into Levels; Looking Up Information in a Data List; Key Points; Chapter 8: Combining Data from Multiple Sources; Using Data Lists as Templates for Other Lists; Linking to Data in Other Worksheets and Workbooks; Consolidating Multiple Sets of Data into a Single Workbook; Grouping Multiple Sets of Data; Key Points; Chapter 9: Analyzing Alternative Data Sets; Defining and Editing Alternative Data Sets; Defining Multiple Alternative Data Sets; Varying Your Data to Get a Desired Result Using Goal Seek; Finding Optimal Solutions with Solver; Analyzing Data with Descriptive Statistics; Key Points; Chapter 10: Creating Dynamic Lists with PivotTables; Analyzing Data Dynamically with PivotTables; Filtering, Showing, and Hiding PivotTable Data; Editing PivotTables; Formatting PivotTables; Creating PivotTables from External Data; Key Points; Chapter 11: Creating Charts and Graphics; Creating Charts; Customizing the Appearance of Charts; Finding Trends in Your Data; Creating Dynamic Charts Using PivotCharts; Creating Diagrams by Using SmartArt; Key Points; Chapter 12: Printing; Adding Headers and Footers to Printed Pages; Preparing Worksheets for Printing; Printing Data Lists; Printing Parts of Data Lists; Printing Charts; Key Points; Chapter 13: Automating Repetitive Tasks with Macros; Introducing Macros; Creating and Modifying Macros; Running Macros When a Button Is Clicked; Running Macros When a Workbook Is Opened; Key Points; Chapter 14: Working with Other Microsoft Office System Programs; Including Microsoft Office System Documents in Excel 2007 Worksheets; Storing Excel 2007 Documents as Parts of Other Microsoft Office System Documents; Creating Hyperlinks; Pasting Charts into Other Documents; Key Points; Chapter 15: Collaborating with Colleagues; Sharing Data Lists; Managing Comments; Tracking and Managing Colleagues’ Changes; Protecting Workbooks and Worksheets; Authenticating Workbooks; Saving Workbooks for the Web; Key Points; Glossary; Appendix : Choose the Right Book for You; Published and Upcoming Titles;

Read More Show Less

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

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 identity 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
See All Sort by: Showing 1 – 20 of 33 Customer Reviews
  • Posted September 17, 2009

    Excel 2007

    I do not like this book at all. It is obviously written by someone of a programmer background and not an educator. Sentence structure is difficult at best. Instructions are unclear. It is not written with clear steps and examples. It is a very basic book, but I don't know if beginners can follow it.

    2 out of 2 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted June 8, 2009

    Not very well written

    I have purchased other Step by Step books and I found this one to be very poor. After encountering a few minor misprints/mis-information I tried to contact the support for assistance. This information was found on page xix. I e-mailed them three times. That was a month or longer and I still haven't heard from them and I still do not have answers to my questions.

    I would not recommend that anyone purchase this book. Maybe try Excel for Idiots...

    2 out of 2 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted December 6, 2011

    Great for Starters

    This is a great book for beginners learning excel.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted December 6, 2011

    [...]

    I love the product.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted December 6, 2011

    I would buy this product again

    I teach computer classes and this book was perfect for my recent class

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted December 6, 2011

    Very pleased with book so far

    reliable

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted December 6, 2011

    Only looking for pivot tables.

    Reference material for specific needs.

    Was this review helpful? Yes  No   Report this review
  • Posted February 20, 2010

    Great Book, not so great software!

    The book has everything I need and then some. The problem lies within the CD's "practice files". They will not download due to a gliche in their script writer. I contacted Microsoft for resolution and was disappointed in the handling of my problem. They knew about this issue but did not have a repair/replacement CD to correct it.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted November 15, 2009

    No text was provided for this review.

  • Anonymous

    Posted March 14, 2010

    No text was provided for this review.

  • Anonymous

    Posted January 22, 2009

    No text was provided for this review.

  • Anonymous

    Posted January 17, 2010

    No text was provided for this review.

  • Anonymous

    Posted March 21, 2009

    No text was provided for this review.

  • Anonymous

    Posted April 1, 2011

    No text was provided for this review.

  • Anonymous

    Posted February 2, 2009

    No text was provided for this review.

  • Anonymous

    Posted November 12, 2008

    No text was provided for this review.

  • Anonymous

    Posted December 19, 2008

    No text was provided for this review.

  • Anonymous

    Posted November 30, 2008

    No text was provided for this review.

  • Anonymous

    Posted September 15, 2009

    No text was provided for this review.

  • Anonymous

    Posted November 23, 2008

    No text was provided for this review.

See All Sort by: Showing 1 – 20 of 33 Customer Reviews

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