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.
Data and Business Analysis
·
Module 1
Advanced Excel for Data Analysis
1
Advanced Lookups with INDEX-MATCH
Use INDEX-MATCH to perform lookups across multiple columns and sheets
2
Summarizing Data with Pivot Tables
Create pivot tables to summarize and analyze large datasets
3
Building Pivot Charts
Build pivot charts to visualize summarized data
Conditional Formatting for Data Patterns
Apply conditional formatting rules to highlight patterns in data
5
Importing Data with Power Query
Use Power Query to import data from external sources such as CSV and Excel files
6
Transforming Data in Power Query Editor
Perform basic data transformations in the Power Query Editor including removing columns, filtering rows, and changing data types
Next module isn't ready yet,
Back to course
Previous module
Next module