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.

Fill in categories and sort

Fill in categories and sort - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Fill in categories and sort

“

- [Instructor] You and I are setting up our new, swanky office and here are some expenses that have come in. We would love to sort the total amounts by largest to smallest value, but we can't right now. If we did, the entries would come away from their corresponding categories and we'd have a mess. That's where your help is needed. Fill in that category column, and then sort the total amounts, largest to smallest. Pause the video, come back, and I will show you two solutions. Okay, you're back, how are we gonna do this? The easy part would be to go down to computer accessories, double click. That goes down. Computers, grab this fill handle, drag down. Office supplies, grab the fill handle, drag down. Categories are filled in, go to total amount, data, sort, largest to smallest. Now we have what we wanted. Now let's look at a second solution. Here's our original data, with the cursor inside the data set, I'm going…

Contents