Excel 2010: The Missing Manual

( 6 )

Overview

Excel, the world's most popular spreadsheet program, has the muscle to analyze heaps of data. Beyond basic number-crunching, Excel 2010 has many impressive features that are hard to find, much less master -- especially from online help pages. This Missing Manual clearly explains how everything works with a unique and witty style to help you ...

See more details below
Paperback
$23.99
BN.com price
(Save 40%)$39.99 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (17) from $15.20   
  • New (10) from $22.03   
  • Used (7) from $15.20   
Excel 2010: The Missing Manual

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)
$17.99
BN.com price
(Save 43%)$31.99 List Price

Overview

Excel, the world's most popular spreadsheet program, has the muscle to analyze heaps of data. Beyond basic number-crunching, Excel 2010 has many impressive features that are hard to find, much less master -- especially from online help pages. This Missing Manual clearly explains how everything works with a unique and witty style to help you learn quickly.

  • Navigate with ease. Master Excel's tabbed toolbar and its new backstage view
  • Perform a variety of calculations. Write formulas for rounding numbers, calculating mortgage payments, and more
  • Organize your data. Search, sort, and filter huge amounts of information
  • Illustrate trends. Bring your data to life with charts and graphics -- including miniature charts called Sparklines
  • Examine your data. Summarize information and find hidden patterns with pivot tables and slicers
  • Share your spreadsheets. Use the Excel Web App to collaborate with colleagues online
  • Rescue lost data. Restore old versions of data and find spreadsheets you forgot to save
Read More Show Less

Product Details

  • ISBN-13: 9781449382353
  • Publisher: O'Reilly Media, Incorporated
  • Publication date: 7/5/2010
  • Series: Missing Manual Series
  • Pages: 871
  • Sales rank: 131,402
  • Product dimensions: 7.10 (w) x 9.20 (h) x 2.00 (d)

Meet the Author

Matthew MacDonald is a science and technology writer with well over a dozen books to his name. Web novices can tiptoe out onto the Internet with him in Creating a Website: The Missing Manual. HTML fans can learn about the cutting edge of web design in HTML5: The Missing Manual. And human beings of all description can discover just how strange they really are in the quirky handbooks Your Brain: The Missing Manual and Your Body: The Missing Manual.

Read More Show Less

Table of Contents

