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 Analyst Job Readiness Plan
·
Module 1
Advanced Excel for Data Analysis
1
VLOOKUP: Data Retrieval and Limitations
Use VLOOKUP to retrieve data from a table and describe its limitations.
2
Dynamic Lookups with INDEX and MATCH
Combine INDEX and MATCH to perform flexible lookups that overcome VLOOKUP's limitations.
3
Building Pivot Tables for Data Summarization
Build pivot tables to summarize and aggregate data by categories.
4
Conditional Calculations with COUNTIF, SUMIF, and AVERAGEIF
Apply conditional functions (COUNTIF, SUMIF, AVERAGEIF) to filter calculations.
5
Text Functions for Data Cleaning
Use text functions (LEFT, RIGHT, MID, CONCATENATE, TRIM) to clean and manipulate string data.
6
Visualizing Data Patterns with Excel Charts
Create charts (bar, line, scatter) to visualize data patterns in Excel.
7
Conditional Formatting for Data Trends
Apply conditional formatting rules to highlight data trends and outliers.
8
Nesting Excel Functions for Advanced Analytics
Combine multiple Excel functions in nested formulas to solve complex analytical problems.
Next module isn't ready yet,
Back to course
Previous module
Next module