Excel Pivot Tables: Getting Your Data To Talk
|Date / Time:
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:
Join us for the newest webinar in our Office Technology Series, Excel Pivot Tables: Getting Your Data to Talk. Our tech expert and Microsoft® Certified Trainer Melissa Esquibel will teach you:
- 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
Structuring data for use in pivot tablesYou'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!
- Modifying pivot tables
- Creating pivot charts
- Advanced Features: Report Filter Pages, Calculated Fields, working with GETPIVOT
- Why pivot tables?
- How do you know if your data will work?
- Crafting pivot table reports
- Validating data: Great tips for double-checking your analysis
- Automatic updating
- Pivot charts
- Advanced Features
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.
Cannot Attend The Live Presentation?
This presentation is also available in a recorded format, in CD version, as shown in the pricing options below.
|About Webcasts / Audio Conferences / Podcasts:|
Webcasts, audio conferences, and podcasts are presentations that you
attend via the Internet, phone, or mobile device at a specified date and time for "live" versions, or at your convenience for "recorded" and "On-Demand" versions.
versions are interactive, meaning that participants can ask questions in real time, plus are a very cost-effective form of training because 1) you receive fast, convenient learning without
any out-of-office time; 2) you can invite as many colleagues as you'd like to listen in on a single phone line; 3) you incur no travel expenses; and 4) you and your colleagues are back
at work immediately after the session ends!
And though with recorded versions you do lose the ability to ask questions, you gain the ability to hear the presentation numerous
times and to share it with others in your office.
Handout materials and the phone number for live presentations are made available to you prior to the event via email from the
presenter and from the "MyAccount" link on the menu bar. Copies of the presentations are included with recorded versions.
|Licenses / Designations / Educational Credits:||PACE|
New Hampshire: 1.5
New Jersey: 1.5
New Mexico: 1.5
New York: 1.5
North Carolina: 1.5
North Dakota: 1.5
Rhode Island: 1.5
South Carolina: 1.5
South Dakota: 1.5
West Virginia: 1.5
British Columbia: 1.5
New Brunswick: 1.5
Newfoundland and Labrador: 1.5
Northwest Territories: 1.5
Nova Scotia: 1.5
Prince Edward Island: 1.5
Puerto Rico: 1.5
|About The Provider:
||The HR Specialist family of products helps HR professionals quickly resolve their daily challenges. From state-specific employment law to compensation and benefits, our experts give you the HR advice you need to know.
Whether you're new to HR or an experienced pro - a department of one or 10 - you can trust the practical, plain-English advice from HR Specialist. We'll save you time and headaches by focusing on what you need to know, when you need to know it. That makes you the HR expert your company can rely on and gets you the recognition you deserve.
||Contact Us For More Information
||Share on Facebook
Share on Twitter
Share on Google+
Workplace Investigations 101: The Basics For Conducting Workplace Investigations
Employee Handbooks: 2017 Issues
How To Change The Perception Of The HR Department
How To Communicate Assertively To Exude Confidence And Competence
Year End Legislative &Tax Changes In Payroll
Payroll Records: What To Keep, What To Toss
PTO Plan Or Traditional Vacation And Sick Time? The Pros and Cons Of A Paid-Time-Off Plan
Motivate Or Terminate
Certificate Program For HR Generalists
Agile Basics For HR
Internal Investigations Certificate Program
Certificate Program In FMLA &ADA Compliance
The Essentials Of HR Law
FMLA Training &Certification Program
Certified Payroll Manager
Fundamentals Of Form W-2 &Form W-4 Processing