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.
Course info
Rating
(12)
Level
Intermediate
Updated
Nov 7, 2019
Duration
1h 24m
Table of contents
Description
Course info
Rating
(12)
Level
Intermediate
Updated
Nov 7, 2019
Duration
1h 24m
Description

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.

About the author
About the author

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

More from the author
More courses by Pratheerth Padman
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone. My name is Pratheerth Padman, and welcome to my Microsoft Excel course, Calculating Cell Values with Formulas. Currently, I'm a freelance data scientist. I used to work in manufacturing, but because of my love for all things data, I completely pivoted to data science. The power and capabilities of Microsoft Excel stem primarily from things it can do with functions and formulas. As such, learning how to implement, debug, and monitor them becomes an invaluable skill. Helping you through that particular maze is what this course aims to do. Some of the major topics that we'll cover include aggregate logical and statistical functions, referencing and serializing date and time, looking up data in Excel using the VLOOKUP and INDEX and MATCH functions, and monitoring, validating, and debugging cells and formulas. By the end of this course, you'll know how to implement and troubleshoot a variety of functions across different topics in Microsoft Excel. There are two prerequisites for this course. First will be a basic understanding of Microsoft Excel's interface. And secondly, some familiarity with how formulas and functions work in Excel would be very helpful. I hope you will join me on this journey to learn all about implementing and troubleshooting functions and formulas in Microsoft Excel with the Calculating Cell Values with Formulas course, at Pluralsight.