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.

What's the deal with these payroll calculations?

What's the deal with these payroll calculations? - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

What's the deal with these payroll calculations?

“

- [Instructor] We got a serious problem. We just received the payroll workbook, you and I are supposed to sign off on it. And the next step after us is payroll, and they write the checks. But immediately I saw problems. First, how can we pay Christian negative $250.90. And then go to the pivot table page, whomever calculated this, just captured Christian's data. But Christian typically goes by Chris, and Christian is missing out on $102,000 worth of sales, because they're tied to Chris. Let's look at the transactions page. All right, here are all of the transactions, and let's go back to the payroll sheet. Before we send this back to the person who calculated this, please find at least five problems in this workbook, and they can be bad practices, or just plain corrupt data. Don't fix the problems, that's not our job. What we want to do, is identify the problems. So please pause the video. Find at least five problems, come…

Contents