Lynda – Excel 2016: Managing and Analyzing Data

Lynda – Excel 2016: Managing and Analyzing Data

Size: 727 MB | Duration: 3h 0m | Video: AVC (.mp4) 1280×720 15&30fps | Audio: AAC 48KHz 2ch
Genre: eLearning | Level: Intermediate | Language: English
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.

* Prepping data for analysis
* Multiple-key sorting
* Sorting by rows or by columns
* Setting single- and multi-level subtotals
* Using text, numeric, and date filters
* Creating custom filters
* Filtering tables using slicers
* Using Advanced Filter
* Eliminating duplicate data
* Using SUMIF and COUNTIF functions for quick data analysis
* Working with the database functions such as DSUM and DMAX

Download uploaded
http://uploaded.net/file/6b21fltz/LcExcel2016ManagAnalyzData.part1.rar
http://uploaded.net/file/pjmiwdsm/LcExcel2016ManagAnalyzData.part2.rar
http://uploaded.net/file/upc0jtku/LcExcel2016ManagAnalyzData.part3.rar
http://uploaded.net/file/jxywtm1q/LcExcel2016ManagAnalyzData.part4.rar

Download nitroflare
http://nitroflare.com/view/5DA0AE544F08695/LcExcel2016ManagAnalyzData.part1.rar
http://nitroflare.com/view/1A485412EB0B690/LcExcel2016ManagAnalyzData.part2.rar
http://nitroflare.com/view/660F0016DF9204A/LcExcel2016ManagAnalyzData.part3.rar
http://nitroflare.com/view/9ABEAED4722F684/LcExcel2016ManagAnalyzData.part4.rar

Download 百度云

你是VIP 1个月(1 month)赞助会员，

资源下载

此资源仅限VIP下载，请先登录

转载请注明：0daytown » Lynda – Excel 2016: Managing and Analyzing Data