close

Newsroom

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

23rd November 2021

MGI World Tech 518X362

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’s 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.

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 paul@mgiukarea.com or Maxine Brock at maxine.brock@mgiworld.com.

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. 

Read more on Webinar highlights

MGI World Picture of BChristine Armstrong with 2021 Global Meeting lettering on green background

The Great Reset: The New World of Work! Writer and researcher Christine Armstrong explores the global working environment. Recording now available!

24th November 2021

The Covid-19 pandemic has fundamentally shifted the way in which people work across the globe....

MGI World Picture of Bronwyn Williams with 2021 Global Meeting lettering on green background

Global Meeting guest speaker Bronwyn Williams takes a look at the impact of disruptive emerging trends - Recording now available!

12th November 2021

Speaking at the MGI Worldwide CPAAI 2021 Global Meeting, Bronwyn Williams, Futurist, Economist and...

MGI World Leslie Everett's image on black and white background

How can you help your firm stand out and get noticed? Don’t miss the recording by leadership branding expert Lesley Everett for all MGI-CPAAI members

11th October 2021

This content-rich and interactive session from award-winning professional keynote speaker and...