From the course: Excel Power User Challenge

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Hours and ratings

Hours and ratings - Microsoft Excel Tutorial

From the course: Excel Power User Challenge

Start my 1-month free trial Buy for my team

Hours and ratings

“

- [Instructor] In columns B, C, and D, we have a list of people and the hours that they put in on different projects, and we have ratings, one-star to four-star, based on how they did with the projects. Now, we would like, basically, a pivot table that shows us the person by rating and the sum of hours. We could do this with a pivot table, but we're going into the modern age and using this brand new function, PIVOTBY, that's the requirement. And once you have the data, then answer the questions: Who has the most hours in the four-star category? And who only has four-star ratings, all right? Pause the video, and get to using that PIVOTBY and come on back. (upbeat music) (text pulses) All right, you're back. While you were away, I had a sip of chocolate milk. Oh, it was so tasty. And hopefully, you got a tasty result from using that PIVOTBY. Here we go. And, yes, there's a couple curve balls in here that…

Contents