Skip to main content
grasp.study
About
Explore
Pricing
Log in
Try it for free
Back to course
👋
Welcome to a Grasp lesson
Create a free account
to keep studying and create your own study path.
Get MIS Executive job
·
Module 10
Advanced Data Consolidation with Power Query
1
Importing and Combining Data from Multiple Excel Files with Power Query
Use Power Query to import and combine data from multiple Excel files within a folder.
2
Combine Data from Multiple Worksheets
Append data from multiple worksheets into a single master table.
3
Power Query Basics: Data Transformation Fundamentals
Apply basic data transformations in the Power Query Editor (e.g., filter rows, remove columns, change data types).
4
Loading Data into Excel
Load the cleaned and transformed data into the Excel data model or a new worksheet table.
Previous module
Creating Interactive Dashboards
Next module
Capstone 1: Incident Management MIS System