Lynda – Excel 2011 for the Mac: Mastering Formulas and Functions
868MB | Duration: 6h 14m | Video: AVC (.mp4) 1280×720 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
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 百度云
转载请注明:0daytown » Lynda – Excel 2011 for the Mac: Mastering Formulas and Functions