Excel 2010 All-in-One For Dummies - Softcover

Harvey, Greg

Softcover

ISBN 10: 0470489596 ISBN 13: 9780470489598

Publisher: For Dummies, 2010

Synopsis

A comprehensive, up-to-date, user-friendly guide to Excel 2010

Excel is the standard for spreadsheet applications and is used worldwide, but it's not always user-friendly. That makes it a perfect For Dummies topic, and this handy all-in-one guide covers all the essentials, the new features, how to analyze data with Excel, and much more.

Eight minibooks address Excel basics, worksheet design, formulas and functions, worksheet collaboration and review, charts and graphics, data management, data analysis, and Excel and VBA.

• Excel is the leading spreadsheet/data analysis software and is used throughout the world; the newest revision includes upgraded tools and a redesigned interface
• For Dummies books are the bestselling guides to Excel, with more than three million copies sold
• Excel 2010 All-in-One For Dummies covers the changes in the newest version as well as familiar tasks, such as creating and editing worksheets, setting up formulas, and performing statistical functions
• Eight self-contained minibooks cover the basics, worksheet design, formulas and functions, worksheet collaboration, presenting data in charts and graphics, data management, data analysis, and creating macros with VBA.

Newcomers to Excel as well as veterans who just want to learn the latest version will find Excel 2010 All-in-One For Dummies has everything they need to know.

About this title

Review:

More to Explore: See More Excel 2010 Resources

Title Excel 2010 For Dummies Excel 2010 All-in-One For Dummies Excel 2010 eLearning Kit For Dummies Excel 2010 Basics and Advanced For Dummies eLearning Course Access Code Card   Guide Type Tutorial Comprehensive Tutorial Training Guide and Interactive Course Web-Based Training Software   Audience Level Beginner Intermediate to Advanced Beginner to Intermediate Beginner to Intermediate   Pages 408 792 368 N/A   List Price $24.99 $34.99 $39.99 $39.99   Author(s) Greg Harvey Greg Harvey Faithe Wempen Faithe Wempen   Publication Date April 2010 May 2010 January 2012 October 2012   Imprint For Dummies For Dummies For Dummies For Dummies   ISBN 0470489537 0470489596 111811079X 1118446321   Kindle book B005ZIPQNI B005ZIPQ60 B006ISI334 N/A   Brief Description Top Excel 2010 title on the market. Goes over the basics of Excel and helps with the need-to-know Excel skills. Comprehensive, up-to-date, user-friendly guide to Excel 2010. Includes full-color tutorial book along with fully interactive, eLearning course on CD-ROM. Code for 6-month access to online eLearning course with interactive lessons including audio and video.

From the Back Cover:

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

About this edition

• Publisher: For Dummies
• Publication date: 2010
• ISBN 10: 0470489596
• ISBN 13: 9780470489598
• Binding: Paperback
• Edition number: 1
• Number of pages: 800