0%

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

  1. Cover
  2. Title Page
  3. Table of Contents
  4. Introduction
  5. Book I: Excel Basics
    1. Chapter 1: The Excel 2013 User Experience
    2. Chapter 2: Customizing Excel 2013
  6. Book II: Worksheet Design
    1. Chapter 1: Building Worksheets
    2. Chapter 2: Formatting Worksheets
    3. Chapter 3: Editing and Proofing Worksheets
    4. Chapter 4: Managing Worksheets
    5. Chapter 5: Printing Worksheets
  7. Book III: Formulas and Functions
    1. Chapter 1: Building Basic Formulas
    2. Chapter 2: Logical Functions and Error Trapping
    3. Chapter 3: Date and Time Formulas
    4. Chapter 4: Financial Formulas
    5. Chapter 5: Math and Statistical Formulas
    6. Chapter 6: Lookup, Information, and Text Formulas
  8. Book IV: Worksheet Collaboration and Review
    1. Chapter 1: Protecting Workbooks and Worksheet Data
    2. Chapter 2: Using Hyperlinks
    3. Chapter 3: Sending Workbooks Out for Review
    4. Chapter 4: Sharing Workbooks and Worksheet Data
  9. Book V: Charts and Graphics
    1. Chapter 1: Charting Worksheet Data
    2. Chapter 2: Adding Graphic Objects
  10. Book VI: Data Management
    1. Chapter 1: Building and Maintaining Data Lists
    2. Chapter 2: Filtering and Querying a Data List
  11. Book VII: Data Analysis
    1. Chapter 1: Performing What-If Scenarios
    2. Chapter 2: Generating Pivot Tables
  12. Book VIII: Macros and VBA
    1. Chapter 1: Building and Running Macros
    2. Chapter 2: VBA Programming
  13. Cheat Sheet
3.15.151.21