Watch our latest #tech-on-Tuesdays webinar and learn how to work magic with Excel. Webinar recording available on demand!

Another successful #tech-on-Tuesdays webinar, presented by our resident Microsoft expert David Benaim, showcased the latest updates to Excel, looking particularly at analysing data through clickable interactive dashboards.

In this webinar, David explains how to create some useful interactive dashboards of different kinds of data, and shows how to 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.

David also explored 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.

You can watch the recording of David' tutorial video HERE:

Sway summary

David made a post webinar pack via Sway HERE. It is a collection of all post webinar resources including a written summary, relevant videos from David’s YouTube channel, the exercise workbook David used, the slides, and the recording.

sway-screenshot.png


Finally you can keep up to date with David’s YouTube channel where he posts weekly videos on all sorts of workplace technology. See HERE.

Weekly shortcut tip:

Excel Filter: Ctrl Shift L (see article by David Benaim, from last week, on Cambodia’s impressive vaccine rollout)

For more information please contact Paul Winder at [email protected] or Maxine Brock at [email protected].

MGI Worldwide with CPAAI, is a top 20 ranked global accounting network and association with some 10,000 professionals, accountants and tax experts in some 460 locations in more than 100 countries around the world.