Excel - Power Query - No Code Automation Every User Needs to Know About

Date: Monday March 4, 2024

10:00 AM PST | 01:00 PM EST

Duration: 90 Minutes
Instructor: Mike Thomas 
Webinar Id: 803847


One Attendee
Unlimited Attendees


One Attendee
Unlimited Attendees ?


Live + Recorded
$269 $318  
One Attendee
Live + Recorded
$599 $678  
Unlimited Attendees ?

This training focuses on importing data from various sources and automating data cleaning processes in Excel.


Turn bad data into great data in minutes!

Do you spend more time than is necessary importing and updating data from external sources such as databases, CSV files and web pages?

Does the phrase "it's taking too long" describe how you feel about the time it takes to get your data into the right format for your reports?

Do you regularly perform repetitive time-consuming "data cleaning and transforming" tasks such as removing unnecessary rows and columns, filtering out data that you don’t need, converting text to numbers or dates, splitting or merging columns, removing "weird" characters or combining files together?

Would you like to be able to do all the above with the click of a button? If the answer Is yes, you need Power Query (known as Get and Transform in Excel 2016 and later).

This training will focus on two main topics How to import data into Excel from a variety of sources and how to automate the data cleaning process

Why should you Attend: Power Query / Get and Transform can save you a ton of time when working with imported data. In many cases when you get data from external sources, it needs work on it before it can be used. Although this can be done using Excel functionality, Power Query / Get and Transform is a lot faster and is repeatable with a couple of clicks

Areas Covered in the Session:

  • Import data into Excel from sources such as text files, web pages and databases
  • Avoid Excel’s "million-row limitation"
  • Keep the imported data in sync with the source data using just two clicks
  • Understanding and Managing Steps in the Power Query Editor
  • Save a ton of time - automate the data cleaning process

Who Will Benefit:
  • This training is classed as intermediate and is aimed at users of Excel who wish to learn about Power Query/Get and Transform to clean data (as both a one-off and a repeating process)

Speaker Profile
Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies including Microsoft Office and Apple Mac. In 2012 He founded theexceltrainer.co.uk where he has produced nearly 200 written and video-based Excel tutorials. He has recorded several Excel training courses for pluralsight.com and in his career delivered hundreds of courses and webinars on a wide variety of technology-related topics.

Mike is a Fellow of The Learning and Performance Institute and has worked with and for a large number of global and UK-based companies and organisations across a diverse range of sectors. In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.

You Recently Viewed