Webinar

One of the most powerful features in Excel!

Webinar Header

Excel Pivot Tables: Getting Your Data to Talk

Delivering all the business data everybody needs is just a lot of bits and bytes … until it gives you information you can actually use.

Pivot tables are the answer for extracting usable information from all that data. When 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, simple ways to chart and graph your data into pictures that are clear and easy to understand.
Register now

Join us September 10 for 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
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

You'll also be able to ask your pivot table questions directly to Melissa Esquibel, Microsoft® Certified Trainer and editor of Office Technology Today. And there is NO LIMIT to the number of colleagues who can join in at one site!

Register now

While this presentation will be shown from Excel 2010, nearly all information will be applicable to Excel 2007. (Some concepts of Pivot Tables will be transferrable to Excel 2003, but the screens, tools and navigation are different.)

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. Join us September 10 for Excel Pivot Tables: Getting Your Data to Talk.

Sincerely,

Mary Ellen Slayter
Editor, Administrative Professional Today

P.S. Registration Bonus: Sign up for Excel Pivot Tables: Getting Your Data to Talk and we’ll send you Microsoft  Excel: Time-Savers for Every Skill Level Executive Summary. Avoid the pitfalls of Excel and get the most out of this program. No matter what your skill level is, Excel can save you time and increase your productivity. This Executive Summary is a combination of not one, but TWO training events led by Microsoft® Certified Trainer Melissa Esquibel.

P.P.S. Second FREE Registration Bonus. You'll also receive a month of free access to the Office Technology Today Answer Center. This business software training website provides helpful solutions to your Microsoft® Office® challenges with training videos... informative Executive Summaries on specific Office programs... a "Help Desk" for your office tech questions... and much more. So that you continue to benefit from the Answer Center, we'll continue your members-only access for just $89 per quarter, unless you tell us "no, thanks" — your choice.

P.P.P.S. Your satisfaction is unconditionally guaranteed. Your satisfaction is unconditionally guaranteed. If you decide that Excel Pivot Tables: Getting Your Data to Talk isn’t all we’ve promised and more, we will refund 100% of your tuition. No questions asked—and your course materials and registration bonus are yours to keep.

Register now






Facebook
Google Plus
Linked In
Twitter

Date: Tuesday, September 10
Time: 1 to 2:15 p.m. ET

Registration Bonus:

Sign up for Excel Pivot Tables: Getting Your Data to Talk and we’ll send you Microsoft Excel: Time-Savers for Every Skill Level Executive Summary. Avoid the pitfalls of Excel and get the most out of this program. No matter what your skill level is, Excel can save you time and increase your productivity. This Executive Summary is a combination of not one, but TWO training events led by Microsoft® Certified Trainer Melissa Esquibel.

Second FREE Bonus Gift:


You'll also receive a month of free access to the Office Technology Today Answer Center. This business software training website provides helpful solutions to your Microsoft® Office® challenges with training videos... informative Executive Summaries on specific Office programs... a "Help Desk" for your office tech questions... and much more. So that you continue to benefit from the Answer Center, we'll continue your members-only access for just $89 per quarter, unless you tell us "no, thanks" — your choice.

About Your Speaker:

Melissa 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®.

Who Should Attend:

  • Administrative professionals
  • HR professionals
  • Supervisors and managers
  • Executives
  • Office managers
  • Business owners

Since this is a webinar, you and your entire staff can attend in the comfort of your office or conference room for one low price! You may include as many people as you wish while listening on a single phone line.

Pricing Options:

Access Every Business Management Daily webinar for one low price!

Webinar: $197
Video Recording: $229
Webinar & Video Recording: $329

Unlimited number of participants at one site. Contact us for multi-site discounts.

Can't attend the webinar? We'll reserve a Video Recording in your name.

How do webinars work?

Your no-risk guarantee...

 

This event is sponsored by:
Business Management Daily
7600A Leesburg Pike, West Building, Suite 300 • Falls Church, VA 22043-2004
(800) 543-2055 • Customer@BusinessManagementDaily.com