From the course: Cert Prep: Excel Expert - Microsoft Office Specialist for Office 2019 and Office 365
Join today to access over 24,500 courses taught by industry experts.
Troubleshoot formulas
From the course: Cert Prep: Excel Expert - Microsoft Office Specialist for Office 2019 and Office 365
Troubleshoot formulas
- [Instructor] In Excel we have several awesome tools we can use to troubleshoot formulas. After watching this video you'll know how to trace cell precedents and dependents so you can see which cells are dependent upon other cells and which cells depend upon your active cell. You'll also learn how to create a Watch Window, that way you can keep an eye on a cell or a range of cells, to watch for changes in those cells. We'll learn how to validate our formulas using error checking rules and the Evaluate Formulas tool. Let's jump right into our Troubleshoot workbook, and we will first take a look at a couple of errors we have in here. Look in cell G6. We're getting an error message that Excel doesn't understand what the value's supposed to be here. So we need to use our tools on Formulas, and in the Formula Auditing group. Well, what I like to do when I see an error is trace the precedents. When I click on that…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
Contents
-
-
-
-
-
-
Use AND(), OR(), and NOT() in nested functions6m 9s
-
Use IF() and IFS() in nested functions4m 31s
-
(Locked)
Use SWITCH() in nested functions3m 38s
-
Use SUMIF(), AVERAGEIF(), SUMIFS(), and AVERAGEIFS() functions5m 2s
-
(Locked)
Use COUNT() and COUNTIF()2m 54s
-
Use MAXIFS() and MINIFS() in nested functions3m 27s
-
(Locked)
Look up data using VLOOKUP() and HLOOKUP()5m 52s
-
Use the MATCH() and INDEX() functions5m 47s
-
(Locked)
Use NOW() and TODAY() functions and calculate dates using WEEKDAY() and WORKDAY() functions8m 15s
-
(Locked)
Summarize data from multiple ranges by using the Consolidate feature3m 10s
-
(Locked)
Use What-If Analysis Goal Seek and Scenario Manager5m 57s
-
(Locked)
Calculate financial data with NPER() and PMT() functions3m 30s
-
(Locked)
Troubleshoot formulas9m 24s
-
(Locked)
Challenge: Create advanced formulas27s
-
(Locked)
Solution: Create advanced formulas9m 8s
-
-
-
-