InsideEdgeInsideEdge
Download App

Phase 2 · Excel & Spreadsheets

Topics

Power Query

Part of the Data Analyst Roadmap.

Summary

Excel's built-in tool for importing, cleaning and reshaping data through a repeatable, recorded set of steps — so you don't have to manually re-clean a dataset every time it refreshes.

How to Learn This

  • 1Import a CSV through Power Query and apply 2-3 transformation steps.
  • 2Learn to refresh a query and see your cleaning steps automatically reapply.
  • 3Understand why Power Query beats manual cleaning for any recurring report.

Previous

Excel Charts & Dashboards

Next

Google Sheets Essentials

More topics in Excel & Spreadsheets

Excel FundamentalsFormulas & Functions (VLOOKUP, INDEX-MATCH, XLOOKUP)PivotTables & PivotChartsConditional FormattingData Cleaning in ExcelExcel Charts & DashboardsGoogle Sheets EssentialsData Validation in SpreadsheetsExcel Shortcuts & Productivity
InsideEdge

Stuck on this topic? Ask an Insider

Get 1:1 guidance from people who've walked this exact path — free on the InsideEdge app.

Download
InsideEdge