Analyse data in Excel through clickable interactive dashboards
02 November, 2021 14:00 - 15:00 London Time (GMT)
Founder - trainer - data scientist - MVPdavid@xlconsulting-asia.com
Tuesday 2 November 2021, 14:00-15:00 London Time (GMT)
Our regular Tech-on-Tuesday webinars continue as our resident tech guru, David Benaim, showcases the latest updates and features to Microsoft Word, looking particularly at analysing data in Excel through clickable interactive dashboards.
In this tutorial workshop, you can follow along on screen with example files. David will work with you to create some useful interactive dashboards of different kinds of data. We will clean up messy data with Power Query, create pivot tables to summarise the data and then charts from those Pivot Tables plus clickable interactive slicers. We will explore Excel’s new charts liker map charts, waterfalls, box & whisker as well as practical chart hacks like budget vs actuals, and even grab data from Excel’s own encyclopedia feature known as linked data types.
About David Benaim ACA MVP
David Benaim MVP is corporate trainer & founder of Xlconsulting. David began his career as a chartered accounting training contract at Deloitte London and now runs a data analytics & training firm Xlconsulting in Cambodia which has trained over 1500 people and consulted over 100 clients in six years. He has a YouTube channel with over 100 tech tutorial videos, some featured on the Microsoft Creators YouTube Channel and in Feb 2020, he was granted the prestigious Microsoft MVP award.