LINKEDIN LEARNING MANAGING AND ANALYZING DATA IN EXCEL OFFICE 365EXCEL 2019-BiFiSO

Large amounts of data can become unmanageable fast. But with the data management and analysis features in Excel, 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 2019 and Excel for Office 365. He covers sorting, adding subtotals, filtering, eliminating duplicate data, working with tables, and using functions to isolate and analyze data. With these techniques, you'll be able to better manage your lists and extract the most important information from them, in the shortest amount of time.

Topics include:
- Prepping data for analysis
- Multiple-key sorting
- Sorting based on custom lists
- Creating single- and multi-level subtotals
- Using text, numeric, and date filters
- Filtering tables using slicers
- Using the Advanced Filter
- Eliminating duplicate data
- Using SUMIF and related functions for quick data analysis