Troubleshooting Excel Formulas

Focused View

Amruta Mahajan

1:26:38

0 View

1-Course Overview

1 -Course Overview.mp4

01:36

2-Understanding and Correcting Errors When Entering Formulas

2 -Course Introduction.mp4

06:24

3 -#NUM.mp4

01:51

4 -#VALUE.mp4

03:13

5 -#NULL.mp4

01:32

6 -Circular Reference.mp4

03:18

3-Understanding and Correcting Problems with Existing Formulas

7 -Overview.mp4

02:40

8 -#N A.mp4

04:38

9 -#REF.mp4

04:59

10 -#####.mp4

02:30

4-Tools to Audit Formulas and Cell Relationships

11 -Watch Window.mp4

04:29

12 -Demo Watch Window.mp4

03:56

13 -Trace Precedents and Dependents.mp4

05:42

14 -Demo Trace Precedents and Dependents.mp4

04:51

5-Tools to Monitor and Debug Formula

15 -Evaluate Formula.mp4

04:31

16 -Demo Evaluate Formula.mp4

02:47

17 -Error Checking.mp4

05:19

18 -Demo Error Checking.mp4

03:06

6-Best Practices to Speed up Your Troubleshooting Workflow

19 -Error Checking Rules.mp4

01:50

20 -Demo Enabling Error Checking Rules.mp4

02:42

21 -Troubleshooting Workflow.mp4

02:08

22 -Excel Formulas Best Practices.mp4

05:49

23 -Readable and Extensible.mp4

03:37

24 -Exercising Caution When Copying Formulas.mp4

03:10

Description

Learn the basics of Excel errors, why they occur, and how to resolve them. Get better at using Excel provided monitoring and debugging tools, incorporate best practices to avoid errors, and become more efficient at fixing problematic workbooks.

What You'll Learn?

Sometimes your Excel spreadsheet doesn't work as expected and it has so much data that you don't even know where to begin. In this course, Troubleshooting Excel Formulas, you will learn to tackle the most complicated of spreadsheets. First, you will learn the different error types in Excel, what each of them mean, and how to correct them. Next, you will discover some monitoring and debugging tools provided by Excel to help isolate issues in large formulas, and understand the relationships between various cells. Finally, you will explore how to use best practices to avoid errors and develop your own optimized troubleshooting workflow. When you are finished with this course, you will have the skills and knowledge of common issues needed to fix any Excel spreadsheet.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel Formulas and Functions

Amruta Mahajan

Instructor's Courses

Amruta is an experienced Data Analyst with over 12 years of experience in interpreting and analyzing data to drive successful business outcomes. She loves tackling hard problems using data manipulation as her superpower and has worked with market leaders from various fields including Standard & Poors, McDonalds, Mondelez International, General Electric, AMD and Beam Suntory. Amruta is passionate about both teaching and learning and believes “The purpose of life is to discover your gift. The work of life is to develop it. The meaning of life is to give your gift away”. Amruta has an undergrad in Statistics and a Masters in Computer Science. She speaks English, Hindi and Marathi and codes in VBA, Python and R

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.