Save a ton of time as you analyze data quickly and easily!
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.
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.
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 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.
- Simple PivotTable shortcuts that automate difficult analyses
- How to drill down to see instantly the detailed records that comprise a summary total
- Advice on presenting your data in different formats quickly and easily
- Ways to sort PivotTable data without lengthy command sequences
- Time-saving Pivot Report tips and tricks to create flawless reports
- How to create summary totals in a flash
- Ways to modify PivotTables settings to boost your efficiency
- How to group data quickly to reveal new information not in the source data
- Comparing two or more fields in a variety of layout styles
- Sorting and filtering results
- Performing ad-hoc grouping of information
- Using Slicers instead of filters to identify which field elements are being displayed
- Drilling down to see the details behind the summary
- Categorizing date/time data in multiple levels
- Ways 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
- Dealing with dynamic source data and the “refresh” concept
- How to create a PivotTable based on data from multiple worksheet
Who Will Benefit:
- C Level Executives
- Executive Assistants
- Office Managers
- Finance Professionals
- Business Analyst
- HR Professionals