Leverage Data with Power Pivot
Are you an existing Excel user looking to expand your existing knowledge of PivotTables and extend it to incorporate multiple data sources and sophisticated time-series analysis? Discover this and more in this webinar.
Develop your analytics skills by learning how to use Power Pivot. Developed for Excel 2010 and enhanced for 2013 and 2016, Power Pivot is a data analysis tool that delivers unmatched computational power.
In this webinar you will learn to generate rich and interactive Power Pivot analysis tools that look like they have spent weeks in development. Walk through a case study exploiting many of Power Pivot's powerful tools and functionalities, including the ability to take financial and non financial data from a range of sources and combine it together in a single PivotTable for analysis.
This webinar assumes a basic working understanding of how PivotTables are used, though some common concepts covered will be applicable to both normal PivotTables and those created using Power Pivot.
Presenter, Tim Heng, is a Director at the consulting firm SumProduct. He runs a range of Excel training courses listed on the Chartered Accountants Australia New Zealand store, and is a Microsoft MVP specialising in Excel, one of only ~110 worldwide.
Upon satisfactory completion of this webinar you will be able to:
- Identify how Power Pivot builds on the functionality of Excel's native tools, such as Pivot Tables, slices and key analytical functions.
- User Power Pivot to import data from a variety of electronic sources.
- Process and link large amounts of data quickly to deliver key information in minutes.
- Understand what version of Excel you have and how to get / enable Power Pivot.
Leverage data to create value with Power Pivot. Learn how to combine data sources and link tables together to perform powerful, flexible PivotTable analysis without spending weeks putting calculations together.
Tim Heng, has over 10 years’ experience in financial model development, model auditing, banking, training and consultancy. He was previously the Head of Training at Corality, and is currently a Director at the consulting firm SumProduct. Tim has run numerous training courses in financial modelling and Microsoft Excel skills around the world. Tim is recognised by Microsoft as a Most Valuable Professional (MVP) expert in Excel, one off c.100 such individuals worldwide.
Topic: Business Mindset
Sub-Topic: Information & Communication Technology
Format: Recorded Webinar
Proficiency Level: Intermediate, Advanced
CPD: 1 hours