Excel 2016 for the Mac: Managing and Analyzing Data

Large amounts of data can become unmanageable fast. But with the data management and analysis features in Excel 2016, you can keep the largest spreadsheets under control. In this course, Dennis Taylor shares easy-to-use commands, features, and functions for maintaining large lists of data in Excel. He covers sorting, adding subtotals, filtering, eliminating duplicate data, and using the program's Advanced Filter feature and specialized database functions to isolate and analyze data. With these techniques, you'll be able to extract the most important information from your data, in the shortest amount of time.

Learning objectives
Multiple-key sorting
Sorting by background color, font color, or icon
Sorting based on the order of a custom list or in random order
Creating a top-10 list with values or percentage
Creating single and multiple level subtotals from a sorted list
Creating specialized filtered lists using Advanced Filter
Quickly eliminating duplicate rows from lists
Counting unique items using an array formula
Using SUMIF and COUNTIF functions