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
Level
Intermediate
Updated
Nov 7, 2019
Duration
1h 24m
Table of contents
Description
Course info
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
Excel Data Lookup Function Playbook
Advanced
34m
Oct 21, 2019
More courses by Pratheerth Padman
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
[Autogenerated] Hi, everyone. My name is for Teeth Budman and welcome to my Microsoft Excel Coast calculating sell values with formless. Currently, I'm a freelance data scientist. I used to work in manufacturing, but because of my love for all things data and completely pivoted to data science, the power and capabilities of Microsoft Excel stem primarily from things that can do with functions and formulas. As such, learning how to implement be buck and monitor them becomes an invaluable skill. Helping you through that particular means is what this course in to do. Some of the major topics that will cover include aggregate logical and statistical functions, referencing and serializing date and time, looking up data and Excel using the we look up and index match functions and monitoring, validating on debugging cells and formulas. By the end of the schools, you'll know how to implement and troubleshoot of variety of functions across different topics in Microsoft Excel. There are two prerequisites for this coast. First will be a basic understanding of Microsoft excels interface and secondly, some familiarity with how formulas and functions working excel would be very helpful. I hope you will join me on this journey to learn all about implementing and troubleshooting functions and formulas, and Microsoft excel with the calculating cell valued with formless coast, a floor site.