My Shopping Cart
There are no items in your shopping cart.

Mastering Excel PivotTables (IME461D)

Presented By : Dennis Taylor
(*) Single User Price. For multiple users please call 1-800-223-8720
Pre Recorded Webinar
100 minutes
  •  Tue, April 12, 2016
Event Description
See the sneak peek before you buy!
2.0 CPE

Know How to Master Excel PivotTables by Learning the Unique and Powerful Techniques

A Pivot Table in Excel is a summary table based on a list of data; it is distinct and separate from the original data, yet dependent on it. Changes you make to a Pivot Table have no impact on the original data. With a Pivot Table, you can find trends, analyze patterns, and complete multiple summaries based on your detailed (and sometimes voluminous) worksheet data.

In order to manage large data lists, there are many types of Excel tools available like sorting, filtering etc. However, if you need to analyse every data and do it fast, then PivotTable is your answer. PivotTable in Excel will assist you in creating compact summary reports without the requirement of writing complex formulas depending on long techniques. The PivotTable feature is probably one of the best analytical tool of Excel, which adds to its speed. You will be able to get good dynamism and flexibility which will help you quickly change the data interrelationships that you are viewing. Many of the users of PivotTable find the feature very easy to understand and learn; however, it is not so easy if you are just viewing the instructions from a printed page. The feature is visually-oriented and is based on displaying fields in different locations.

To get more powerful techniques of PivotTable like calculated fields, slicers, conditional formatting and timelines, attend this session by expert speaker Dennis Taylor. You will be able to make PivotTables from different input sources and use different options like conditional formatting, slicers etc. effectively.

Session Highlights:

You will learn the best and easiest ways to create PivotTables, including these capabilities:

  • Comparing two or more fields in different styles
  • Filtering and sorting results
  • Conducting ad-hoc grouping of information
  • Identifying the kinds of field elements displayed using slicers than filters
  • Making use of timeline for dynamic time-based displays
  • Digging deep to know the details behind the summary
  • Categorizing of time/date data in various levels
  • Creating of a Pivot Chart in sync with a PivotTable
  • Putting in calculated fields in order to do additional analysis
  • Ways to reveal detail/hide/summary information/ with a click
  • Ways to deal with the “refresh” concept and the dynamic source data
  • Ways to create a PivotTable using data from various worksheets
  • Ways to provide Conditional Formatting to PivotTable Data
  • Generating PivotTables from various input sources (different workbooks and worksheets)
  • Using Slicers to accentuate field elements that are being shown at present (and which ones are not)
  • Making use of the new Timeline feature
  • Using Conditional Formatting with PivotTable data
  • Exploring the best techniques for updating PivotTables
  • Creating ad hoc and date-based groupings within a PivotTable

Who Should Attend

  • C Level Executives
  • Executive Assistants
  • Accountants
  • Administrators
  • Office Managers
  • Attorneys
  • CPA
  • Finance Professionals
  • Business Analyst
  • Accountants
  • Bookkeeper
  • HR Professionals
About Our Speaker(s)

Dennis Taylor, Microsoft Excel Training ExpertDennis Taylor
Dennis Taylor has taught thousands of Excel seminars and classes since the early 90's, is the author/presenter of over 250 Excel webinars, and authored the book Teach Yourself Microsoft Excel 2000. He has taught hundreds of public Excel seminars in the US and Canada since 2006 and has recorded over 100 Excel courses bo... More info

Recommend this event to a colleague
  • Your Name:
  • Your E-mail:
  • Colleague's Name:
  • Colleague's E-mail:
    Subject: You might be interested in this event from AudioSolutionz
    Event Title: Mastering Excel PivotTables
    Presenter(s): Dennis Taylor Protection Status