种子简介

种子名称： [FreeCourseSite.com] Udemy - Microsoft Excel - Advanced Excel Formulas & Functions
文件类型： 视频
文件数目： 96个文件
文件大小： 1.49 GB
收录时间： 2020-1-14 08:26
已经下载： 3次
资源热度： 246
最近下载： 2024-12-28 10:10

下载BT种子文件

下载Torrent文件(.torrent) 立即下载

磁力链接下载

magnet:?xt=urn:btih:805c5709ee5aa85c01f2b1ae19900c9602d4bb96&dn=[FreeCourseSite.com] Udemy - Microsoft Excel - Advanced Excel Formulas & Functions 复制链接到迅雷、QQ旋风进行下载，或者使用百度云离线下载。

喜欢这个种子的人也喜欢

种子包含的文件

[FreeCourseSite.com] Udemy - Microsoft Excel - Advanced Excel Formulas & Functions.torrent

1. Getting Started/1. Course Structure & Outline.mp412.32MB

1. Getting Started/3. BONUS Extra Homework Exercises.mp45.64MB

10. Badass Bonus Functions/1. Introduction.mp42.6MB

10. Badass Bonus Functions/2. The INDIRECT Function.mp430.17MB

10. Badass Bonus Functions/3. HYPERLINK as Awesome as it Sounds.mp414.17MB

10. Badass Bonus Functions/4. Tapping into Real-Time Data with WEBSERVICE & FILTERXML.mp471.78MB

10. Badass Bonus Functions/5. NEW Open Weather Map WEBSERVICE Demo.mp492.27MB

11. Wrapping Up/1. Conclusion & Next Steps.mp4678.25KB

2. Excel Formulas 101/1. Introduction.mp42.31MB

2. Excel Formulas 101/10. Fixed vs. Volatile Functions.mp47.51MB

2. Excel Formulas 101/12. HOMEWORK Formulas 101.mp41.81MB

2. Excel Formulas 101/2. The Formula Library & Auditing Tools.mp412.3MB

2. Excel Formulas 101/3. DEMO Evaluate Formula (not available for mac).mp44.16MB

2. Excel Formulas 101/4. Basic Formula Syntax.mp47.84MB

2. Excel Formulas 101/5. Fixed, Relative, & Mixed References.mp414.76MB

2. Excel Formulas 101/6. Common Errors & the IFERROR statement.mp419.07MB

2. Excel Formulas 101/7. Function, CTRL & ALT Shortcuts.mp419.04MB

2. Excel Formulas 101/8. BONUS Shortcuts for Mac Users.mp47.86MB

2. Excel Formulas 101/9. Creating Custom Data Validation Rules.mp49.17MB

3. Conditional Statements & Logical Operators/1. Introduction.mp42.48MB

3. Conditional Statements & Logical Operators/2. Anatomy of the IF Statement.mp416.86MB

3. Conditional Statements & Logical Operators/3. Nested IF Statements.mp416.04MB

3. Conditional Statements & Logical Operators/4. ANDOR Operators.mp428.21MB

3. Conditional Statements & Logical Operators/5. NOT vs. .mp411.37MB

3. Conditional Statements & Logical Operators/6. Fixing Errors with IFERROR.mp420.08MB

3. Conditional Statements & Logical Operators/7. Common IS Statements.mp420.92MB

3. Conditional Statements & Logical Operators/9. HOMEWORK Logical Operators.mp41.7MB

4. Statistical Functions/1. Introduction.mp41.82MB

4. Statistical Functions/11. HOMEWORK Statistical Functions.mp41.56MB

4. Statistical Functions/2. Basic Statistical Functions.mp414.75MB

4. Statistical Functions/3. SMALLLARGE & RANKPERCENTRANK.mp421.05MB

4. Statistical Functions/4. RAND() & RANDBETWEEN.mp46.32MB

4. Statistical Functions/5. The SUMPRODUCT Function.mp410.59MB

4. Statistical Functions/6. NEW SUMPRODUCT Demo.mp431.27MB

4. Statistical Functions/7. COUNTIFSSUMIFSAVERAGEIFS.mp414.15MB

4. Statistical Functions/8. PROJECT SHOWCASE Building a Basic Dashboard with COUNTIFS & SUMIFS.mp423.6MB

4. Statistical Functions/9. NEW Combining COUNTIF & SUMPRODUCT.mp473.14MB

5. LookupReference Functions/1. Introduction.mp42.13MB

5. LookupReference Functions/10. The MATCH Function.mp49.23MB

5. LookupReference Functions/11. Using INDEX & MATCH together.mp423.72MB

5. LookupReference Functions/12. Combining MATCH with VLOOKUP.mp426.65MB

5. LookupReference Functions/13. UPDATE VLOOKUP Correction.mp414.84MB

