Webinar · Palm Beach, Florida
Pivot Tables-Microsoft Excel Instant Report Writer- Excel Analysis
Business, Franchising, Licensing · Education, Training
Key numbers
- Editions on record
- 1first in 2015
About Pivot Tables-Microsoft Excel Instant Report Writer- Excel Analysis
Pivot Tables: Microsoft Excel's Instant Report WriterPivot Tables Instructor: David H. Ringstrom Product ID: 500944 Description In this presentation Excel expert David H. Ringstrom, CPA helps you understand both the nuances and the power of pivot tables in Excel. Pivot tables are one of Microsoft Excel's least understood, yet most powerful features. With just a few mouse clicks you can instantly create reports from voluminous lists of data. Instead of trying to manually pore through data by sorting or filtering, you can quickly create a summary format that you rearrange by simply dragging and dropping field names on the screen. Of course there's a minor catch, you do have to structure your data properly otherwise your report will either be incomplete, or may return the count of the records displayed instead of summing. Areas Covered Learn the basics of pivot table creation Avoid frustration by understanding the nuances of pivot table formatting Dig deeper into the numbers by using the Report Filter command to create break-out tables Disable the GETPIVOTDATA function if you don't need it for your analysis Discover the recommended pivot tables feature in Excel 2013 and later Drill down into numbers with a double-click--or prevent users from being able to do so Filter data faster by way of the Slicers feature in Excel 2010 and later Incorporate calculations within, or alongside, pivot tables Learn how to utilize the PowerPivot feature in Excel 2010 and later Mitigate the side effects of converting a table back to a normal range of cells Quickly summarize complex data sets with Excel's Pivot Chart feature Quickly whip unwieldy data into the format required for pivot table analysis See how pivot tables differ from worksheet formulas and the importance of the Refresh command See how the table feature can vastly improve the integrity of pivot tables in Excel See the nuances of subtotaling data within a pivot table Summarize information from Access databases and other
From our listing of this edition. Details may have changed since.
Editions
| Year | Dates | Where | Exhibitors | Visitors |
|---|---|---|---|---|
| 2015 | 12 Aug 2015 | Webinar Venue Online | — | — |
Past editions from the bvents archive (2008–2019) and organiser figures where they were published.
Questions
When is Pivot Tables-Microsoft Excel Instant Report Writer- Excel Analysis?
The next dates haven't been confirmed. The last edition we have on record was 12 Aug 2015.
Where is it held?
The last edition we have was at Webinar Venue, Palm Beach, Florida.