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 Resume Essentials
·
Module 1
Advanced Excel for Data Analysis
1
Cleaning and Standardizing Text Data with Functions
Clean and standardize raw data using text functions such as TRIM, PROPER, TEXT, and LEFT/RIGHT/MID
2
Multi-Criteria Calculations with SUMIFS and COUNTIFS
Use SUMIFS and COUNTIFS to perform multi-criteria calculations on a dataset
3
Flexible Lookups with INDEX-MATCH
Use INDEX-MATCH to perform flexible lookups across datasets
Nested IF and IFS Functions for Conditional Logic
Apply conditional logic using nested IF and IFS functions
5
Summarizing Data with Pivot Tables
Create a pivot table to summarize data by one or more categorical variables
6
Changing Pivot Table Calculations
Customize a pivot table's values by changing summary calculations (e.g., from SUM to COUNT or AVERAGE)
7
Analyzing PivotTable Data for Business Insights
Filter, sort, and group data within a pivot table to answer specific business questions
Next module isn't ready yet,
Back to course
Previous module
Next module