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:

Tackle Excel Pivot Tables

SKU:WT-1001708
Format: Webcast/Audio Conference/Interview/Podcast
Description:

Pivot Tables are interactive tables in Excel that allow the user to group and summarize large amounts of data in a concise, tabular format for easier reporting and analysis.

One advantage of Pivot Tables is that they allow you to extract significance from a large, detailed data, or to rearrange, hide, or display different category fields within the Pivot Table to provide alternate views of the data.

In this training session, Excel expert David Ringstrom gets you up to speed fast, but also helps you avoid frustrating quirks and nuances of using Pivot Tables. By the end of this webcast you'll be able to transform data into a pivot table-ready format, and then instantly create reports by simply dragging and dropping fields with your mouse.

David will teach from Excel 2010, but for this presentation he provides handouts specific to Excel 2013, Excel 2010, Excel 2007, and Excel 2003. His detailed handouts with numbered steps ensure you'll be able to easily recreate what you see him demonstrate onscreen.

Covered Topics:

By attending this training session, you will learn how to:

  • Transform ugly data into usable reports in just a few simple steps
  • Quickly whip unwieldy data into the format required for pivot table analysis
  • Disable the GETPIVOTDATA function if you don't need it for your analysis
  • Learn the basics of pivot table creation
  • Avoid frustration by understanding the nuances of pivot table formatting
  • Dig deeper into the numbers by using the Report Filter command to create break-out tables
  • Drill down into numbers with a double-click-or prevent users from being able to do so
  • Quickly summarize complex data sets with Excel’s Pivot Chart feature
  • Simplify repetitive tasks by creating your own keyboard shortcuts
  • Master the nuances of keeping your pivot table data correct and accurate
  • Summarize information from Access databases and other sources


Level:
Intermediate

Format:
Group: Internet-based

Instructional Method:
Live webcast

NASBA Field of Study:
Specialized Knowledge and Applications (2 Hours)

Program Prerequisites:
None

Advance Preparation:
None

Licenses / Designations / Educational Credits:PHR / SPHR Re-Certification Credits
All US States: 1.5

SHRM Re-Certification Credits
All US States: 1.5
About The Provider: The Industry Calendar creates and sells webinars, audio conferences, and seminars for busy business professionals.

For over ten years we've done the work of listing the important, don't-miss events in one convenient location so you can quickly and easily learn about key training topics that keep you up-to-date on trends and best practices, all while helping to keep you in compliance with the various rules and regulations affecting your organization.
Price: $239.00
More Info: Contact Us For More Information

See Other Courses From This Provider
Share This: Share on Facebook


Share on Twitter


Share on Google+


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

Certificate Program For HR Generalists
Certificate Program For HR Generalists

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

Internal Investigations Certificate Program
Internal Investigations Certificate Program

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

Compliance Tips For Gifts, Awards, &Other Fringe Benefits
Compliance Tips For Gifts, Awards, &Other Fringe Benefits

Multi-State Payroll Tax Compliance
Multi-State Payroll Tax Compliance

Disability Discrimination And The Interactive Process
Disability Discrimination And The Interactive Process

Time Management for HR Professionals
Time Management for HR Professionals

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

Dealing with Difficult People
Dealing with Difficult People

Integrating FMLA, ADA, COBRA, And Workers′ Compensation Training &Certification Program
Integrating FMLA, ADA, COBRA, And Workers′ Compensation Training &Certification Program

Certificate In Essentials Of Human Resource Management Seminar
Certificate In Essentials Of Human Resource Management Seminar

Payroll Requirements For Terminated Employees
Payroll Requirements For Terminated Employees

HR’s Role In Team Building
HR’s Role In Team Building

Evaluating Your Paid Time-Off Strategy:  PTO Or Traditional Vacation &Sick Pay?
Evaluating Your Paid Time-Off Strategy: PTO Or Traditional Vacation &Sick Pay?

Update For The New Form W-4
Update For The New Form W-4

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