Join Dennis Taylor for an in-depth discussion in this video Setting up single- and multiple-level subtotals, part of Excel 2013: Managing and Analyzing Data.
…In this worksheet called Subtotals, I've got a list of some 740 names.…We'd like to make some sense out of it…by somehow coming up with some subtotals based on departments.…Right now, the data is sorted by employee name.…If we click in column B in any single cell and…click the AZ button, we will have sorted the data by department.…There are no empty rows within this list, no empty columns.…We've got our titles in a single row.…A good way to structure data before…using filtering and sorting and subtotal as well.…Now, we can introduce subtotals based on a department change.…
Automatically rather than manually inserting a…row break after every department change.…It's going to be a lot faster than we could do it manually.…As you look at the data a bit more deeply perhaps you might also…see that within each department we do…have different kind of statuses represented here.…So it might also make sense to have sub totals.…There as well.…You can create subtotals in excel on a single level.…Or multi level let's imagine that eventually what we'd like to have here.…
- Multiple key sorting
- Filtering single and multiple columns
- Creating a top-ten list with values or percentages
- Setting up subtotals
- Creating multiple-field criteria filters
- Creating unique lists from repeating field data
- Using the Remove Duplicates command
- Finding duplicate data with specialized arrays
- Counting the number of unique items in a list
- Using SUMIF and COUNTIF functions
- Working with the database functions such as DSUM and DMAX
- Converting lists to tables
Skill Level Intermediate
1. Sorting Data
2. Filtering Data
3. Advanced Filter
4. Creating Automatic Subtotals in Sorted Lists
5. Eliminate Duplicate Data
6. Data Analysis Tools
Converting lists to tables10m 45s
- 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.