Microsoft Excel 2010 Step by Step

( 2 )

Overview

Experience learning made easy-and quickly teach yourself how to organize, analyze, and present data with Excel 2010. With STEP BY STEP, you set the pace-building and practicing the skills you need, just when you need them! Topics include creating formulas, calculating values, and analyzing data; presenting information visually with graphics, charts, and diagrams; building PivotTable dynamic views; using the new Excel Web App; reusing information from databases and other documents; creating macros to automate ...

See more details below
Paperback
$18.21
BN.com price
(Save 34%)$27.99 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (31) from $5.81   
  • New (23) from $16.13   
  • Used (8) from $5.81   
Microsoft Excel 2010 Step by Step

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK
  • 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 for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$12.99
BN.com price
(Save 43%)$22.99 List Price

Overview

Experience learning made easy-and quickly teach yourself how to organize, analyze, and present data with Excel 2010. With STEP BY STEP, you set the pace-building and practicing the skills you need, just when you need them! Topics include creating formulas, calculating values, and analyzing data; presenting information visually with graphics, charts, and diagrams; building PivotTable dynamic views; using the new Excel Web App; reusing information from databases and other documents; creating macros to automate repetitive tasks and simplify your work; and other core topics.

Read More Show Less

Product Details

  • ISBN-13: 9780735626942
  • Publisher: Microsoft Press
  • Publication date: 6/23/2010
  • Series: Step by Step Series
  • Pages: 482
  • Sales rank: 74,951
  • Product dimensions: 7.40 (w) x 9.00 (h) x 1.20 (d)

Meet the Author

Curtis D. Frye is the author of several books on Microsoft® Access® and Excel®, including Microsoft® Office Excel® 2007 Step by Step and Microsoft® Office Excel® 2003 Step by Step, along with numerous online training courses.

Read More Show Less

Table of Contents

