Close
< All events

Analyse data in Excel through clickable interactive dashboards

02 November, 2021 14:00 - 15:00 London Time (GMT)


Login to register
David Benaim

Founder - trainer - data scientist - MVP

david@xlconsulting-asia.com
198 Days
13 hours
50 Minutes
1 Seconds

Details

Start: 02 11 2021
End: 02 11 2021

Event category:
Webinar

Venue:
Virtual

+ Google Calendar + ICal export

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.

For more information contact Paul Winder (paul@mgiukarea.com) or David Benaim (david@xlconsulting-asia.com).

If you do not have login details to the Member Area of the MGI Worldwide website, please contact emma.rowley@mgiworld.com