ComplianceOnline

MS Excel: Advanced Pivot Tables for Superior Data Analytics

Instructor: Joe Weil
Product ID: 705379
  • 20
  • October 2017
    Friday
  • 10:00 AM PDT | 01:00 PM EDT
    Duration: 90 Min

Live Online Training
October 20, Friday 10:00 AM PDT | 01:00 PM EDT | Duration: 90 Min

$199.00
One Dial-in One Attendee
$499.00
Group-Max. 10 Attendees/Location
(For Multiple Locations Contact Customer Care)
Super Deal - Get CD free!

recorded version

$229.00
1x Person - Unlimited viewing for 6 Months
(For multiple locations contact Customer Care)
Recorded Link and Ref. material will be available in My CO Section 48 hrs after completion of Live training

Training CD / USB Drive

$399.00
One CD/USB is for usage in one location only.
(For multiple locations contact Customer Care)
CD/USB and Ref. material will be shipped within 15 business days after completion of Live training

Combo Offers

Live + Recorded Version

$349.00

Live + Training CD/USB

$449.00

Customer Care

Fax: +1-650-565-8542

Email: customercare@complianceonline.com

Read Frequently Asked Questions

Pivot Tables are one of the most powerful tools in Excel’s arsenal of data analytics. With just a few clicks, and no complicated formulas or macros, you can quickly and easily build incredibly informative reports, charts and dashboards. In this webinar, you’ll learn Pivot Table techniques that will instantly filter, summarize and analyze huge amounts of raw data. You will learn to use advanced Pivot Table techniques to rapidly produce critical information that will highlight the algorithms and trends buried in reams of data.

Why Should You Attend:

Learn to push the boundaries of Pivot Table analytic techniques in this highly informative webinar. The webinar instructor will clearly explain and illustrate over forty advanced pivot table techniques that unlock the keys to rapid, insightful superior data analytics.

For the trained, knowledgeable user, Pivot Tables allow quick exploration and analysis of raw data. This advanced analysis reveals meaningful insight and rends otherwise lost in tens of thousands of rows of data.

Attendees will learn:

  • How to create reports that instantly display running totals, percent of totals, month-on-month differences, and much more.
  • Advanced Pivot Table sorting, filtering, and calculation techniques.
  • How to integrate conditional formatting with Pivot Tables to automatically highlight critical information.
  • To rapidly create custom calculations and several techniques to conveniently custom group data in a Pivot Table.
  • How to create a single Pivot Table from multiple worksheets or data sources using the Pivot Table Data Model. This is the start of ‘Big Data’ analysis.

Learning Objectives:

  • Effective Database Structure
  • Dynamic Table Design, Layouts, and Style Options to Optimize Analytics
  • Sophisticated Sorting, Filtering, and Grouping Techniques for Analytics
  • Combine Slicers and Filters for Instant, Complex Analytics
  • Calculated Fields and Values for Flexible, Customized Analytics
  • Pivot Charts, Slicers, and Timelines Used With Other Filtering Tools
  • Introduction to Interactive Dashboards
  • Introduction to ‘Big Data’ – Using the Pivot Table Data Model to Create a Pivot Table from Several Worksheets or External Data Sources

Areas Covered in the Webinar:

  • Structuring Your Source Data
  • Rapidly Inserting Your First PivotTable
  • Navigating the Field List
  • Manipulating PivotTable Views
  • PivotTable Options Using Analyze and Design
  • Quickly Moving or Copying Pivot Tables
  • Automatically Managing Dynamic, Growing Source Data
  • Refreshing and Updating Data (Critical)
  • Number Formatting Including Custom Number Formats
  • Rapidly and Automatically Formatting Empty Cells To Avoid Problems
  • Read more

Who Will Benefit:

  • Financial professionals including: CPAs, CFOs, controllers, auditors, accounting staff, budgeting officers, budgeting staff, and financial analysts
  • Management, sales, HR and administrative professionals, who use Excel regularly and analyze or prepare reports
  • IT professionals who need a clear view of Excel Pivot Table capabilities (SQL)
  • Engineers, statisticians and others who work with Quantitative Methodologies (QM)
Instructor Profile:
Joe Weil

Joe Weil
CEO, NCCE

Joe Weil, CPA, M. Acc., is the president of the National Center for Continuing Education (NCCE), a Tallahassee based nationwide financial training firm. With over 25 years’ experience, Mr. Weil has led over 400 seminars on Excel and financial topics and several highly acclaimed webinars on the same topics. He is a former corporate controller, former state agency director of auditing, and a former municipal CFO.

Mr. Weil earned his Master of Accounting Degree at Florida State University. His training clientele include Harley-Davidson, Hewlett-Packard, Oracle, Deloitte, Florida Power and Light, Motorola, National Institute of Science and Technology, and many others.

Topic Background:

The richly detailed handouts, with numbered steps, serve as a valuable reference tool you’ll utilize far into the future. In today's increasingly data-driven world, analytics skills are in short supply and incredibly high demand. Those with the ability to transform data into profit-driven insight are heavily recruited.

Whether you're looking for a quick primer, trying to diversify your Excel skill set, or want to step up your analytics game in a major way, this practical, 90-minute, nuts-‘n-bolts, on-the-job training will advance both your Pivot Tables and analytics skills. Advance Pivot Tables Techniques contains ‘must-know’ knowledge for any professional who needs to transform data into important, understandable business information.

Follow us :
Method Development and Validation for Assays Supporting Testing of Biologics
Computer System Validation - Reduce Costs and Avoid 483s

Refund Policy

Registrants may cancel up to two working days prior to the course start date and will receive a letter of credit to be used towards a future course up to one year from date of issuance. ComplianceOnline would process/provide refund if the Live Webinar has been cancelled. The attendee could choose between the recorded version of the webinar or refund for any cancelled webinar. Refunds will not be given to participants who do not show up for the webinar. On-Demand Recordings can be requested in exchange.

Webinar may be cancelled due to lack of enrolment or unavoidable factors. Registrants will be notified 24hours in advance if a cancellation occurs. Substitutions can happen any time.

If you have any concern about the content of the webinar and not satisfied please contact us at below email or by call mentioning your feedback for resolution of the matter.

We respect feedback/opinions of our customers which enables us to improve our products and services. To contact us please email customercare@complianceonline.com call +1-888-717-2436 (Toll Free).

Product Reviews

This product hasn't received any reviews yet. Be the first to review this product! Write review

Best Sellers
You Recently Viewed
    Loading