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.
Automate Excel
·
Module 2
Core Functions for Accounting
Conditional Summing with SUMIF and SUMIFS
Use SUMIF and SUMIFS to conditionally total values from accounting data.
Counting with Criteria: COUNTIF & COUNTIFS
Use COUNTIF and COUNTIFS to count entries that meet specific criteria.
3
Conditional Averages with AVERAGEIF and AVERAGEIFS
Use AVERAGEIF and AVERAGEIFS to calculate conditional averages for analysis.
4
Using the IF Function for Conditional Logic
Apply the IF function to create formulas that perform different actions based on a logical condition.
5
Nested IFs and IFS for Multiple Conditions
Use nested IF functions or the IFS function to evaluate multiple hierarchical conditions.
6
Rounding Financial Figures
Apply ROUND, ROUNDUP, and ROUNDDOWN to control decimal precision in financial figures.
Mastering Date Functions: DATE, TODAY, and EOMONTH
Use DATE, TODAY, and EOMONTH functions to manage dates for tasks like calculating due dates or aging.
Previous module
Formula Fundamentals and Cell Referencing
Next module
Data Retrieval and Structuring