The Missing Credits;
About the Author;
About the Creative Team;
Acknowledgements;
The Missing Manual Series;
Introduction;
What You Can Do with Excel;
The Modern Face of Excel;
Excel's New Features;
About This Book;
Part One: Worksheet Basics;
Chapter 1: Creating Your First Spreadsheet;
1.1 Creating a Basic Worksheet;
1.2 Moving Around the Grid;
1.3 A Tour of the Excel Window;
1.4 Saving Files;
1.5 Opening Files;
Chapter 2: Adding Information to Worksheets;
2.1 Adding Different Types of Data;
2.2 Handy Timesavers;
2.3 Dealing with Change: Undo, Redo, and AutoRecover;
2.4 Spell Check;
2.5 Adding Hyperlinks;
Chapter 3: Moving Data;
3.1 Selecting Cells;
3.2 Making Continuous Range Selections;
3.3 Making Noncontiguous Selections;
3.4 Automatically Selecting Your Data;
3.5 Making Selections with the Keyboard;
3.6 Moving Cells Around;
3.7 A Simple Cut-and-Paste or Copy-and-Paste;
3.8 A Quicker Cut-and-Paste or Copy-and-Paste;
3.9 Fancy Pasting Tricks;
3.10 Paste Special;
3.11 Copying Multiple Items with the Clipboard;
3.12 Adding and Moving Columns or Rows;
3.13 Inserting Columns and Rows;
3.14 Inserting Rows;
3.15 Inserting Copied or Cut Cells;
3.16 Deleting Columns and Rows;
Chapter 4: Managing Worksheets;
4.1 Worksheets and Workbooks;
4.2 Find and Replace;
Chapter 5: Formatting Cells;
5.1 Formatting Cell Values;
5.2 Formatting Cell Appearance;
Chapter 6: Smart Formatting Tricks;
6.1 The Format Painter;
6.2 Styles and Themes;
6.3 Conditional Formatting;
Chapter 7: Viewing and Printing Worksheets;
7.1 Controlling Your View;
7.2 Printing;
7.3 Controlling Pagination;
Part Two: Formulas and Functions;
Chapter 8: Building Basic Formulas;
8.1 Creating a Basic Formula;
8.2 Functions;
8.3 Formula Errors;
8.4 Logical Operators;
8.5 Formula Shortcuts;
8.6 Copying Formulas;
Chapter 9: Math and Statistical Functions;
9.1 Rounding Numbers;
9.2 Groups of Numbers;
9.3 General Math Functions;
9.4 Trigonometry and Advanced Math;
9.5 Advanced Statistics;
Chapter 10: Financial Functions;
10.1 The World of Finance;
10.2 Financial Functions;
10.3 Depreciation;
10.4 Other Financial Functions;
Chapter 11: Manipulating Dates, Times, and Text;
11.1 Manipulating Text;
11.2 Manipulating Dates and Times;
11.3 Math with Dates and Times;
11.4 Date and Time Functions;
Chapter 12: Lookup, Reference, and Information Functions;
12.1 The Basic Lookup;
12.2 Advanced Lookups;
12.3 Information Functions;
12.4 Tutorial: Generating Invoices from a Product Catalog;
Chapter 13: Advanced Formula Writing and Troubleshooting;
13.1 Conditions in Formulas;
13.2 Descriptive Names for Cell References;
13.3 Variable Data Tables;
13.4 Controlling Recalculation;
13.5 Solving Formula Errors;
Part Three: Organizing Worksheets;
Chapter 14: Tables: List Management Made Easy;
14.1 The Basics of Tables;
14.2 Sorting and Filtering a Table;
14.3 Dealing with Duplicate Rows;
14.4 Performing Table Calculations;
Chapter 15: Grouping and Outlining Data;
15.1 Basic Data Grouping;
15.2 Grouping Timesavers;
Chapter 16: Templates;
16.1 Understanding Templates;
16.2 Creating a New Workbook from a Template;
16.3 Creating Templates;
Part Four: Charts and Graphics;
Chapter 17: Creating Basic Charts;
17.1 Charting 101;
17.2 Basic Tasks with Charts;
17.3 Practical Charting;
17.4 Chart Types;
Chapter 18: Formatting and Perfecting Charts;
18.1 Chart Styles and Layouts;
18.2 Adding Chart Elements;
18.3 Selecting Chart Elements;
18.4 Formatting Chart Elements;
18.5 Improving Your Charts;
18.6 Advanced Charting;
Chapter 19: Inserting Graphics;
19.1 Adding Pictures to a Worksheet;
19.2 Excel's Clip Art Library;
19.3 Drawing Shapes;
Part Five: Advanced Data Analysis;
Chapter 20: Visualizing Your Data;
20.1 Data Bars;
20.2 Color Scales;
20.3 Icon Sets;
20.4 Sparklines;
Chapter 21: Scenarios and Goal Seeking;
21.1 Using Scenarios;
21.2 Using Goal Seek;
21.3 Solver;
Chapter 22: Pivot Tables;
22.1 Summary Tables Revisited;
22.2 Building Pivot Tables;
22.3 Multi-Layered Pivot Tables;
22.4 Fine-Tuning Pivot Table Calculations;
22.5 Filtering a Pivot Table;
22.6 Pivot Charts;
Chapter 23: Analyzing Databases, XML, and Web Pages;
23.1 Excel and Databases;
23.2 Understanding XML;
23.3 Excel and XML;
23.4 Web Queries;
Part Six: Sharing Data with the Rest of the World;
Chapter 24: Protecting Your Workbooks;
24.1 Understanding Excel's Safeguards;
24.2 Data Validation;
24.3 Locked and Hidden Cells;
Chapter 25: Worksheet Collaboration;
25.1 Your Excel Identity;
25.2 Preparing Your Workbook;
25.3 Distributing a Document;
25.4 Adding Comments;
25.5 Tracking Changes;
25.6 Sharing Your Workbook;
Chapter 26: Using Excel on the Web;
26.1 Putting Your Files Online;
26.2 Using the Excel Web App;
Chapter 27: Exchanging Data with Other Programs;
27.1 Sharing Information in Windows;
27.2 Embedding and Linking Objects;
27.3 Transferring Data;
Part Seven: Programming Excel;
Chapter 28: Automating Tasks with Macros;
28.1 Macros 101;
28.2 The Macro Recorder;
28.3 Macro Security;
28.4 Creating Practical Macros;
Chapter 29: Programming Spreadsheets with VBA;
29.1 The Visual Basic Editor;
29.2 Understanding Macro Code;
29.3 Exploring the VBA Language;
Part Eight: Appendix;
Customizing the Ribbon;
Adding Your Favorites to the QAT;
Personalizing the Ribbon;
Read More Show Less

Customer Reviews

Average Rating 4.5
( 6 )
Rating Distribution

5 Star

(2)

4 Star

(4)

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 6 Customer Reviews
  • Posted September 13, 2012

    I bought this in the NookBook format ONLY because I have a dual

    I bought this in the NookBook format ONLY because I have a dual monitor set-up and the Nook for PC app installed. Otherwise, it is too difficult to switch back and forth between the Excel file on the screen and the NookBook. Being able to view a reference book on my full-size monitor is preferable to viewing it on a Nook.

    The book is logically outlined and presents the concepts in simple, easy-to-understand terms. The TOC is a bit difficult to navigate, as Nook for PC doesn't allow the TOC column to be widened. However, the search function certainly speeds up the process of finding the answer to a question quickly.

    I think the Missing Manual series is superior to the Dummies series. I prefer my reference manuals to get straight to the point and cut out the nonsense. I plan to buy other manuals in this series in the NookBook format.

    2 out of 2 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
  • Posted February 5, 2012

    Excellent book !!!

    Muy buen libro para aprender a usar Excel. Muy bien escrito

    2 out of 2 people found this review helpful.

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

    Posted March 16, 2014

    Good Reference Book

    I plan t o use mostly to look up things I don't know or don't understand. It seems very complete,

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

    Posted September 5, 2013

    I loved this book. I learned Excel in the 80's or 90's and have

    I loved this book. I learned Excel in the 80's or 90's and have been using Excel in the same way that I learned it back then. I purchased this book when we switched from Excel 2003 to 2010, just so that I could have a reference to help me do the things that I used to be able to do in the older version. At first, I cursed the ribbon, then just accepted it. This book showed me Excel features that I had been missing out on and new features added with 2010. Even though I use Excel every day at my job, I learned something new in every chapter.

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

    Posted May 16, 2012

    No text was provided for this review.

  • Anonymous

    Posted February 4, 2013

    No text was provided for this review.

Sort by: Showing all of 6 Customer Reviews

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