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:

Excel Training: How To Use Pivot Tables

SKU:WT-1001461
Format: Webinar
Description:

Excel Training: How To Use Pivot Tables

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 quickly convert lists of data into useful reports and charts. Another advantage allows you to extract significance from a huge data dumps, or to rearrange, hide, or display different category fields within the Pivot Table to provide alternate views of the data.

Unfortunately, Pivot Tables are one of the most underutilized Excel features, primarily because users often fear there’s a long learning curve. However, by the end of this webcast, you’ll be able to transform data into a pivot table–ready format and instantly create reports by simply dragging and dropping fields with your mouse.

Learning Objectives

  • Identify how to transform unwieldly data into usable reports in just a few simple steps
  • Compile unwieldy data into the format required for pivot table analysis quickly and easily
  • Disable the GETPIVOTDATA function if it’s not needed for your analysis
  • Discover how pivot tables differ from worksheet formulas and learn the importance of the Refresh command
  • Discover the Recommended Pivot Tables feature
  • Identify the requirements of ideal data sets to be analyzed within your pivot tables
  • Incorporate calculations within or alongside pivot tables
  • Learn how to expand and collapse pivot table elements, thereby avoiding information overload
  • Prevent frustration by understanding the nuances of pivot table formatting
  • Use a simple keyboard shortcut to post the same formula to multiple cells at once
  • Use the Report Filter command to create breakout tables and dig deeper into the numbers
  • Apply what you’ve learned to easily implement Excel’s PivotTable feature
  • Define how to use the Slicers feature introduced in Excel 2010 as well as Recommended Pivot Tables in Excel 2013
About Your Speaker:

David Ringstrom, CPA, is the Tech Editor-at-Large for AccountingWEB and Going Concern. David speaks at conferences nationally and presents dozens of webinars annually on Excel and other topics. He offers Excel training and consulting services nationwide, and has written numerous articles on spreadsheets.


Other Excel Topics

This course is just one of several Excel training courses we offer as part of our Excel training line. Go to www.CPATrainingCenter.com/Excel-Training-For-Accountants.asp to see the full list of Excel training courses.

Licenses / Designations / Educational Credits:PHR / SPHR 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.

We've done the work of listing the important, don't-miss events in one convenient location so you can quickly and easily view and register for upcoming events. Simply click on a course title or search by specific industry to get started!
Price: $239.00
More Info: Contact Us For More Information
Share This: Share on Facebook


Share on Twitter


Share on Google+


Currently Scheduled Dates For This Webcast
Course TitleDatePrice
How To Use Excel Pivot TablesCD/On-Demand$239.00

Internal Investigations Certificate Program
Internal Investigations Certificate Program

Service Animals In The Workplace: What You Need To Know
Service Animals In The Workplace: What You Need To Know

What To Do When Applicants Or Employees Have A Criminal History
What To Do When Applicants Or Employees Have A Criminal History

Workers′ Comp 101: The Whats, Whens, And Whys
Workers′ Comp 101: The Whats, Whens, And Whys

Certificate Program For HR Generalists
Certificate Program For HR Generalists

How To Coach Up Or Counsel Out Problem Employees
How To Coach Up Or Counsel Out Problem Employees

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

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

How To Avoid Wrongful Termination Claims
How To Avoid Wrongful Termination Claims

Form I-9: Understanding The Anti-Discrimination Provisions Of The Law
Form I-9: Understanding The Anti-Discrimination Provisions Of The Law

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

IRS Rules For Inpat &Expat Payroll
IRS Rules For Inpat &Expat Payroll

Dealing with Difficult People
Dealing with Difficult People

How To Communicate With Tact And Professionalism
How To Communicate With Tact And Professionalism

Dress Code Policy Do′s and Don′ts
Dress Code Policy Do′s and Don′ts

How to Supervise People Seminar
How to Supervise People Seminar

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