Mastering Microsoft Excel Pivot Tables & Pivot Charts

MessageThis Webinar is over
Date Oct 24, 2018
Time 01:00 PM ET
Cost $169.00
Online
Analyze Lengthy Data In Seconds With PivotTables & Pivot Charts

Sorting, filtering, and subtotals are among the many data management tools for handling manage large lists of data, but if you need to analyze all that data and do it quickly, nothing is better than a PivotTable. You can quickly create compact summary reports (based on tons of data) without needing to write complex formulas or rely on lengthy techniques. A PivotTable feature is probably Excel’s best analytical tool and in addition to its speed, you get amazing flexibility and dynamism that let you quickly alter the data interrelationships you’re viewing. Most PivotTable users discover that the feature is relatively easy to learn, but not so easy if you are simply seeing the instructions on the printed page; this is a visually-oriented feature based on displaying fields in different locations.
This webinar by Dennis Taylor shows you multiple examples of how to create a PivotTable, along with powerful techniques, like Slicers, Timelines, Calculated Fields, and Conditional Formatting. This webinar will be demonstrated in 2016 and will support 2010 and 2013 version of excel.

Training Objectives
After attending this webinar, you’ll be able to learn the quickest and best ways to create PivotTables and Pivot Charts, including:
  • How to compare two or more fields in a variety of layout styles
  • How to sort and filter results
  • How to perform ad-hoc grouping of information
  • How to use Slicers instead of filters to identify which field elements are being displayed
  • How to drill down to see the details behind the summary
  • How to categorize date/time data in multiple levels
  • How to create a Pivot Chart that is in sync with a PivotTable
  • How to add calculated fields to perform additional analysis
  • How to hide/reveal detail/summary information with a simple click
  • How to deal with dynamic source data and the “refresh” concept
For Registration and more info:  CLICK HERE

Use discount coupon ED10 to get 10% Off on early bird registration. Offer vaid till October 20th, 2018.

PS: Subscribe to  EDUCATORONE    Monthly OR Yearly Subscription

CLICK HERE  to get more Information on different subscription plans.
 

 


comments powered by Disqus
Create your own event
Turn your passion into a business.
Join our mailing list