Managing and Analyzing Data in Excel (Office 365/Excel 2019)
Managing and Analyzing Data in Excel (Office 365/Excel 2019)
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 2h 30m | 500 MB
Instructor: Dennis Taylor
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 2h 30m | 500 MB
Instructor: Dennis Taylor
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
Managing and Analyzing Data in Excel (Office 365/Excel 2019)
