Excel Pivot Tables:
Getting Your Data to Talk

Excel Pivot Tables

Data is just data until it gives you information you can actually use.

Pivot tables are the answer for extracting usable information from all that data. When some Microsoft® Excel® users hear the term "pivot tables," they usually run for the hills, believing that skill set is out of reach. We'll shatter that myth by showing you step-by-step:

  • How to prepare your data for use in pivot tables
  • The fastest method to create and modify pivot tables customized for your specific needs
  • How to use report filter pages, calculated fields and other powerful pivot table features
  • Easy ways to chart and graph your data into pictures that are clear and easy to understand

With Excel Pivot Tables: Getting Your Data to Talk, our tech expert and Microsoft® Certified Trainer Melissa Esquibel will train you on:

  • Structuring data for use in pivot tables
  • Working with the new pivot table format
  • Modifying pivot tables
  • Creating pivot charts
  • Advanced Features: Report Filter Pages, Calculated Fields, working with GETPIVOT
Buy Now

In just 75 minutes, discover how Excel Pivot Tables can help you in your work:

  • Why pivot tables?
    • What are they used for?
    • What cumbersome procedures can they replace?
  • How do you know if your data will work?
    • What kind of data can be pivoted?
    • How can you clean up datasets, so you can pivot them?
    • How do you start one?
  • Crafting pivot table reports
    • Tables
    • Formatted tables
    • Interactivity: sorting and filtering
    • Filter pages
    • Totals and subtotals
  • Validating data: Great tips for double-checking your analysis
  • Automatic updating
    • What happens when the data changes?
    • Should you allow pivot tables to automatically update?
  • Pivot charts
    • Creating pivot charts in one keystroke
    • Modifying charts
    • The relationship between pivot charts and pivot tables
  • Advanced Features
    • GETPIVOTDATA
    • Calculated Fields

While this presentation is shown from Excel 2010, all information will apply to Excel 2013 and 2016 as well.

In about an hour, we'll take you from "why a pivot table" all the way to advanced features, and show you how to do it all in Excel with pivot tables. You'll have that data talking to you in no time with Excel Pivot Tables: Getting Your Data to Talk.

Sincerely,

signature

Mary Ellen Slayter, Editor
Administrative Professional Today

P.S. Your satisfaction is unconditionally guaranteed. If Excel Pivot Tables: Getting Your Data to Talk fails to meet your needs, we will refund every penny you paid – no hassles, no questions asked.

Buy Now

View a Free Clip of
Excel Pivot Tables: Getting Your Data to Talk

 

About Your Speaker:

Melissa EsquibelMelissa Esquibel is a Microsoft® Certified Trainer. She combines her 25+ years' experience in information technology with a background in training, technical writing and business risk analysis. Her goal is to help you understand the amazing workflow benefits of Microsoft® Excel®.

Buy Now