Mastering Excel PivotTables: Crunch Data More Efficiently Now!

Duration: 90 Minutes
In this session by expert speaker Dennis Taylor, you will learn the quickest and best ways to create PivotTables and Pivot Charts in Excel to analyze and represent data. This will be presented in Excel 2013 with references to Excel 2010 & 2016. Tools such as Sorting and Filtering in Excel allow users to easily manage large lists of data. However, if you require analyzing every data quickly, PivotTable is the best available option. Based on the huge data, you can quickly create a compact summary report without the use of complex formulas or lengthy techniques.
Mastering Excel PivotTables
Instructor: Dennis Taylor
Product ID: 509478
The PivotTable feature is perhaps the best analytical tool in Excel. You get amazing dynamism and flexibility, in addition to its speed, which lets you to quickly change the data interrelationships that you are viewing. It has been noticed that most PivotTable users find the feature relatively easy to learn; however, not so easy if you are simply reading the instructions from a printed page. This is a visually-oriented feature which is based on displaying fields in various locations. You will be amazed to see how in very little time, you can create a complete summary reports with tons of data and you won't even require to rely on obscure techniques or complex formulas.

Objectives of the Presentation
In this webinar, you will learn how to:
  • Use the Recommended PivotTables button to create PivotTables that will best suit your data so you don't spend time building features manually
  • Learn the concept of drill-down to instantly see the detail records that comprise a summary total
  • Sort PivotTable data by field or content without command or formulas
  • Analyze your data by year, quarter, month, or hour with one click
  • Use Slicers as interactive filters
  • Create and manipulate a visual display of your data with Pivot Charts
  • Group data spontaneously to reveal new summary information not in the source data
  • Utilize the Timeline feature to simplify time-based filtering
Why Should you Attend
When you need to crunch database-like data, you can only go so far with sorting, filtering, and inserting subtotals.

What you need are ways to create summary totals based on multiple criteria and the ability to interchange fields, add other fields, and sort results in a flash. Moreover, how great would it be if you could do all these things and never need to deal with complex, lengthy formulas?

The Microsoft® Excel PivotTable tool gives you all of these capabilities, plus dozens of display and manipulation features.

Consider this scenario: You have thousands of detailed rows of sales data covering a five-year period, containing the names of salespersons, sales dates, items sold, location of sales by state and region, names of buyers, dollar amounts, and more. Imagine if you could quickly create a table to show the total sales by salesperson by state without writing any formulas and complete the task in less than 10 seconds!

Then, without skipping a beat, alter that table to show total sales by month or by year simply by changing a field's location! The possibilities are seemingly endless, and you can apply these same tools just as easily to a variety of data; perhaps an HR list, an inventory list, a detailed budget, a contact list and so on.

This webinar shows you exactly how to use the PivotTable tool to quickly analyze even huge amounts of data in less time than you ever thought possible.

Areas Covered
A PivotTable is Excel's premier analytical tool for quickly creating summary information that you can easily drag-and-drop to manipulate and show multiple levels of totals in a variety of layouts.

PivotTables offer total flexibility:
  • Compare multiple field summary contents
  • Change row/column layouts
  • Perform ad hoc grouping of information
  • Drill down to see the details behind a summary
  • Categorize date/time data on multiple levels
  • Create visual displays with pivot charts
Who will Benefit
This webinar will be beneficial for:
Anyone familiar with many of Excel's features, but who might have had little or no experience with using PivotTables is a good candidate for this course. Also, those users familiar with PivotTables but new to Excel 2013 or 2016 will benefit from this session as well. Although widely used with financial data, you can create PivotTables based on a variety of source data-the feature is potentially valuable to nearly all Excel users.

$300
Recorded Session for one participant
Get life time access with download option!
Book this course
Pay Now
  $450.00 Training CD
Free shipment within 4 Working Days of placing the order. Get life time access for unlimited participants.
  $550.00 Training USB Flash Drive
Free shipment within 4 Working Days of placing the order. Get life time access for unlimited participants.
For multiple location please contact our customer care team +1-510-857-5896.
How it works
Live Session - How it works
  • Login to onlinecompliancepanel with your registered username and password https://www.onlinecompliancepanel.com/login
  • The webinar joining link, username and password for joining the webinar will be updated on your OCP Account 24 hours prior to the webinar
  • Presentation handouts in Downloadable PDF format will be updated on your OCP Account 24 hours prior to the live session
  • Login to the audio conference on the scheduled date and time
  • Get answers to your queries through interactive Q&A sessions via chat at the end of the session
  • Download the Certificate of Attendance and Purchase Invoice from your OCP Account 24 hours after the completion of the session
  • Please let us know your thoughts and views at the end of the webinar, your valuable feedback will help us improve
Recorded Session - How it works
  • Login to onlinecompliancepanel with your registered username and password https://www.onlinecompliancepanel.com/login
  • Upon purchase of the recorded session a link will be updated on your OCP Account within 24 hours
  • Please click on the link to access the Recorded Session
  • Presentation handouts in downloadable PDF format will be updated on your OCP Account within 24 hours of the purchase of the product
  • Download the Certificate of Attendance and Purchase Invoice from your OCP Account after 48 hours of the product Purchase
  • Please share your valuable Feedback at the end of the session
Instructor Profile:
Dennis Taylor has over 25 years of experience working with spreadsheet programs as an author, speaker, seminar leader, and facilitator. Since the mid-90's, he has been the author/presenter of numerous Excel video and online courses and has travelled throughout the US and Canada presenting hundreds of seminars and classes. He has authored or co-authored multiple books on spreadsheet software and has presented nearly 600 Excel webinars to diverse audiences. Dennis has worked with hundreds of different corporations and governmental agencies as well as colleges and universities. He lives in Boulder, Colorado.
View More