Excel 2010 All-in-One For Dummies

Excel 2010 All-in-One For Dummies

3.63 (79 ratings by Goodreads)
By (author) 

Free delivery worldwide

Available. Dispatched from the UK in 2 business days
When will my order arrive?


A comprehensive, up-to-date, user-friendly guide to Excel2010 Excel is the standard for spreadsheet applications and is usedworldwide, but it's not always user-friendly. That makes it aperfect For Dummies topic, and this handy all-in-one guidecovers all the essentials, the new features, how to analyze datawith Excel, and much more. Eight minibooks address Excel basics, worksheet design, formulasand functions, worksheet collaboration and review, charts andgraphics, data management, data analysis, and Excel and VBA.
* Excel is the leading spreadsheet/data analysis software and isused throughout the world; the newest revision includes upgradedtools and a redesigned interface * For Dummies books are the bestselling guides to Excel, withmore than three million copies sold * Excel 2010 All-in-One For Dummies covers the changes in thenewest version as well as familiar tasks, such as creating andediting worksheets, setting up formulas, and performing statisticalfunctions * Eight self-contained minibooks cover the basics, worksheetdesign, formulas and functions, worksheet collaboration, presentingdata in charts and graphics, data management, data analysis, andcreating macros with VBA. Newcomers to Excel as well as veterans who just want to learnthe latest version will find Excel 2010 All-in-One ForDummies has everything they need to know.
show more

Product details

  • Paperback | 800 pages
  • 187.96 x 231.14 x 33.02mm | 1,156.65g
  • John Wiley & Sons Ltd
  • Chichester, United Kingdom
  • English
  • 1. Auflage
  • 0470489596
  • 9780470489598
  • 47,891

Back cover copy

8 BOOKS IN 1 Excel Basics Worksheet Design Formulas and Functions Worksheet Collaboration and Review Charts and Graphics Data Management Data Analysis Excel and VBA

Here's everything you need to know about using Excel -- in one handy package!

Excel is such a powerhouse, it takes eight self-contained minibooks to cover all its features! Open this All-in-One and find just what you need to know, from how to use the Ribbon interface and Backstage View and how to set up your first spreadsheet to collaborating on a worksheet, presenting results with cool charts and graphs, and understanding formulas and functions. Welcome to 2010 -- explore the new user experience, learn where to get help, and customize your Excel Workin' with worksheets -- learn to build, format, edit, proof, manage, and print them Formula for success -- find out what formulas and functions do and how to use them Share and collaborate -- discover how to send workbooks out for review and incorporate input from multiple users Results that are pretty -- find out which type of chart shows off your data to best advantage Keeping data in line -- learn to maintain, sort, and filter data lists using Excel Analyze this -- use Excel's computational ability to predict possible outcomes Making macros -- use Visual Basic(R) for Applications, record macros, edit VBA code, and make Excel do your bidding

Open the book and find: How to navigate the Ribbon and Backstage View Shortcuts for switching from older versions Tricks for eliminating Text to Speech errors All about functions and how they work in formulas How to secure data and still enable user edits How to use line charts, pie charts, and scatter charts Tips for creating macros and custom functions How to perform what-if analysis
show more

Table of contents

Introduction. Book I: Excel Basics. Chapter 1: The Excel 2010 User Experience. Chapter 2: Getting Help, Tips, and Updates. Chapter 3: Customizing Excel. Book II: Worksheet Design. Chapter 1: Building Worksheets. Chapter 2: Formatting Worksheets. Chapter 3: Editing and Proofi ng Worksheets. Chapter 4: Managing Worksheets. Chapter 5: Printing Worksheets. Book III: Formulas and Functions. Chapter 1: Building Basic Formulas. Chapter 2: Logical Functions and Error Trapping. Chapter 3: Date and Time Formulas. Chapter 4: Financial Formulas. Chapter 5: Math and Statistical Formulas. Chapter 6: Lookup, Information, and Text Formulas. Book IV: Worksheet Collaboration and Review. Chapter 1: Protecting Workbooks and Worksheet Data. Chapter 2: Linking Workbooks with Hyperlinks. Chapter 3: Sending Workbooks Out for Review. Chapter 4: Sharing Worksheets and Worksheet Data. Book V: Charts and Graphics. Chapter 1: Charting Worksheet Data. Chapter 2: Adding Graphic Objects. Book VI: Data Management. Chapter 1: Building and Maintaining Data Lists. Chapter 2: Filtering and Querying a Data List. Book VII: Data Analysis. Chapter 1: Performing What-If Scenarios. Chapter 2: Generating Pivot Tables. Book VIII: Excel and VBA. Chapter 1: Building and Running Macros. Chapter 2: VBA Programming. Appendix: Using XML File Formats. Index.
show more

About Greg Harvey

Greg Harvey, PhD, is president of Mind Over Media, Inc. He is the author of all editions of Excel For Dummies, Excel All-in-One For Dummies, Excel Workbook For Dummies, and Windows For Dummies Quick Reference. He's also an experienced educator.
show more

Rating details

79 ratings
3.63 out of 5 stars
5 22% (17)
4 41% (32)
3 24% (19)
2 8% (6)
1 6% (5)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X