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 Pivot Tables: Getting Your Data To Talk

SKU:WC-1012731
Date / Time: Recorded
Format: Webinar
Order:Qty:
Description:

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. We'll shatter that myth by showing you step-by-step:

  • How to prepare your data for use in pivot tables
  • The fastest method to create and modify pivot tables 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.

Join us for Excel Pivot Tables: Getting Your Data to Talk. Our tech expert and Microsoft® Certified Trainer Melissa Esquibel will train you on:

  • Structuring data for use in pivot tables
  • Working with the new pivot table format
  • Modifying pivot tables
  • Creating pivot charts
  • Advanced Features: Report Filter Pages, Calculated Fields, working with GETPIVOT

In just 75 minutes, discover how Excel Pivot Tables can help you in your work:

  • What are they used for?
  • What cumbersome procedures can they replace?
  • How do you know if your data will work?
  • What kind of data can be pivoted?
  • How can you clean up datasets, so you can pivot them?
  • How do you start one?
  • Crafting pivot table reports
  • Tables
  • Formatted tables
  • Interactivity: sorting and filtering
  • Filter pages
  • Totals and subtotals
  • Validating data: Great tips for double-checking your analysis
  • Automatic updating
  • What happens when the data changes?
  • Should you allow pivot tables to automatically update?
  • Pivot charts
  • Creating pivot charts in one keystroke
  • Modifying charts
  • The relationship between pivot charts and pivot tables
  • GETPIVOTDATA
  • Calculated Fields

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!

While this presentation will be shown from Excel 2010, nearly all information will be applicable to Excel 2007. (Some concepts of Pivot Tables will be transferrable to Excel 2003, but the screens, tools and navigation are different.)

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. Join us for Excel Pivot Tables: Getting Your Data to Talk.

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.

The live 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.
More Info: Contact Us For More Information
Order:Qty:
Share This: Share on Facebook


Share on Twitter


Share on Google+


Keywords For This Course:

Excel, accounting, data, presentations

Reasonable Accommodation - Impairment
Reasonable Accommodation - Impairment

Garnishments, Child Support Orders and Other Levies
Garnishments, Child Support Orders and Other Levies

Internal Investigations Certificate Program
Internal Investigations Certificate Program

How To Write Clear, Concise, And Compliant Job Descriptions
How To Write Clear, Concise, And Compliant Job Descriptions

How To Drive HR Strategy
How To Drive HR Strategy

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

Dealing with Difficult People
Dealing with Difficult People

HR′s Guide To Medical Marijuana In The Workplace
HR′s Guide To Medical Marijuana In The Workplace

Personnel Records: What To Keep, What To Toss
Personnel Records: What To Keep, What To Toss

Creative - And Free - Ways To Use LinkedIn As A Recruiting Tool
Creative - And Free - Ways To Use LinkedIn As A Recruiting Tool

Certificate Program For HR Generalists
Certificate Program For HR Generalists

Basics Of OSHA Recordkeeping
Basics Of OSHA Recordkeeping

IRS Rules For Travel Pay
IRS Rules For Travel Pay

IRS Rules For Work Visas
IRS Rules For Work Visas

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

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 2016 | Web Site Development by OTAU
Facebook