Skip to main content
grasp.study
Back to course
Log in
Get started
Someone wanted to learn this too, so Grasp built them a personal learning path.
Create your own
Data Science
ยท
Module 1
Data Analysis and Spreadsheet Foundations
1
Defining Measurable Objectives for Financial Analysis
Translate a finance-related business question into one measurable analysis objective.
2
Classifying Dataset Field Types
Classify dataset fields as identifiers, categorical variables, numerical variables, or dates.
3
Structuring Data in Tidy Format
Restructure a small dataset so that each row represents one observation and each column represents one variable.
4
Importing and Verifying CSV Data in Excel
Import a CSV file into Excel and verify that fields were parsed correctly.
5
Constructing Excel Formulas with Relative and Absolute References
Construct Excel formulas using relative and absolute cell references.
6
Calculating Summaries with Spreadsheet Functions
Calculate summaries with SUM, AVERAGE, MIN, MAX, and COUNT.
7
Sorting and Filtering Data to Answer Business Questions
Use sorting and filtering to inspect records relevant to a business question.
8
Spreadsheet Data Quality Checks
Identify missing values, duplicates, inconsistent labels, and invalid values in a spreadsheet.
Next module isn't ready yet,
Back to course
Previous module
Next module