课程: Excel Weekly Challenge

免费学习该课程！

今天就开通帐号，24,100 门业界名师课程任您挑！

The expense report is wrong

The expense report is wrong - Microsoft Excel教程

课程: Excel Weekly Challenge

开始一个月试用 购买团队方案

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…

内容