A PivotTable 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 PivotTable have no impact on the original data. With a PivotTable, 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 analyze your data quickly, a PivotTable is the answer. You can create compact summary reports without writing complex formulas and you can quickly change the data interrelationships that you are viewing. A PivotTable is one Excel’s best analytical tools.
Many Excel users find PivotTables relatively easy to understand, but it is a feature that is awkward to learn if you’re just viewing instructions from a printed page. It’s a visually-oriented feature (ideal for being presented via a webinar) based on displaying fields in different locations.
To learn not just the basics but also shortcuts and power tools associated with PivotTables, attend this session by expert speaker Dennis Taylor. You will be able to create PivotTables from different input sources and use different options like conditional formatting, slicers, and date consolidation efficiently.
Comparing two or more fields in different styles Filtering and sorting results Using a more powerful filtering method – Slicers Making use of timelines for dynamic time-based displays Resurrect relevant source data with drill-down Categorizing date/time data in various levels Creating a Pivot Chart that’s in sync with a Pivot Table Putting in calculated fields in order to do additional analysis Ways to reveal/hide detail/summary information with a single click Ways to deal with the “refresh” concept and dynamic source data Techniques for applying Conditional Formatting to a PivotTable Generating PivotTables from various input sources (different workbooks and worksheets) Making use of the new Timeline feature Exploring the best techniques for updating Pivot Tables Creating ad hoc and date-based groupings within a Pivot Table
Who Should Attend:
- C Level Executives
- Executive Assistants
- Office Managers
- Finance Professionals
- Business Analyst
- HR Professionals