close

Newsroom

Do you use Excel? Are you aware of its many NEW features? Watch our ‘AI & modern charts in Excel’ with David Benaim, now available on demand

7th January 2021

MGI World Laptop background for David Benaim webinar's on AI And Modern Charts In Excel

In this webinar, presented during the MGI Worldwide CPAAI Virtual Global Meeting, David Benaim uncovers some exciting features of modern Excel and explains how to design modern charts and make audit reports become more visual and appealing.

More about this webinar

Excel in modern times is becoming less formula based. In this webinar you will learn about:

AI Ideas: Scan a table for insights into outliers, trends, frequency, correlation without writing a single formula.
Ask a question: Highlight a table and then ask things like “Top 3 customers in 2019 in UK” or “Median sales in August” etc.
Waterfall charts: Show which things affect a number at time A vs time B, for example prior year profit to current year or headcount or sales.
Map charts: Excel can now look up regions and have data showing on map charts.
Pareto charts: Uninteresting at first, this chart has some unexpected benefits.

Watch this webinar now:


Excel software requirements:

Certain features are available from Excel 2016 onwards (PC or Mac), but other features are only available  to participants who have a subscription to Excel 365 (Microsoft Office 365’s monthly updated version of Excel).

Members of MGI Worldwide with CPAAI can download the presentation files. To access these resources, please head to the Webinars page in the Members area.

For a full range of Microsft tips and tutorials, visit David Benaim’s YouTube channel here.

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 almost 10,000 independent auditors, accountants and tax experts in some 460 locations in over 100 countries around the world.

Read more on Webinar highlights

MGI World Gradient purple backdrop image with text overlay

Recent #tech interactive workshop explores new Microsoft Loop and latest Teams updates. Recording now available!

23rd June 2022

MGI Worldwide resident #tech expert David Benaim showcases the latest updates and features to...

MGI World New ISQM 1 Roundtable Highlights 518X362

Don’t miss the recording of last week's round-table presentation on the Introduction to the New Quality Management Standards

2nd May 2022

Aiming at providing MGI Worldwide members with an update on the new quality management standards...

MGI World Graphic elements with text overlay

Need tips for designing a compelling content strategy for your firm? Watch a recording of the latest Marketing call to find out more

18th April 2022

During our latest Marketing Call, on 7 April, award winning content creator and former journalist,...