Accelerate Data Base Analysis with Excel's Pivot Tables

In this course you will learn how to get your data to tell you the whole story, Also Learn to create flexible data queries that refresh when the data does. Create, then Pivot your report to fit your needs. Filter your report with Excel's Slicer tool.

Miles Hutchinson
Instructor:
Miles Hutchinson
Date:
Monday, August 26, 2019
Time:
10:00 AM PDT | 01:00 PM EDT
Duration:
90 Minutes

More Trainings by this Expert   Product Id : 502702

Price Details
$150 Live
$290 Corporate Live
$190 Recorded
$390 Corporate Recorded
Combo Offers
Live + Recorded
$289 $340 Live + Recorded
Corporate (Live + Recorded)
$599 $680 Corporate
(Live + Recorded)
Price Detail Options
Overview:

Learn to create flexible data queries that refresh when the data does. Create, then Pivot your report to fit your needs. Filter your report with Excel's Slicer tool. Target production delays, efficiency gains, scrap rates, key demographics and so much more from your data. Learn how the gurus in your organization analyze their data so quickly and become one too!.

Why should you Attend: Stop staring at that database. Dive in and explore it with Pivot Tables. Identify the key trends in your data and be confident you have reached the right conclusions to support your recommendations. In this course you'll learn how to get your data to tell you the whole story.

Areas Covered in the Session:

  • Wrangle your database and prepare it for Pivoting
  • Setting up your Pivot Table from your data base
  • Navigating the Pivot Table Options Menu
  • Filtering and sorting your Pivot Table
  • Formatting Your Pivot Table
  • Reporting Options, including the Slicer Tool
  • Drilling down on your Pivot Table
  • Charting your Pivot Table Results

Who Will Benefit:
  • CFOs
  • Controllers
  • Compliance Managers
  • Compliance Officers
  • Accounting Managers
  • Information Reporting Officers
  • Tax Managers
  • Bank Managers
  • Risk Managers
  • Human Resource Managers
  • Internal Auditors


Speaker Profile
Miles Hutchinson is a CGMA and experienced businessman. He has been an auditor with PriceWaterhouseCoopers and the Chief Financial Officer of a $1 billion real estate development company. He is a highly sought after professional speaker and consultant who has presented over 1000 seminars and training sessions on a myriad of business and financial topics, such as financial analysis and modeling, accounting matters, strategic planning, and compliance with the Sarbanes-Oxley Act. His clients include, Abbott Labs, Citicorp, the FBI, GE, Pfizer, and the US Marine Corps.




Your Recently Viewed Webinars

Payment Methods

Contact Us

NetZealous LLC,
39658 Mission Boulevard, Fremont,
CA 94539, USA.

Information

  Refund Policy
  +1-800-447-9407
  Fax: 302 288 6884
  support@compliance4All.com