Excel: Advanced Pivot Tables for Finance Professionals
Date: Fri, Apr 26, 2013
Time: 02:00 P.M. ET
Duration: 1 hour 15 minutes
Without a doubt, pivot tables are the most powerful feature in Excel, as they allow users to quickly summarize and analyze large amounts of data. Yet Microsoft estimates that only 15% of Excel users take advantage of this powerhouse data tool. Why? The feature can be cumbersome, difficult to learn, and even intimidating at times, if not explained properly.
Join Bill "MrExcel" Jelen for this Webcast for advanced Excel users as he breaks through these barriers and demonstrates quick and easy techniques for mastering pivot tables. The Webcast includes real-world examples of how best to use the power of pivot tables in corporate finance scenarios, as well as a bevy of eye-opening techniques and time-saving tricks to help users become comfortable with the tool.
During the Webcast, you will learn how to:
- Create, customize and alter how you view pivot tables;
- Perform calculations with pivot tables;
- Analyze multiple data sources using pivot tables and PowerPivot;
- Use filters, including the "slicer" tool, to dynamically filter pivot tables;
- Enhance pivot tables with macros and VBA (Visual Basic for applications); and
- Avoid common pitfalls and mistakes with pivot tables.
Although Bill "MrExcel" Jelen uses Excel 2010 to demonstrate tips and tricks during the Webcast, he also always mentions and explains what is different in earlier versions of Excel -- going back to 2003.
This Webcast does not currently offer the opportunity to earn continuing professional education (CPE) credit. We invite you to stay tuned to CFO.com for future Webcasts that will offer attendees opportunities to earn CPE credit.
For inquiries or complaints concerning this Webcast, please call (888) 250-5719.
About the Presenter
Bill Jelen, MrExcelBill Jelen, the world's foremost spreadsheet wizard, is known internationally as "MrExcel." His Web site, MrExcel.com, is the premier source for Excel tips and solutions.
About CFO Learning
- CFO Learning provides targeted training and education for corporate finance
executives and their teams to help these professionals stay ahead of today's evolving business
environment. Our training is delivered online, in-person, and in self-study formats and our presenters
are leading experts experienced in providing efficient instruction to professionals.