Excel 2010 All-in-One For Dummies
By Greg Harvey
Publisher: Wiley / For Dummies
Final Release Date: April 2010
Pages: 792

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® 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
Product Details
Recommended for You
Customer Reviews
 
Buy 2 Get 1 Free Free Shipping Guarantee
Buying Options
Immediate Access - Go Digital what's this?
Ebook:  $34.99
Formats:  ePub, Mobi, PDF