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:
Why Should you Attend
- 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
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.
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:
Who will Benefit
- 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
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.