Excel 2016: Managing and Analyzing Data [Updated: 2/11/2025]

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 Excel'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

• Recognize the default settings in multiple-key sorting.
• Explain the benefits of a custom list.
• Name three different ways you can sort in a sort dialog box.
• Recall the function used to randomly sort a list.
• Identify the filters that can be applied to cells containing dates.
• Review appropriate uses of the Advanced Filter.