5. LookupReference Functions/14. The OFFSET Function.mp46.92MB

5. LookupReference Functions/15. Combining OFFSET with COUNTA to return a variable list.mp46.99MB

5. LookupReference Functions/16. PROJECT SHOWCASE Using OFFSET to create a dynamic scrolling chart.mp430.3MB

5. LookupReference Functions/18. HOMEWORK LookupReference Functions.mp42.48MB

5. LookupReference Functions/2. Working with Named Arrays.mp411.31MB

5. LookupReference Functions/3. ROWROWS & COLUMNCOLUMNS.mp49.55MB

5. LookupReference Functions/4. VLOOKUPHLOOKUP.mp421.22MB

5. LookupReference Functions/5. Joining Data with VLOOKUP.mp437.77MB

5. LookupReference Functions/6. Fixing Errors with IFERROR & VLOOKUP.mp415.2MB

5. LookupReference Functions/7. VLOOKUP Reference Array Options.mp440.16MB

5. LookupReference Functions/8. NEW Fuzzy Match Lookups.mp446.42MB

5. LookupReference Functions/9. The INDEX Function.mp46.16MB

6. Text Functions/1. Introduction.mp41.18MB

6. Text Functions/11. HOMEWORK Text Functions.mp42.28MB

6. Text Functions/2. UPPERLOWERPROPER & TRIM.mp421.17MB

6. Text Functions/3. The CONCATENATE Function (&).mp423.63MB

6. Text Functions/4. LEFTMIDRIGHT & LEN.mp416.94MB

6. Text Functions/5. TEXTVALUE.mp455.38MB

6. Text Functions/6. SEARCHFIND.mp431.06MB

6. Text Functions/7. Categorizing Data with IF(ISNUMBER(SEARCH)).mp433.61MB

6. Text Functions/8. Combining RIGHT, LEN, and SEARCH.mp441.87MB

6. Text Functions/9. BONUS The SUBSTITUTE Function.mp48MB

7. Date & Time Functions/1. Introduction.mp43.26MB

7. Date & Time Functions/10. PROJECT SHOWCASE Designing a Sample Budget Pacing Tool.mp426.1MB

7. Date & Time Functions/12. HOMEWORK Date & Time Functions.mp41.21MB

7. Date & Time Functions/2. DATEVALUE Your New BFF.mp413.96MB

7. Date & Time Functions/3. Date Formatting & Fill Series.mp48.65MB

7. Date & Time Functions/4. TODAY()NOW().mp45.4MB

7. Date & Time Functions/5. YEARMONTHDAY & HOURMINUTESECOND.mp47.88MB

7. Date & Time Functions/6. The EOMONTH Function.mp413.07MB

7. Date & Time Functions/7. The YEARFRAC Function.mp45.76MB

7. Date & Time Functions/8. WEEKDAY, WORKDAY & NETWORKDAYS.mp419.09MB

7. Date & Time Functions/9. The DATEDIF Function.mp410.12MB

8. Formula-Based Formatting/1. Introduction.mp42.8MB

8. Formula-Based Formatting/2. Creating, Editing & Managing Formula-Based Rules.mp412.07MB

8. Formula-Based Formatting/3. Highlighting Every Other Row Using the MOD function.mp414.96MB

8. Formula-Based Formatting/4. Formatting Cells Based on the Value of Another Cell.mp410.07MB

8. Formula-Based Formatting/5. Formatting Cells Using Statistical Functions.mp424.27MB

8. Formula-Based Formatting/6. Formatting Cells Using Text Functions & Logical Operators.mp420.57MB

8. Formula-Based Formatting/8. HOMEWORK Formula-Based Formatting.mp41.53MB

9. Array Formulas/1. Introduction.mp42.03MB

9. Array Formulas/10. Counting Characters Across Cells.mp45.51MB

9. Array Formulas/11. Creating a MAX IF Array Formula.mp49.22MB

9. Array Formulas/12. BONUS MAX IF with Multiple Criteria.mp417.45MB

9. Array Formulas/13. BONUS Using the Double Unary Operator (--).mp410.57MB

9. Array Formulas/15. HOMEWORK Array Functions.mp45.89MB

9. Array Formulas/2. Rules of Array Functions.mp48.79MB

9. Array Formulas/3. Pros & Cons of Array Functions.mp45.2MB

9. Array Formulas/4. Vertical, Horizontal, and 2-Dimensional Array Constants.mp412.71MB

9. Array Formulas/5. Using Array Constants in Formulas.mp47.11MB

9. Array Formulas/6. Named Array Constants.mp49.96MB

9. Array Formulas/7. The Transpose Function.mp413.56MB

9. Array Formulas/8. Linking Data Between Sheets Array vs. Non-Array Comparison.mp49.05MB

9. Array Formulas/9. Returning the X Largest Values in a Range.mp410.78MB