Introduction to Power Query

In today’s data-driven world, messy and inconsistent datasets slow down productivity and decision-making. This one-day hands-on training—Introduction to Power Query—equips professionals with the skills to clean, shape, and consolidate data from various sources using one of the most powerful tools in Microsoft Excel and Power BI.

Participants will learn how to extract data from Excel, CSVs, folders, and even PDFs. The course guides learners through the Power Query interface and teaches how to perform common and advanced transformations, such as splitting/merging columns, extracting data, formatting, and replacing or filling values. You'll also gain expertise in consolidating datasets using Append and Merge queries, a game-changer for those working across multiple data files.

Real-world case studies—including financial analysis, acquisition due diligence, and time series analysis—ensure participants understand how to apply these skills in actual business scenarios. Plus, speed challenges offer a fun, engaging way to build problem-solving efficiency under real-life constraints.

By the end of the training, learners will walk away with practical techniques that can immediately reduce time spent on repetitive data tasks, improve accuracy, and simplify workflows. Whether you're a business analyst, finance professional, or Excel power user, this course is your gateway to transforming the way you work with data—forever.