Live Educational Webinar
WEBINAR: Excel Efficiency: Pivot Tables
Price: FREE
Aug. 24, 2017 Thursday
11:00 AM - 12:00 PM (Pacific)
1 Hour
Free Live Webinar
- Free CPE
- Non-sponsored Events mean you never listen to a 3rd party sales pitch – it’s all just great education
- Expert-instructor-led learning with live Q&A
- Based on a great course on Illumeo
David Ringstrom President and CPA, Accounting Advisors Inc
Many Microsoft Excel users feel that pivot tables are somehow beyond their grasp, yet this is one of Excel's easiest and best features. In this course Excel expert David Ringstrom, CPA, shows you how to whip ugly raw data into a format ready for analysis with a pivot table. You'll quickly be dragging and dropping fields to instantly create reports from lists of data. For this session David offers four different handouts that are specific to Excel 2013, 2010, 2007, and 2003, respectively.
You learn how to:
You learn how to:
- Quickly whip unwieldy data into the format required for pivot table analysis.
- Use a simple keyboard shortcut to post the same formula to multiple cells at once.
- See how the Table feature can vastly improve the integrity of pivot tables in Excel.
- Explore the basics of pivot table creation.
- See the nuances of subtotaling data within a pivot table.
- Dig deeper into the numbers by using the Report Filter command to create break-out tables.
- Incorporate calculations within, or alongside, pivot tables.
- Disable the GETPIVOTDATA function if you don't need it for your analysis.
- See how pivot tables differ from worksheet formulas and the importance of the Refresh command.
REGISTER
Learning Objectives
After attending this event you will be able to:
Transform raw data into the ideal format for pivot table analysis
Simplify pivot table maintenance by way of Excel's Table feature
Contrast different methods for performing calculations within and outside of pivot tables
Speakers
David Ringstrom
President and CPA, Accounting Advisors Inc
David H. Ringstrom is a CPA and owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet consulting firm that he started in 1991. David speaks at conferences on Excel and presents scores of webinars each year. He is an author and served as the technical editor for over 30 books on accounting software. Some of his freelance articles on spreadsheets have been published internationally.
Moderated by: Khoa Tran
Operations Manager, Illumeo
Khoa is in charge of live event operations at Illumeo and has led the preparation and execution of hundreds of live events on various finance, accounting and related topics across the Office of the CFO. You could say his job is a lot like learning finance and accounting for a living. Khoa is primarily responsible for ensuring great content, delivery, and learning for each of Illumeo's webinars and live events.
Register for this Event
Price: FREE
