From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

The expense report is wrong

The expense report is wrong - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

The expense report is wrong

“

- [Instructor] Now this example is based on a time when I made $300 for 45 minutes worth of work. I got a panicked call about a spreadsheet where the numbers didn't add up. And they couldn't figure out why not. So let's look at this example. J12, N5, and O5 should have the same value, because they are totals of expenses for Q1 and Q2. So your task, see if you can find out why these numbers don't add up, think about how you might fix these, and if you should fix these. Pause the video, dig into this, come back, and we'll go through it together. You're back, and I'm wonderin' what you found. This value is a total of that column, which makes sense. That's a total of those values. Let's not mess around too much here. Let's just go straight for the jugular, hit Control + tilde. Now let's visually inspect this. And we see some wrong stuff. Cell D12, somebody has manually loaded, add $1,162. E4 doesn't have a…

Contents