HRTrainingCenter.com provides Human Resource training on FMLA, COBRA, HIPAA, HRAs (Health Reimbursement Accounts), HSAs (Health Savings Accounts), FLSA, Payroll, Cafeteria Plans, and more through seminars, online training, webcasts, webinars, and audio conferences. Best sellers include FMLA seminars, COBRA seminars, online payroll training, retirement plan training, and HIPAA training.
Course/Product Description
Title:

Advanced Excel Pivot Table Techniques

SKU:WT-1001703
Format: Webinar
Description:

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.

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.
Price: $197.00
More Info: Contact Us For More Information
Share This: Share on Facebook


Share on Twitter


Share on Google+


Keywords For This Course:

excel, pivot tables, spreadsheets, presentations, accounting, Microsoft Office

Currently Scheduled Dates For This Webcast
There currently are no scheduled dates for this webcast. Please click here to search for another course.

Serious Complaint or Employee Drama?
Serious Complaint or Employee Drama?

Successful Strategies For Running An ′HR Department Of One′
Successful Strategies For Running An ′HR Department Of One′

How To Conduct A Reasonable Accommodation Discussion
How To Conduct A Reasonable Accommodation Discussion

Internal Investigations Certificate Program
Internal Investigations Certificate Program

How To Conduct Employee Relations Investigations
How To Conduct Employee Relations Investigations

Preventing Workplace Harassment and Bullying - What Every HR Professional Should Know
Preventing Workplace Harassment and Bullying - What Every HR Professional Should Know

How Workers′ Compensation Works (Comprehensive 11-Module Course)
How Workers′ Compensation Works (Comprehensive 11-Module Course)

Certificate Program For HR Generalists
Certificate Program For HR Generalists

Return-To-Work Strategies
Return-To-Work Strategies

How To Get Your Managers To Cooperate With HR
How To Get Your Managers To Cooperate With HR

Tips For Tracking, Monitoring, And Managing Your Workers′ Comp Claims
Tips For Tracking, Monitoring, And Managing Your Workers′ Comp Claims

Certificate Program In FMLA &ADA Compliance
Certificate Program In FMLA &ADA Compliance

I-9 Administrator Training - Top 10 Mistakes To Avoid In Completing, Storing, And Destroying Form I-9
I-9 Administrator Training - Top 10 Mistakes To Avoid In Completing, Storing, And Destroying Form I-9

H-1B Visa Training
H-1B Visa Training

Emergency Response: What To Do, What To Say, And How To Plan For It
Emergency Response: What To Do, What To Say, And How To Plan For It

Opioid Crisis In The Workplace
Opioid Crisis In The Workplace

Google+HRTrainingCenter.com. 5755 North Point Parkway, Suite 228 | Alpharetta, GA 30022 | 770-410-1219 | support@HRTrainingCenter.com
Copyright HRTrainingCenter.com 2017 | Web Site Development by OTAU
Facebook