From the course: Copilot in Excel: Supercharge Your Financial Modeling
Join today to access over 24,800 courses taught by industry experts.
Simplify error checking with Copilot
From the course: Copilot in Excel: Supercharge Your Financial Modeling
Simplify error checking with Copilot
- An unfortunate reality of spreadsheeting, especially more complex ones are formula errors. They're just a fact of life. Some formula errors are easier to spot with a naked eye, such as say this div0 here in cell I14, others are a little bit more difficult to spot as they might seem to be working fine, but are inconsistent when compared with its neighboring formulas. Now, whilst Copilot can't magically fix formula errors, it can certainly assist in identifying them in a streamlined manner. in the Copilot pane, let's create a prompt. Can you help me with error checking? Okay. Let's scroll back up. We actually have quite a few suggestions. Now let's just have a quick look. We're not using the if error function, we're not using the is error function. This third suggestion here looks pretty handy using the error checking tool. Let's actually go ahead and give that a go. We need to select the formulas tab, and then click on error checking in the formula auditing group, which is this…
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.