Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

Calculating Cell Values with Formulas

via Pluralsight

Overview

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.

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.

Taught by

Pratheerth Padman

Reviews

4.7 rating at Pluralsight based on 47 ratings

Start your review of Calculating Cell Values with Formulas

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.