->
Oreilly - Top 25 Excel Formulas - 10000SRESR06
Oreilly - Top 25 Excel Formulas
by Syed Raza | Publisher: Stone River eLearning | Release Date: May 2019 | ISBN: 10000SRESR06


Table of Contents

  1. Course Introduction
    • Introduction and About the Instructor 00:02:14
    • What will I Learn? 00:02:07
  2. Logical Functions
    • AND and IF Functions 00:09:41
    • IFERROR and XOR Functions 00:12:24
  3. Financial Functions
    • PV and FV Functions 00:14:59
    • PMT-PPMT-PRICE-YIELD Functions 00:11:40
    • PRICE-COUPONDAYS-ACCRINT-ACCRINTM Functions 00:10:29
    • Depreciation 00:07:44
    • SLN-SYD-DB-DDB-VDB Functions 00:13:46
  4. Text Functions
    • TEXT and CONCATENATE Functions 00:11:10
    • PROPER-UPPER-LOWER-SUBSTITUTE Functions 00:10:13
  5. Lookup & Reference Function
    • LOOKUP Function Lecture 00:04:58
    • Working with Advanced VLOOKUP 00:12:17
    • HLOOKUP-INDEX-MATCH Functions 00:17:45
  6. Bonus Selection
    • Modifying Existing Templates 00:11:07
    • Copying Macros Between Workbooks 00:04:24
    • Working with External Data Sources 00:10:16
    • Exploring Tracking Changes Feature 00:11:51
  7. Course Conclusion
    • Course Conclusion 00:02:37
  8. Oreilly - Top 25 Excel Formulas


 TO MAC USERS: If RAR password doesn't work, use this archive program: 

RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


 TO WIN USERS: If RAR password doesn't work, use this archive program: 

Latest Winrar  and extract password protected files without error.


 Coktum   |  

Information
Members of Guests cannot leave comments.




rss