Skip to main content
Back to course
Log in
Get started
Someone wanted to learn this too, so Grasp built them a personal learning path.
Create your own
Job Readiness
·
Module 1
The Analyst Mindset and Excel Foundations
1
From Business Request to Evidence-Based Recommendation
Describe how a data analyst moves from a business request to an evidence-based recommendation.
Describe how a data analyst moves from a business request to an evidence-based recommendation.
2
From Business Request to Measurable KPI
Translate a business request into a specific analytical question and measurable KPI.
Translate a business request into a specific analytical question and measurable KPI.
3
Classifying Spreadsheet Columns by Data Type
Classify spreadsheet columns as identifiers, dimensions, measures, or dates.
Classify spreadsheet columns as identifiers, dimensions, measures, or dates.
4
Organizing Data in Excel: Observations and Variables
Structure a dataset in Excel with one observation per row and one variable per column.
Structure a dataset in Excel with one observation per row and one variable per column.
5
Mastering Relative, Absolute, and Mixed Cell References in Excel
Use relative, absolute, and mixed cell references correctly in Excel formulas.
Use relative, absolute, and mixed cell references correctly in Excel formulas.
6
Calculating Business Metrics in Excel
Calculate business metrics with Excel arithmetic and basic aggregate functions.
Calculate business metrics with Excel arithmetic and basic aggregate functions.
7
Categorizing Records with IF Logic
Apply IF logic to categorize records according to a business rule.
Apply IF logic to categorize records according to a business rule.
8
Conditional Totals and Counts with SUMIFS and COUNTIFS
Calculate conditional totals and counts with SUMIFS and COUNTIFS.
Calculate conditional totals and counts with SUMIFS and COUNTIFS.
Next module isn't ready yet,
Back to course
Previous module
Next module