From the course: Excel Weekly Challenge

Unlock this course with a free trial

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

Office expenses and relationships

Office expenses and relationships - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Office expenses and relationships

“

- [Instructor] Ready for this. This is some really great stuff in Excel and is going to stretch you. We've got these 2 datasets. A notice, Tatum is in Customer Service and spent $6 and 9 cents on computer accessories. In the other dataset, the director of Customer Service is Marcie. And Marcie's in the Errickson Center. But also notice, Marcie is also the director of Inside Sales which is also in the Errickson Center. We want a single pivot table that will show the total cost broken down by director and by category. And in order to do that we need a relationship between the 2 datasets. Now pause the video, make that happen, comeback. I'll do it and we'll compare our results. You're back, here we go. First with the cursor in the dataset. I'm going to Format this as a Table. Let's grab this orange, OK. Get rid of the filter buttons and I'm going to call this E-X-P for expenses. Cursor in the other dataset, Formatted…

Contents