close

Newsroom

Learn all about Excel’s Power Query and other Microsoft Updates in our most recent tech webinar – ready to watch now!

21st July 2020

MGI World #tech-on-tuesdays webinar background image with Microsoft 365 image and David Benaim  overlaid

Watch on-demand the first of our new series of tech webinars from MVP, corporate trainer & founder of Xlconsulting, David Benaim.

In this webinar David does a deep dive into Excel and showcases how Excel can pull historic stock and currency information, better integration between Power BI and Excel plus some updates to Teams online meeting features. 

More about this webinar

Anyone analysing data understands that 80% of the work is in the data clean up, but it doesn’t have to be that way. 2015 saw the biggest change to Excel in 20 years. Power Query is a tool built into Excel built to Extract data from various sources and reshape it.

To put things into perspective, nowadays David spends around 40% of his Excel time within Power Query. As an Excel MVP running a consulting firm specialising in Excel, David couldn’t imagine creating a solution anymore that didn’t make use of this no-formula way to transform your data.

Watch this webinar now


Valuable resources for you to download


Members of MGI Worldwide with CPAAI can download the presentation file and extra resources, including:

  • A summary of the slides from the talk, including the Power Query Intro and the Power Query Seminar
  • David’s YouTube for pro tips, and special playlists for Excel, Power BI and Power Query

To access these resources, please head to the Webinars page in the Members area.

Tech-on-Tuesday Webinars and future Microsoft Updates

Our regular #tech-on-tuesdays webinars continue through the summer with more 'Wow’s' from David Benaim showcasing the latest updates and features to Microsoft 365.

Each month we will start with a round-up what’s new with a more detailed review of some of the most recent features Microsoft have released. You can keep a look out for dates and details to register in our events calendar, 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 10,000 independent auditors, accountants and tax experts in some 460 locations in almost 100 countries around the world.

Read more on Webinar highlights

MGI World Logo of Mercia Group

Auditing under Covid-19 Webinar by Jo Parker now ready to watch on demand

30th July 2020

In this webinar MGI Worldwide’s Global Quality Partner and Technical Consultant at Mercia Group, Jo...

MGI World #tech-on-tuesdays webinar background image for Kally Gill webinar on RPA

Discover how Robotic Process Automation can help your business in our latest #tech-on-Tuesdays webinar by Kally Gill

23rd July 2020

Watch this webinar recording for everything you need to know about Robotic Process Automation and...

MGI World #tech-on-tuesdays webinar background image with CaseWare logo

Calling all Auditors new to CaseWare! This webinar recording is for you. Learn how to optimise your workflow with Head of Business Development, Jaap de Waard – watch now!

26th June 2020

Our new Global Technology Partner CaseWare invite all Auditors from across our global accounting...