【Lynda】Excel 2010: Advanced Formulas and Functions【CHN】中英文字幕[SRT]

作者: acely. 分类: Lynda中文字幕, ◇ 商业办公

==========教程信息=====================================================
教程名称:Excel 2010: Advanced Formulas and Functions
作者:Dennis Taylor
主题:Business, Spreadsheets
使用软件:Excel 2010
难度等级:高级
时长: 5h 5m
发布日期: Dec 03, 2010

┏ACELY STUDIO,2012
┃更多资源请访问
┃◆唯一发布站:ACELY.CN
┗◆我的博客:http://blog.sina.com.cn/u/1991840741

==========教程目录文件列表=============================================
Excel 2010- Advanced Formulas and Functions[SRT]
├─◆0. Introduction
│ └─◇ 0001 Welcome.srt
│ └─◇ 0002 Using the exercise files.srt
├─◆1. Formula and Function Tips and Shortcuts
│ └─◇ 0101 Using the entire row column references.srt
│ └─◇ 0102 Copying column formulas instantly.srt
│ └─◇ 0103 Converting formulas to values with a simple drag.srt
│ └─◇ 0104 Creating 3D formulas to gather data from multiple sheets.srt
│ └─◇ 0105 Updating values without formulas.srt
│ └─◇ 0106 Displaying and highlighting formulas.srt
│ └─◇ 0107 Simplifying debugging formulas.srt
│ └─◇ 0108 Enhancing readability with range names.srt
├─◆2. Formula and Function Tools
│ └─◇ 0201 Reviewing function basics.srt
│ └─◇ 0202 Using and extending AutoSum.srt
│ └─◇ 0203 Using absolute and relative references.srt
│ └─◇ 0204 Using mixed references.srt
├─◆3. IF and Related Functions
│ └─◇ 0301 Exploring IF logical tests and using relational operators.srt
│ └─◇ 0302 Creating and expanding the use of nested IF statements.srt
│ └─◇ 0303 Using the AND, OR, and NOT functions with IF to create compound logical tests.srt
├─◆4. Lookup and Reference Functions
│ └─◇ 0401 Looking up information with VLOOKUP and HLOOKUP.srt
│ └─◇ 0402 Finding approximate matches with VLOOKUP.srt
│ └─◇ 0403 Finding exact matches with VLOOKUP.srt
│ └─◇ 0404 Nesting LOOKUP functions.srt
│ └─◇ 0405 Finding table-like information within a function with CHOOSE.srt
│ └─◇ 0406 Locating data with MATCH.srt
│ └─◇ 0407 Retrieving information by location with INDEX.srt
│ └─◇ 0408 Using MATCH and INDEX together.srt
├─◆5. Power Functions
│ └─◇ 0501 Tabulating information on a single criterion with COUNTIF, SUMIF, and AVERAGEIF.srt
│ └─◇ 0502 Tabulating information on multiple criteria with COUNTIFS, SUMIFS, and AVERAGEIFS.srt
├─◆6. Statistical Functions
│ └─◇ 0601 Finding the middle value with MEDIAN.srt
│ └─◇ 0602 Ranking data without sorting with RANK.srt
│ └─◇ 0603 Finding the magnitude data with LARGE and SMALL.srt
│ └─◇ 0604 Tabulating blank cells with COUNTBLANK.srt
├─◆7. Data Functions
│ └─◇ 0701 Understanding Excel date time capabilities in formulas.srt
│ └─◇ 0702 Identifying the day of the week with WEEKDAY.srt
│ └─◇ 0703 Counting working days with NETWORKDAYS.srt
│ └─◇ 0704 Determining a completion date with WORKDAY.srt
│ └─◇ 0705 Tabulating date time differences with DATEDIF.srt
├─◆8. Math Functions
│ └─◇ 0801 Working with rounding functions.srt
│ └─◇ 0802 Finding the remainder with MOD and using MOD with conditional formatting.srt
│ └─◇ 0803 Building random number generators with RAND and RANDBETWEEN.srt
│ └─◇ 0804 Converting a value between measurement systems with CONVERT.srt
│ └─◇ 0805 Using the powerful new AGGREGATE function to bypass errors and hidden data.srt
├─◆9. Array Formulas and Functions
│ └─◇ 0901 Extending formula capabilities with arrays.srt
│ └─◇ 0902 Counting unique entries in a range with an array formula.srt
│ └─◇ 0903 Determining frequency distributions with FREQUENCY.srt
│ └─◇ 0904 Flipping row column orientation with TRANSPOSE.srt
│ └─◇ 0905 Building analysis via regression techniques with TREND and GROWTH.srt
│ └─◇ 0906 Combining multiple functions in arrays.srt
├─◆10. Text Functions
│ └─◇ 1001 Locating and extracting data with FIND and MID.srt
│ └─◇ 1002 Extracting specific data with LEFT and RIGHT.srt
│ └─◇ 1003 Removing excess spaces with TRIM.srt
│ └─◇ 1004 Using CONCATENATE with functions.srt
│ └─◇ 1005 Adjusting case within cells with PROPER, UPPER, and LOWER.srt
│ └─◇ 1006 Adjusting character content with REPLACE and SUBSTITUTE.srt
│ └─◇ 1007 Reviewing additional text functions.srt
├─◆11. Financial Functions
│ └─◇ 1101 Calculating payments with PMT.srt
│ └─◇ 1102 Finding future values with FV.srt
│ └─◇ 1103 Determining total amount of future payments with PV.srt
├─◆12. Information Functions
│ └─◇ 1201 Working with the IS information functions.srt
│ └─◇ 1202 Using error-checking functions- ISERR, ISERROR, IFERROR.srt
├─◆13. Reference Functions
│ └─◇ 1301 Getting data from remote cells with OFFSET.srt
│ └─◇ 1302 Returning references with INDIRECT.srt
├─◆Conclusion
│ └─◇ Final thoughts.srt

【本字幕由ACELY.CN独家制作发布】


┃本套教程字幕包含中文字幕
┃中文字幕使用机器翻译,对翻译结果中不当内容不承担任何责任!
┃更多中文字幕请访问唯一发布站【ACELY.CN】
┃本站中文字幕未经允许一律严禁转载!


>>>>>>>【点我下载】<<<<<<<

标签:, ,

您的留言是我最大的支持!

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

※ 本站内容未经允许一律严禁转载!Lynda教程及字幕交流群:214645753
※ 本站文件统一解压密码:acely.cn 或 www.cgsub.com