Managing and Analyzing Data in Excel (Office 365Excel 2019)

[mitsumi]

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

=
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
     

               

Download link:

Só visivel para registados e com resposta ao tópico.

Only visible to registered and with a reply to the topic.

Links are Interchangeable - No Password - Single Extraction