Featured resource
Tech Upskilling Playbook 2025
Tech Upskilling Playbook

Build future-ready tech teams and hit key business milestones with seven proven plays from industry leaders.

Learn more
  • Course
    • Libraries: If you want this course, consider one of these libraries.
    • 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.

Pratheerth Padman - Pluralsight course - Calculating Cell Values with Formulas
by Pratheerth Padman

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

About the author

Pratheerth Padman - Pluralsight course - Calculating Cell Values with Formulas
Pratheerth Padman

Pratheerth is a freelance Data Scientist who has entered the field after an eclectic mix of educational and work experiences.

More Courses by Pratheerth