Take Data Base Analysis to a New Level
with Excel’s Pivot Tables

Tuesday, May 14, 2019
12:00 pm - 1:30 pm ET
90 minutes

Register for Live Webinar: $219

Register for Live Webinar Plus Recording Download: $329

Register for Live Webinar Plus CD (includes shipping and handling): $369

Special Feature: If you register for this webinar and cannot attend, you will be able to access a one-time instant replay without charge for up to 90 days after the date of the webinar.

Bonus for Each Registrant:  The webinar speaker will answer one written question that you may submit by email within one week after the webinar
 

Description

So, you found the data you need for your analysis, Now what?  How do you sort and sift it to mine key information and make the right decision?  Microsoft Excel Pivot Tables are designed to help you quickly summarize mountains of data, identify key trends, organize it into meaningful reports and filter the reports for specific users and needs.  Pivot tables also helps you with blazing fast drill downs on key events, activities and transactions.  In this course you’ll learn how to get your data to tell you the whole story.

Agenda

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

Faculty

Miles Hutchinson is a CGMA and experienced businessman with over 35 years in the field. He has been an auditor with PriceWaterhouseCoopers and the Chief Financial Officer of a one billion dollar real estate development company. Miles is a professional speaker and consultant who has presented over 2,000 seminars and training sessions on a myriad of business and financial topics, like financial analysis and modeling, accounting, strategic planning, and compliance with the Sarbanes-Oxley Act. 

He is recognized as an expert in payroll and sales & use tax as well as financial modeling & analysis, business strategy and communications.  He is the author of several useful accounting and tax tools available at www.soxpolicies.com and www.salestaxadvisors.com.  His clients include, Abbott Labs, Bank of America, Boston Scientific, Citicorp, Corning, the FBI, the FDA, the Federal Reserve, GE, Pfizer, Siemens, US Marine Corps, and the US Army.  Please visit his web sites to see how you can further benefit from his expertise.

Webinar Overview

  • 90 minutes (Travel Free) delivered over the Internet.
  • Unlimited listeners per connection - bring the entire department.
  • Q&A session with the expert.

This event will be presented live with a PowerPoint presentation to be viewed on your computer. You may listen to the audio of the webinar by telephone or through your computer. The PowerPoint slides will be provided shortly before the event. Once you register, you will receive an email which is your receipt and which includes your instructions for dialing in and logging on. You will also receive an email reminder 24 hours before the webinar.
 

Register for Live Webinar: $219

Register for Live Webinar Plus Recording Download: $329

Register for Live Webinar Plus CD (includes shipping and handling): $369

[[59:header_X-GreenArrow-MailClass:nwm_five_five]]