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

Lynda – Excel Workshop: Building a Dynamic Heat Map

其他教程 killking 0评论
Poster

Lynda - Excel Workshop: Building a Dynamic Heat Map
Size: 299MB | Duration: 1h 34m | Video: AVC (.mp4) 1280x720 15fps | Audio: AAC 48KHz 2ch
Genre: eLearning | Level: Intermediate | Language: English

You don't need special software to create data visualizations. With some advanced functions, formatting, and filters, you can create these heat maps right in Microsoft Excel. The techniques shown in this course transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool for heat mapping. Chris Dutton provides hands-on examples designed to showcase why certain functions—DATEVALUE, VLOOKUP, COUNTIF, and more—are so valuable to mapping data. He also shows how to use conditional color-scale formatting to map your data matrix, and find different ways to examine the same data with different criteria, using dynamic filters. The course wraps up with a few finishing touches to make your heat map even more useful and engaging, including a preview of what's possible with the Power Map addin.

Topics include:

* Setting up the heat map project
* Using functions such as WEEKDAY and VLOOKUP
* Adding conditional statements
* Formatting with the color-scale feature
* Aggregating data with SUM
* Adding dynamic filters
* Creating formula-based formatting rules
* Adding additional analytics
Lynda - Excel Workshop: Building a Dynamic Heat Map

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

网友最新评论 (1)

  1. Lynda - Excel专题:开发动态热力图 你无须特殊的软件也能创建数据可视化。通过一些高级的函数、格式化、筛选,你可以在Microsoft Excel中创热力图。本教程中所演示的技术将Excel从一个普通的数据表格软件转变成了动态并且强大的用于开发热力图的分析工具。Chris Dutton通过使用的例子讲解为何某些函数:DATEVALUE, VLOOKUP, COUNTIF等对于数据映射是非常适用的。他还会讲解如何这些条件颜色刻度,来映射成数据矩阵,并通过不同的方式使用不同的标准和动态筛选来演示同样的数据。最后通过一些样式的修饰,让热力图更有用和更吸引人,并会对Powdr Map插件有所涉及。 主要内容:建立热力图项目;使用weekday和vlookup函数;加入条件表达式;使用颜色刻度格式化数据;通过sum汇总数据;加入动态筛选;创建基于公式的格式化规则;加入额外的分析。
    wilde(特殊组-翻译)1年前 (2015-12-03)