From the course: Excel for Sales Professionals
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Sort and filter
- One of the most common needs with data, especially data that's been imported from a database source, or even data that your sales rep have input for you, is the ability to sort it. With table filters you can quickly sort by any given column, just click on the column and sort oldest to newest or newest to oldest. This is already sorted so I'm not going to do anything. But what if that sort isn't enough for you. What if you need to sort by order, by sales rep, by customer name, and so on. You can go to the Data tab and click Sort, and you'll see a Sort dialogue. In this case, Sort already sees that Order Date is sorted. I'm going to add a level and I'm going to sort by Sales Rep. And add another level, and sort by Customer Name. And add another level, and sort by Sales. And in this case in Sales, Excel wants to give me smallest to largest, I want to do largest to smallest, cause I want to see who my biggest customers by Sales Rep are. We're going to click OK, and Excel applies this…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.