Excel 2010 All-in-One For Dummies Paperback - 2010 - 1st Edition

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