Ravindra BagaleCourses & study guides

10. Power Query in Excel

By Last updated:

Chala mitrano, aaj aapan Excel madhla "robot" shikuya – Power Query. Data cleaning che steps ekda record kara, aani pudhchya mahinyapasun fakt Refresh daba! Excel/CSV/folder madhun data aanne, bank statements combine karne, Blinkit + Amazon Now append karne, merge, unpivot, group by, parameters – sagla aaj. Ha module shiklat tar tumcha roj cha 2 tasancha kaam 2 minutat hoil.

What you will learn in this module

  • Getting data from a workbook, a CSV file and a folder of files
  • Common cleaning steps and the Applied Steps list
  • Combining monthly bank statements (Date, Narration, Ref No, Debit, Credit, Balance)
  • Append (Blinkit + Amazon Now), Merge (lookups/joins), Unpivot and Group By
  • Parameters, refresh settings and load options: table, connection only, Data Model

Power Query is built in to Excel 2016 and later (and Microsoft 365) under Data › Get & Transform Data. It is the same engine as in Power BI, so everything you learn here transfers directly.

Concepts in this chapter

  1. 10.1Opening Power Query: Data from a Workbook or CSV
  2. 10.2Cleaning Steps in Power Query
  3. 10.3Get Data from Folder: Combining Monthly Bank Statements
  4. 10.4Append: Blinkit + Amazon Now
  5. 10.5Merge Queries
  6. 10.6Unpivot
  7. 10.7Group By
  8. 10.8Parameters
  9. 10.9Refresh and Load Options

The chapter recap is at the end of the last concept page.