【Lynda】Excel 2010: Advanced Formulas and Functions【CHN】中英文字幕[SRT]
==========教程信息=====================================================
教程名称：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】
┃本站中文字幕未经允许一律严禁转载！
┗