“Excel Tip of the Week” author David Lyford-Tilley takes us on a deep dive into how the powerful and flexible Power Pivot add-in can be used to connect datasets together to make simpler management reporting dashboards.
We investigate how to create a data universe that is easy to understand and update, and build custom Measures and KPIs for tracking performance. This is all be done with a practical, hands-on example that you can take away to study after the session.
Please note that the material covered in Comprehensive guide to PivotTables 2022 is assumed knowledge for this webinar.
Please note that the material covered in Comprehensive guide to PivotTables 2022 is assumed knowledge for this webinar.
Speaker:
David Lyford-Tilley: David is an Excel specialist and an ICAEW Technical Manager. He was previously with BDO as a senior Excel specialist, working on Excel training and education. David runs the popular blog series for the Excel Community called ‘Tip of the Week’. David also works with ICAEW Excel Community Advisory Committee, providing guidance and input to the work of the committee.
First broadcast on 22 March 2022