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


How to Use Excel PivotTables—Excel’s Best Analytical Feature (IMED18B)

Presented by: Dennis Taylor
 
(*) Single User Price. For multiple users please call 1-800-223-8720
Live Webinar
60 minutes
Event Description
1.0 CPE

Easily Analyze Your data to Make Quick, Well-informed Decisions

Microsoft Excel has a variety of tools to manage large lists of data, like sorting and filtering. But if you need to quickly analyze tons of data to make quick, well-informed decisions, there’s no better feature than a PivotTable. You can quickly create a compact summary report (based on loads of data) without having to write complex formulas or rely on lengthy techniques, and quickly change the data interrelationships you’re viewing with amazing flexibility and dynamism. And while the feature is relatively easy to learn, like many users you too can feel intimidated if you are simply seeing the printed instructions.

Attend this webinar by Excel trainer Dennis Taylor, and you’ll be amazed to see how in very little time, you can create a complete summary report with tons of data – without having to rely on obscure techniques and difficult formulas. Taylor will teach you the quickest and best ways to create PivotTables and Pivot Charts, and how to use them to make quick, well-informed decisions. You will learn how to sort and filter results, arrange the data as you like by date/time in multiple levels in a simple, easy-to-understand format. Taylor will show you how to use slicers to identify which field elements are being displayed; drill down to see the summary details; create a Pivot Chart that is in sync with your PivotTable; add calculated fields to perform additional analysis; and hide/reveal detail/summary information with a simple click. You will also learn how to deal with dynamic data source data and the “refresh” concept, and create a PivotTable based on data from multiple worksheets.

After attending this webinar, you’ll know the fastest and best ways to create PivotTables and Pivot Charts. You’ll know how to quickly create a compact summary report with tons of data without using complex formulas. Plus, you’ll be able to easily analyze your data to make quick, well-informed decisions.

Session Highlights

This webinar will teach you how to:

  • Prepare data so that it can be analyzed by PivotTables
  • Compare two or more fields in a variety of layout styles
  • Sort and filter results
  • Manipulate the appearance of a PivotTable via dragging and command techniques
  • Perform ad-hoc grouping of information
  • Use Slicers instead of filters to identify which field elements are being displayed
  • Drill down to see the details behind the summary
  • Categorize date/time data in multiple levels
  • Create a Pivot Chart that is in sync with a PivotTable
  • Add calculated fields to perform additional analysis
  • Hide/reveal detail/summary information with a simple click
  • Deal with dynamic source data and the “refresh” concept
  • Create a PivotTable based on data from multiple worksheets
  • Explore the best techniques for updating PivotTables

Who Should Attend

  • C level executives
  • CPAs
  • Accountants/finance professionals
  • Administrators
  • Office managers
  • Attorneys
  • Business analysts
  • HR professionals
  • Executive assistants

At the Q&A session following the live event, ask a question and get a direct response from our expert speaker.

About Our Speaker(s)

Dennis Taylor | Microsoft Excel SpeakerDennis 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: How to Use Excel PivotTables—Excel’s Best Analytical Feature
    Presenter(s): Dennis Taylor

 
 
 
Our Accreditation Partners
DMCA.com Protection Status