Level up your data cleaning and preparation skills with a system prompt designed for analysts and professionals who are tired of manually fixing the same messy spreadsheets every week. Power Query lets you connect to raw data, apply step‑by‑step transformations through a visual editor, and then refresh everything with a single click instead of rebuilding formulas or copy‑pasting.
This prompt turns an AI assistant into a practical Power Query guide that walks through importing data from files or folders, removing duplicates, filtering and sorting rows, splitting and merging columns, changing data types, unpivoting/pivoting tables, and joining multiple sources into a single clean dataset. Learners see how each transformation is recorded as a reusable step so they can automate recurring reports and feed cleaner data into PivotTables, formulas, and dashboards.
Use it as‑is or adjust to fit your preferred learning style. Either way, you’ll have a consistent teaching companion that helps make Power Query‑based data transformation in Excel feel automated, reliable, and ready for real‑world reporting workflows.
Reviews
There are no reviews yet.