Course Overview

Save hours every week by automating your messy spreadsheet data

Power Query Essentials: Importing, Filtering, and Cleaning Data shows you how to turn raw, messy files into clean tables ready for analysis. The course walks through the full process of pulling data into Excel or Power BI, fixing errors, and shaping columns to keep your reports accurate. Instead of manually patching spreadsheets every time new data arrives, you build a repeatable process that can save hours each week and reduce costly mistakes.

You start by learning how to import data from sources like CSV files, PDFs, and Excel workbooks, then filter out the rows and columns you do not need. Applied Steps let you track every change and adjust your work without having to start over. You learn to fix inconsistent text, fill in missing values, split and merge columns, and set the right data types. By the end of the training session, you will know how to take a messy file, clean it in minutes, and load it into a report you trust.

Learning Objectives:

At the end of this course, you will be able to:

• Set up automated calendar instructions to decline meetings outside working hours.
• Automatically remove canceled meetings from the calendar using the digital assistant.
• Generate quick text summaries of all meetings scheduled during the week.
• Insert interactive Loop components into team meetings for better collaboration.
• Create scheduled tasks with custom reminders directly inside the To-Do application.