Join Dennis Taylor for an in-depth discussion in this video Mastering a custom sort with multiple-key sorting, part of Excel 2011 for the Mac: Managing and Analyzing Data.
- View Offline
- Exercise Files
- In this worksheet called MultipleKeySorting,…we got a list of some 740 names,…and it currently is in order…based on the information in column A, the Employee Name.…We might want to sort this by Department.…Now, I know ahead of time that at least one…of the departments has about 100 people in it.…And if I'm viewing that particular portion of the list,…I'm a little concerned about…finding this person, that person,…because we'd have no order…within that particular department.…So sorting sometimes means…sorting not on the basis of simply what's in one column,…but in two, or three or four, or many columns.…
Maybe as we look at that list,…particularly within that large department,…we might wanna see them in order by their status.…Column F has four different kinds of status,…Full Time, Half-Time, Contract and Hourly.…And even then we might have a lot of people…within that full time status,…and we might be trying to find them quickly.…Maybe we wanna alphabetize by name…within that list,…or by years of service.…So it's not uncommon that, when we are sorting data,…
- Multiple-key sorting
- Sorting columns left-to-right
- Filtering columns
- Creating a top-ten list with values or percentages
- Using Advanced Filter for complex filters
- Setting up subtotals
- Using the Remove Duplicates command
- Using SUMIF, COUNTIF, and related functions
- Working with the database functions, such as DSUM and DMAX
Skill Level Intermediate
Financial Literacy: Reading Financial Reportswith Rudolph Rosenberg1h 25m Appropriate for all
Excel for Mac 2011 Essential Trainingwith Curt Frye6h 32m Beginner
Migrating from Excel 2008 for Mac to Excel 2011with David Rivers1h 10m Appropriate for all
1. Sorting Data
2. Filtering Data
3. Advanced Filter
4. Creating Automatic Subtotals in Sorted Lists
5. Eliminating Duplicate Data
6. Data Analysis Tools
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.