最新消息:网盘下载利器JDownloader--|--发布资讯--|--解压出错.密码问题

Lynda – Excel 2016: Managing and Analyzing Data

其他教程 killking 0评论

Lynda - Excel 2016: Managing and Analyzing Data

Size: 727 MB | Duration: 3h 0m | Video: AVC (.mp4) 1280x720 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.

Topics include:
* 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
Lynda - Excel 2016: Managing and Analyzing Data
Download 百度云

以下隐藏内容只提供VIP赞助会员

sorry! The following hidden content sponsorship VIP members only.

您必须 登录 才能发表评论!

网友最新评论 (1)

  1. Lynda - Excel 2016: 管理和分析数据 大量的数据会象难以控制的脂肪一样增长。但是通过Excel 2016中数据管理和分析的功能,你可以轻松地掌控最大的数据表格。在本教程中,Dennis Taylor将会分享用于在Excel中维护大数据的易于使用的命令、功能和函数。他会讲到排序、添加subtotal、筛选、删除重复数据以及使用Excel的筛选功能和特定的数据库函数分离和分析数据。通过这些技术,你能够以最短的时间从数据中提取最重要的信息。 主要内容:准备用于分析的数据;多键排序;单级和多级排序;使用文本、数字以及日期过滤;创建自定义筛选;使用高级筛选;删除重复数据;使用SUMIF和Countif函数用于快速数据分析;使用dsum和dmax函数处理数据库。
    wilde(特殊组-翻译)10个月前 (08-02)