Excel^® 2010 All-in-One For Dummies^®

by Greg Harvey (Mind Over Media, Point Reyes Station, California)

• ISBN13: 9780470768297
• ISBN10: 0470768290
• Format: eBook
• Copyright: 2010-04-01
• Publisher: For Dummies

Summary

A comprehensive, up-to-date, user-friendly guide to Excel 2010Excel 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.

Table of Contents

Introduction

Excel Basics

The Excel 2010 User Experience

Getting Help, Tips, and Updates

Customizing Excel

Worksheet Design

Building Worksheets

Formatting Worksheets

Editing and Proofi ng Worksheets

Managing Worksheets

Printing Worksheets

Formulas and Functions

Building Basic Formulas

Logical Functions and Error Trapping

Date and Time Formulas

Financial Formulas

Math and Statistical Formulas

Lookup, Information, and Text Formulas

Worksheet Collaboration and Review

Protecting Workbooks and Worksheet Data

Linking Workbooks with Hyperlinks

Sending Workbooks Out for Review

Sharing Worksheets and Worksheet Data

Charts and Graphics

Charting Worksheet Data

Adding Graphic Objects

Data Management

Building and Maintaining Data Lists

Filtering and Querying a Data List

Data Analysis

Performing What-If Scenarios

Generating Pivot Tables

Excel and VBA

Building and Running Macros

VBA Programming

Appendix: Using XML File Formats

Index

Table of Contents provided by Publisher. All Rights Reserved.