Calculating Cell Values with Formulas

Focused View

Pratheerth Padman

1:24:02

21 View

01 - Course Overview

01 - Course Overview.mp4

01:47

02 - Implementing Operations and Performing Calculations with Functions and Formulas

02 - Module and Course Introduction.mp4

02:22

03 - Aggregate Functions - SUM and COUNT.mp4

05:14

04 - Aggregate Functions - MIN, MAX, and AGGREGATE.mp4

06:17

05 - Logical Operators and Functions.mp4

04:37

06 - Demo- Implementing Logical Operators and Functions in Excel.mp4

04:28

07 - Statistical Functions - AVERAGE, MEDIAN, MODE, and STDDEV.mp4

02:12

08 - Statistical Functions- SUMIF, COUNTIF, and AVERAGEIF.mp4

02:41

09 - Summary.mp4

01:25

03 - Referencing and Serializing Date and Time in Excel

10 - Module Introduction.mp4

01:19

11 - NOW and TODAY Functions.mp4

01:38

12 - Demo- Implementing the NOW and TODAY Functions in Excel.mp4

02:33

13 - Date and Time Storage in Excel.mp4

04:20

14 - DATE and TIME Functions.mp4

03:48

04 - Cell References and Data Lookup in Excel

15 - Module Introduction.mp4

00:47

16 - Cell References in Excel.mp4

06:32

17 - VLOOKUP Function.mp4

03:16

18 - Demo- Looking up Data with the VLOOKUP Function.mp4

02:24

19 - INDEX and MATCH Functions.mp4

03:25

20 - Demo- Combining the INDEX and MATCH Functions.mp4

03:25

05 - Monitoring, Validating, and Debugging Cells and Formulas in Excel

21 - Module Introduction.mp4

01:08

22 - Trace Precedents and Dependents.mp4

03:55

23 - Monitor Cells Using Watch Window.mp4

03:05

24 - Validating Formulas with Error Checking Rules.mp4

04:53

25 - Debugging Formulas Using Evaluate Formula.mp4

05:05

26 - Summary and Feedback.mp4

01:26

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Pratheerth Padman

Instructor's Courses

Pratheerth is a Data Scientist who has entered the field after an eclectic mix of educational and work experiences. He has a Bachelor's in Engineering in Mechatronics from India, Masters in Engineering Management from Australia and then a couple of years of work experience as a Production Engineer in the Middle East. Then when the A.I bug bit him, he dropped everything to dedicate his life to the field. He is currently working on mentoring, course creation and freelancing as a Data Scientist.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.