- Course
- Data
Calculating Cell Values with Formulas
In this course, Calculating Cell Values with Formulas, you'll learn to implement various types of functions and formulas, followed by methods to monitor and debug them.
What you'll learn
The power and capabilities of Microsoft Excel stem primarily from the things it can do with functions and formulas. As such, learning how to implement, debug, and monitor them becomes an invaluable skill.
This course, Calculating Cell Values with Formulas, aims to help you through that maze.
The first three modules deal with the implementation of functions and formulas to deal with things like performing calculations with aggregate functions, performing logical and statistical operations, referencing and serializing dates and times, and looking up data in Excel.
In the fourth and fifth modules, you’ll focus on troubleshooting and auditing these formulas. You'll explore techniques like tracing precedents and dependents, monitoring cells and formulas with Watch Window, etc.
When you're finished with this course, you'll know how to implement and troubleshoot functions and formulas in Excel.
Table of contents
- Version Check | 15s
- Module and Course Introduction | 2m 22s
- Aggregate Functions - SUM and COUNT | 5m 14s
- Aggregate Functions - MIN, MAX, and AGGREGATE | 6m 17s
- Logical Operators and Functions | 4m 38s
- Demo: Implementing Logical Operators and Functions in Excel | 4m 28s
- Statistical Functions - AVERAGE, MEDIAN, MODE, and STDDEV | 2m 12s
- Statistical Functions: SUMIF, COUNTIF, and AVERAGEIF | 2m 41s
- Summary | 1m 25s
About the author
Pratheerth is a freelance Data Scientist who has entered the field after an eclectic mix of educational and work experiences.