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

Lynda – Excel 2011 for the Mac: Mastering Formulas and Functions

其他教程 killking 0评论
Poster

Lynda - Excel 2011 for the Mac: Mastering Formulas and Functions

868MB | Duration: 6h 14m | Video: AVC (.mp4) 1280x720 15fps | Audio: AAC 48KHz 2chGenre: eLearning | Level: Advanced | Language: English

Conquer some of the most daunting features in Microsoft Excel once and for all. In this version of his popular course, designed specifically for Excel for Mac users, author Dennis Taylor demystifies some of the most challenging of the 300+ formulas and functions in Excel, and shows how to put them to their best use. Dennis covers key shortcuts, the IF and LOOKUP functions for search and data retrieval, the statistical and math functions, and the date, time, and text functions that make formatting easier. He also covers combining functions to extend their power. These practical examples transition effortlessly to real-world scenarios.

Topics include:
* Using absolute, relative, and mixed references
* Using the Formula Builder
* Converting formulas to values
* Creating 3D formulas to gather data from multiple sheets
* Creating and expanding the use of nested IF statements
* Looking up information with VLOOKUP, MATCH, and INDEX
* Using the power functions: COUNTIF, SUMIF, and AVERAGEIF
* Analyzing data with the statistical functions
* Calculating payment
* Performing basic math
* Determining dates and times
* Editing text with functions
* Analyzing data with arrays

Lynda - Excel 2011 for the Mac: Mastering Formulas and Functions

Download uploaded
http://uploaded.net/file/z5bput1j/LcEx2011MastFormFunc.part1.rar
http://uploaded.net/file/o2czya63/LcEx2011MastFormFunc.part2.rar
http://uploaded.net/file/35n6ukrp/LcEx2011MastFormFunc.part3.rar
http://uploaded.net/file/oh2hxq77/LcEx2011MastFormFunc.part4.rar

Download rapidgator
http://rg.to/file/664a668ab44ab57c7adae4c1552e04b7/LcEx2011MastFormFunc.part1.rar.html
http://rg.to/file/dbd6b07867b614813ddee1ede464e4f3/LcEx2011MastFormFunc.part2.rar.html
http://rg.to/file/b9598a630187d98f870ab4452917e643/LcEx2011MastFormFunc.part3.rar.html
http://rg.to/file/564a02625a19c5286eefdaef861a1137/LcEx2011MastFormFunc.part4.rar.html

Download 百度云

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

sorry! The following hidden content sponsorship VIP members only.

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

网友最新评论 (1)

  1. Lynda – Mac版本的Excel 2011:掌握公式和函数 在这套广受欢迎的专为Mac版本Excel编写的教程中,作者Dennis Taylor会对300多个公式和函数一一讲解,并演示如何它们是如何使用的。Dennis还会讲到快捷方式,用于搜索和数据检索的if和lookup函数,统计和数学函数以及日期、时间以及用于更简单格式化的字体函数。他还会讲到函数的合并使用以扩展它们的功能。
    wilde(特殊组-翻译)2年前 (2014-12-13)