Excel 2013 All-in-One For Dummies

Book Description

The comprehensive reference, now completely up-to-date for Excel 2013!

As the standard for spreadsheet applications, Excel is used worldwide - but it's not always user-friendly. However, in the hands of veteran bestselling author Greg Harvey, Excel gets a whole lot easier to understand! This handy all-in-one guide covers all the essentials, the new features, how to analyze data with Excel, and much more. The featured minibooks address Excel basics, worksheet design, formulas and functions, worksheet collaboration and review, charts and graphics, data management, data analysis, and Excel and VBA.

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 Walks you through the new analysis tools that help make it easier to visualize data with the click of a mouse Details new ways to explore your data more intuitively and then analyze and display your results with a single click Whether you're an Excel newbie or a veteran user to wants to get familiar with the latest version, Excel 2013 All-in-One For Dummies has everything you need to know.

Table of contents

Book I: Excel Basics
Chapter 1: The Excel 2013 User Experience
Chapter 2: Customizing Excel 2013

Book II: Worksheet Design
Chapter 1: Building Worksheets
Chapter 2: Formatting Worksheets
Chapter 3: Editing and Proofing 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: Using Hyperlinks
Chapter 3: Sending Workbooks Out for Review
Chapter 4: Sharing Workbooks 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: Macros and VBA
Chapter 1: Building and Running Macros
Chapter 2: VBA Programming

About The Author

Greg Harvey

Greg Harvey is a veteran computer trainer, consultant, and the author of more than 50 books. He also owns and manages a multimedia publishing venture, Mind Over Media.