Acknowledgments; Introducing Microsoft Excel 2010; Managing Excel Files and Settings in the Backstage View; Previewing Data by Using Paste Preview; Customizing the Excel 2010 User Interface; Summarizing Data by Using More Accurate Functions; Summarizing Data by Using Sparklines; Filtering PivotTable Data by Using Slicers; Filtering PivotTable Data by Using Search Filters; Visualizing Data by Using Improved Conditional Formats; Creating and Displaying Math Equations; Editing Pictures within Excel 2010; Managing Large Worksheets by Using the 64-bit Version of Excel 2010; Summarizing Large Data Sets by Using the PowerPivot (Project Gemini) Add-In; Accessing Your Data from Almost Anywhere by Using the Excel Web App and Excel Mobile 2010; Modifying the Display of the Ribbon; Dynamic Ribbon Elements; Changing the Width of the Ribbon; Adapting Exercise Steps; Features and Conventions of This Book; Using the Practice Files; Getting Help; Getting Help with This Book; Getting Help with Excel 2010; More Information; Chapter 1: Setting Up a Workbook; 1.1 Creating Workbooks; 1.2 Modifying Workbooks; 1.3 Modifying Worksheets; 1.4 Customizing the Excel 2010 Program Window; 1.5 Key Points; Chapter 2: Working with Data and Excel Tables; 2.1 Entering and Revising Data; 2.2 Moving Data Within a Workbook; 2.3 Finding and Replacing Data; 2.4 Correcting and Expanding Upon Worksheet Data; 2.5 Defining Excel Tables; 2.6 Key Points; Chapter 3: Performing Calculations on Data; 3.1 Naming Groups of Data; 3.2 Creating Formulas to Calculate Values; 3.3 Summarizing Data That Meets Specific Conditions; 3.4 Finding and Correcting Errors in Calculations; 3.5 Key Points; Chapter 4: Changing Workbook Appearance; 4.1 Formatting Cells; 4.2 Defining Styles; 4.3 Applying Workbook Themes and Excel Table Styles; 4.4 Making Numbers Easier to Read; 4.5 Changing the Appearance of Data Based on Its Value; 4.6 Adding Images to Worksheets; 4.7 Key Points; Chapter 5: Focusing on Specific Data by Using Filters; 5.1 Limiting Data That Appears on Your Screen; 5.2 Manipulating Worksheet Data; 5.3 Defining Valid Sets of Values for Ranges of Cells; 5.4 Key Points; Chapter 6: Reordering and Summarizing Data; 6.1 Sorting Worksheet Data; 6.2 Organizing Data into Levels; 6.3 Looking Up Information in a Worksheet; 6.4 Key Points; Chapter 7: Combining Data from Multiple Sources; 7.1 Using Workbooks as Templates for Other Workbooks; 7.2 Linking to Data in Other Worksheets and Workbooks; 7.3 Consolidating Multiple Sets of Data into a Single Workbook; 7.4 Grouping Multiple Sets of Data; 7.5 Key Points; Chapter 8: Analyzing Alternative Data Sets; 8.1 Defining an Alternative Data Set; 8.2 Defining Multiple Alternative Data Sets; 8.3 Varying Your Data to Get a Desired Result by Using Goal Seek; 8.4 Finding Optimal Solutions by Using Solver; 8.5 Analyzing Data by Using Descriptive Statistics; 8.6 Key Points; Chapter 9: Creating Dynamic Worksheets by Using PivotTables; 9.1 Analyzing Data Dynamically by Using PivotTables; 9.2 Filtering, Showing, and Hiding PivotTable Data; 9.3 Editing PivotTables; 9.4 Formatting PivotTables; 9.5 Creating PivotTables from External Data; 9.6 Key Points; Chapter 10: Creating Charts and Graphics; 10.1 Creating Charts; 10.2 Customizing the Appearance of Charts; 10.3 Finding Trends in Your Data; 10.4 Summarizing Your Data by Using Sparklines; 10.5 Creating Dynamic Charts by Using PivotCharts; 10.6 Creating Diagrams by Using SmartArt; 10.7 Creating Shapes and Mathematical Equations; 10.8 Key Points; Chapter 11: Printing; 11.1 Adding Headers and Footers to Printed Pages; 11.2 Preparing Worksheets for Printing; 11.3 Printing Worksheets; 11.4 Printing Parts of Worksheets; 11.5 Printing Charts; 11.6 Key Points; Chapter 12: Automating Repetitive Tasks by Using Macros; 12.1 Enabling and Examining Macros; 12.2 Creating and Modifying Macros; 12.3 Running Macros When a Button Is Clicked; 12.4 Running Macros When a Workbook Is Opened; 12.5 Key Points; Chapter 13: Working with Other Microsoft Office Programs; 13.1 Including Office Documents in Workbooks; 13.2 Storing Workbooks as Parts of Other Office Documents; 13.3 Creating Hyperlinks; 13.4 Pasting Charts into Other Documents; 13.5 Key Points; Chapter 14: Collaborating with Colleagues; 14.1 Sharing Workbooks; 14.2 Managing Comments; 14.3 Tracking and Managing Colleagues’ Changes; 14.4 Protecting Workbooks and Worksheets; 14.5 Authenticating Workbooks; 14.6 Saving Workbooks for the Web; 14.7 Key Points; Glossary; Keyboard Shortcuts; Ctrl Combination Shortcut Keys; Function Keys; Other Useful Shortcut Keys; About the Author;

Read More Show Less

Customer Reviews

Average Rating 4.5
( 2 )
Rating Distribution

5 Star

(1)

4 Star

(1)

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
Sort by: Showing all of 2 Customer Reviews
  • Posted February 1, 2013

    not for beginners-has alot of helpful information

    Having had other Step by Step books made it easier for me to learn at my own pace to improve my skills with Excel. if you know some Excel and want to improve your spreadsheets this is the book for you. this book was easy to understand and very helpful. Thanks

    1 out of 1 people found this review helpful.

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

    Posted February 13, 2014

    Tcnto

    Jl.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing all of 2 Customer Reviews

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