View a Free 2-Minute Excel Pivot Tables Clip from Melissa Esquibel:
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. Let us shatter that myth by showing you step-by-step:
How to prepare your data for use in a pivot table
The fastest method to create and modify a pivot table 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.
While this presentation is shown from Excel 2007, all information will be applicable to Excel 2010 as well. (Some concepts of pivot tables will be transferrable to 2003, but the screens, tools and navigation are different.)
With this informative video from our Office Technology Series, Excel Pivot Tables: Getting Your Data to Talk, our tech expert and Microsoft® Certified Trainer Melissa Esquibel will teach you:
Structuring data for use in pivot tables
Working with the Office 2007 pivot table format
Modifying pivot tables
Creating pivot charts
Advanced features: report filter pages, calculated fields, working with GETPIVOT
In just 75 minutes, learn 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?
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
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, Alice Bumgarner Editor, Administrative Professional Today
P.S. Your satisfaction is unconditionally guaranteed. If Excel Pivot Tables fails to meet your needs, we will refund 100% of your purchase price – no hassles, no questions asked.
About the Speaker:
Melissa Esquibel is a Microsoft® Certified Trainer. She combines her 25+ years of 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 Watch:
Administrative professionals
HR professionals
Supervisors and managers
Business owners
This recording is sponsored by: Business Management Daily 7600A Leesburg Pike, West Building, Suite 300 • Falls Church, VA 22043-2004 (800) 543-2055 • Customer@BusinessManagementDaily.com
Melissa Esquibel is a Microsoft
