Join Dennis Taylor for an in-depth discussion in this video Using the exercise files, part of Excel 2011 for the Mac: Managing and Analyzing Data.
- If you have access to the exercise files for this course, you can put them on your desktop, as I have, or anywhere else you want. There is one exercise file for each chapter. Each file, in this example, Chapter One, has various worksheets in it that correspond with the individual movies in the chapter. Occasionally, I will reuse a worksheet. At the end of each movie, make sure to close the exercise file without saving, and reopen the file for the next movie. If you're a premium member of lynda.com, you will have access to these files.
If you don't have access to the files, you can follow along with your own files as we proceed through the course.
- 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
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.