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.
Excel Basics
·
Module 1
Excel Formula Fundamentals
1
Formulas: Operators & Cell References
Use arithmetic operators and cell references (relative, absolute, mixed) in formulas.
2
Basic Aggregate Functions
Apply basic aggregate functions (SUM, AVERAGE, COUNT, MIN, MAX) to a data range.
Logical Functions for Conditional Calculations
Use logical functions (IF, AND, OR, NOT) for conditional calculations.
4
Mastering Nested IF and IFS Functions
Construct nested IF statements and use the IFS function for multi-condition logic.
Conditional Aggregation with SUMIF/COUNTIF
Perform conditional aggregation using SUMIF(S) and COUNTIF(S).
Text Functions: Extract and Clean Data
Apply text functions (LEFT, RIGHT, MID, LEN, TRIM) to extract and clean text data.
7
Merging Text: CONCATENATE and TEXTJOIN
Combine text from multiple cells using CONCATENATE and TEXTJOIN functions.
8
Essential Date Functions in Spreadsheets
Use basic date functions (TODAY, NOW, DATE, EOMONTH) for common date calculations.
Previous module
Next module
Advanced Functions and Data Retrieval