Advanced Excel Pivot Table Techniques
|Date / Time:
No one has to sell you on using pivot tables. You get it!
Now, you want to take your pivot tables to the next level. Whether your challenge is summarizing totals as percentages, analyzing with formulas, or introducing interactivity, this program will pack your toolbox with features that will help you turn your plain pivot table into a data-crunching, information-revealing machine. Understand the capabilities (and limitations) of this incredibly important tool.
Join us for Advanced Excel Pivot Table Techniques. Here are just a few of the features we'll cover:
- Calculated Fields and Items – When to use one and when to use the other
- Summarizing Totals beyond simple sums
- Pivoting Multiple Ranges
- Building user-friendly interactivity with Report Filters and Slicers
Microsoft® Certified Trainer Melissa Esquibel will share the secrets of crunching big data and generating actionable information in the form of reports and charts.
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!
Advanced Excel Pivot Table Techniques shows you how to do the hard work only once when it comes to report formatting and data updates. You'll even get a sneak peek at PowerPivot (2010-13) and PowerView (2013). The webinar is presented from Microsoft Office 2010, though we will have a peek at 2013. Some of the information presented will be applicable to Office 2007.
In about an hour, we'll 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 for Advanced Excel Pivot Table Techniques.
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|
All US States: 1.5
All Canadian Provinces: 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+
|Keywords For This Course:|
Excel, pivot tables, administrative, data, presentations
Reasonable Accommodation - Impairment
IRS Rules For Travel Pay
How To Write Clear, Concise, And Compliant Job Descriptions
Payroll Operations Academy
Garnishments, Child Support Orders and Other Levies
Internal Investigations Certificate Program
How To Drive HR Strategy
How To Get Your Managers To Cooperate With HR
Dealing with Difficult People
HR′s Guide To Medical Marijuana In The Workplace
Personnel Records: What To Keep, What To Toss
Creative - And Free - Ways To Use LinkedIn As A Recruiting Tool
Certificate Program For HR Generalists
IRS Rules For Work Visas
How to Supervise People Seminar
Certificate Program In FMLA &ADA Compliance