7th January 2021
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 email@example.com or Maxine Brock at firstname.lastname@example.org.
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.
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...