Oreilly - Top 25 Excel Formulas
by Syed Raza | Publisher: Stone River eLearning | Release Date: May 2019 | ISBN: 10000SRESR06
Table of Contents
- Course Introduction
- Introduction and About the Instructor 00:02:14
- What will I Learn? 00:02:07
- Logical Functions
- AND and IF Functions 00:09:41
- IFERROR and XOR Functions 00:12:24
- 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
- Text Functions
- TEXT and CONCATENATE Functions 00:11:10
- PROPER-UPPER-LOWER-SUBSTITUTE Functions 00:10:13
- Lookup & Reference Function
- LOOKUP Function Lecture 00:04:58
- Working with Advanced VLOOKUP 00:12:17
- HLOOKUP-INDEX-MATCH Functions 00:17:45
- 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
- Course Conclusion
- Course Conclusion 00:02:37
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.