xyz

xyz軟體王

會員登錄
xyz 站內搜索 購物結帳 手動下單 問題反應 訂單查詢 訂購說明
您現在的位置:網站首頁 專業軟體光碟 綜合軟體 碟片詳情
商品编号: xdvd3975c
商品名稱: Lynda com Excel 2010 Advanced Formulas and Functions 英文發音 僅限電腦播放 CD
碟片數量: 1片
銷售價格: 100
瀏覽次數: 12142

轉載TXT文檔】  
您可能感興趣: xp 
您可能也喜歡:
xdvd0640d--Lick Library Learn To Play Free DVDR TUTORiAL D1 英文版 DVD
xdvd3136c--網絡訪問控制 SYMANTEC NETWORK ACCESS CONTROL v11.0.6 RU6 MP3 英文版 CD
xdvd4191d--roject standard 2010 x86 x64 簡體中文 DVD
xdvd2599c--vcs 2005 express 繁體中文 CD
xdvd2784c--素材辭典 Datacraft Sozaijiten Vol.230 Peoples Postures CD
Lynda com Excel 2010 Advanced Formulas and Functions 英文發音 僅限電腦播放 CD

Lynda.com 出品的時長達17小時05分的 Excel 2010: 高級公式和函數 視頻教程。由Dennis Taylor闡明了公式和Excel的一些幾乎有400個最具挑戰性的功能,還講述了怎樣最好的使用它。課程回顧了積木式函數,少數幾個關鍵快捷鍵用于加速Excel數據的使用。以及如何執行查找功能的高級搜索和數據檢索,計算制表數據,統計和數學函數,格式化文本函數數據與財務數據使用的高級公式。本教程附帶練習文件。


目錄:

Viewed Duration
01:49 Introduction
Welcome 01:25
Using the exercise files 00:24
47:12 1. Formula and Function Tips and Shortcuts
Using the entire row/column references 05:43
Copying column formulas instantly 04:35
Converting formulas to values with a simple drag 05:10
Creating 3D formulas to gather data from multiple sheets 05:17
Updating values without formulas 04:25
Displaying and highlighting formulas 07:15
Simplifying debugging formulas 06:29
Enhancing readability with range names 08:18
22:32 2. Formula and Function Tools
Reviewing function basics 07:12
Using and extending AutoSum 04:55
Using absolute and relative references 04:52
Using mixed references 05:33
16:39 3. IF and Related Functions
Exploring IF logical tests and using relational operators 04:43
Creating and expanding the use of nested IF statements 04:47
Using the AND, OR, and NOT functions with IF to create compound logical tests 07:09
41:01 4. Lookup and Reference Functions
Looking up information with VLOOKUP and HLOOKUP 04:27
Finding approximate matches with VLOOKUP 06:22
Finding exact matches with VLOOKUP 04:21
Nesting LOOKUP functions 05:51
Finding table-like information within a function with CHOOSE 03:51
Locating data with MATCH 05:03
Retrieving information by location with INDEX 04:51
Using MATCH and INDEX together 06:15
12:27 5. Power Functions
Tabulating information on a single criterion with COUNTIF, SUMIF, and AVERAGEIF 04:49
Tabulating information on multiple criteria with COUNTIFS, SUMIFS, and AVERAGEIFS 07:38
11:35 6. Statistical Functions
Finding the middle value with MEDIAN 01:35
Ranking data without sorting with RANK 04:50
Finding the magnitude data with LARGE and SMALL 01:46
Tabulating blank cells with COUNTBLANK 03:24
23:27 7. Data Functions
Understanding Excel date/time capabilities in formulas 07:18
Identifying the day of the week with WEEKDAY 06:02
Counting working days with NETWORKDAYS 03:05
Determining a completion date with WORKDAY 02:24
Tabulating date/time differences with DATEDIF 04:38
25:36 8. Math Functions
Working with rounding functions 08:03
Finding the remainder with MOD and using MOD with conditional formatting 04:42
Building random number generators with RAND and RANDBETWEEN 04:42
Converting a value between measurement systems with CONVERT 03:07
Using the powerful new AGGREGATE function to bypass errors and hidden data 05:02
27:16 9. Array Formulas and Functions
Extending formula capabilities with arrays 07:12
Counting unique entries in a range with an array formula 04:46
Determining frequency distributions with FREQUENCY 03:06
Flipping row/column orientation with TRANSPOSE 04:38
Building analysis via regression techniques with TREND and GROWTH 03:07
Combining multiple functions in arrays 04:27
36:11 10. Text Functions
Locating and extracting data with FIND and MID 06:18
Extracting specific data with LEFT and RIGHT 03:02
Removing excess spaces with TRIM 05:42
Using CONCATENATE with functions 04:24
Adjusting case within cells with PROPER, UPPER, and LOWER 04:17
Adjusting character content with REPLACE and SUBSTITUTE 05:56
Reviewing additional text functions 06:32
13:30 11. Financial Functions
Calculating payments with PMT 04:34
Finding future values with FV 04:03
Determining total amount of future payments with PV 04:53
11:13 12. Information Functions
Working with the IS information functions 04:42
Using error-checking functions: ISERR, ISERROR, IFERROR 06:31
14:29 13. Reference Functions
Getting data from remote cells with OFFSET 04:46
Returning references with INDIRECT 09:43
00:41 Conclusion
Final thoughts 00:41
站內搜索
     
購物清單
熱門關鍵字
程薇   
上學期   
樂學網   
嫩模   
李祥   
祝欲   
劉明彰   
張凡   
張皓   
劉逸   
莊柏   
TKB   
xyz藍光   
xyz志光   
點線面   
KO會考   
口袋書   
會考ING   
建弘   
103年   
易經   
李居明   
占卜   
姓名學   
蘇民峰   
面相   
風水   
六爻   
八字   
舒淇   
賴思澐   
賴瀅羽   
黑澀會   
何欣純   
李宗瑞   
素材   
鼎甲   
何嘉仁   
卡通   
畫畫書   
填色本   
adult   
xp   
音樂MP3   
全領域   
全年級   
97年   
電影版   
6年級   
林晟   
馬蓋先   
NOD32   
SketchUp   
ImTOO   
SPSS   
PAPAGO   
Max   
3ds   
SolidWorks   
Nero   
鋼鐵人   
Wildfire   
Engineer   
PTC   
powerdvd   
YOYO   
自拍   
魔法24   
葉問   
flash   
photoshop   
AUTOCAD   
譯典通   
正航   
迪士尼   
微軟   
DVD合輯   
題庫   
相聲   
謝孟媛   
陳巃羽   
野馬   
高昇   
建宏   
金安   
全都會   
北北基   
Siemens   
翰林   
康軒   
Office   
Microsoft   
幼教   
windows   
巧連智   
下學期   
iPod   
iPAD   
鼎文   
高考   
知識達   
sitemap 知識 軟體王 wiki xyz xyz xyz xyz xyz