23rd November 2021
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:
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)
17th November 2022
With just one month to go before ISQM 1 comes into effect, MGI Worldwide's Technical Committee...
10th November 2022
Are you up-to-date with the International Standard on Quality Management 1 (ISQM 1) requirements?...
28th September 2022
When it comes to firms being environmentally responsible, and eco-friendly, it can be confusing...