Udemy - Microsoft Excel Formulas and Functions - Learn Fast and S...

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1 - Introduction to Excel Functions and Formulas
• 1. What Are Formulas and Functions.mp4 (41.6 MB)
• 2. Structure of an Excel Formula.mp4 (137.9 MB)
• 3. Relative, Absolute, and Mixed References.mp4 (58.1 MB)
• 4. Tips for Writing Efficient Formulas.mp4 (25.3 MB)
• 5. Excel Formula Errors and How to Handle Them.mp4 (51.1 MB)
10 - Dynamic Array Functions (Excel 365 2021)
• 35. FILTER, SORT, SORTBY.mp4 (36.8 MB)
• 36. UNIQUE, SEQUENCE, RANDARRAY.mp4 (64.2 MB)
• 37. Working with Spill Ranges.mp4 (45.6 MB)
2 - Basic Excel Functions
• 6. SUM, AVERAGE, MIN, MAX.mp4 (51.1 MB)
• 7. COUNT, COUNTA, COUNTBLANK.mp4 (55.1 MB)
• 8. Basic Cell Referencing Techniques.mp4 (45.3 MB)
• 9. AutoSum and Quick Calculations.mp4 (33.5 MB)
3 - Logical Functions
• 10. IF Statements Basic and Nested.mp4 (52.3 MB)
• 11. AND, OR, NOT.mp4 (63.5 MB)
• 12. IFERROR and ISERROR.mp4 (26.4 MB)
• 13. IFS Function (Excel 2016+).mp4 (41.5 MB)
4 - Text Functions
• 14. CONCATENATE and TEXTJOIN.mp4 (44.7 MB)
• 15. LEFT, RIGHT, MID.mp4 (36.7 MB)
• 16. VALUE, TEXT, REPT.mp4 (74.4 MB)
5 - Date and Time Functions
• 17. TODAY(), NOW(), DAY(), MONTH(), YEAR().mp4 (29.1 MB)
• 18. WEEKDAY(), NETWORKDAYS(), WORKDAY().mp4 (50.9 MB)
• 19. DATEDIF(), EDATE(), EOMONTH().mp4 (49.7 MB)
6 - Lookup and Reference Functions
• 20. VLOOKUP, HLOOKUP.mp4 (44.8 MB)
• 21. INDEX and MATCH Combo (Advanced Lookup).mp4 (37.2 MB)
• 22. XLOOKUP (Excel 365 2021).mp4 (36.7 MB)
• 23. CHOOSE, OFFSET, INDIRECT.mp4 (58.4 MB)
7 - Math and Statistical Functions
• 24. ROUND, ROUNDUP, ROUNDDOWN.mp4 (78.2 MB)
• 25. CEILING, FLOOR, INT, MOD.mp4 (53.3 MB)
• 26. RANK, LARGE, SMALL.mp4 (58.6 MB)
• 27. RAND, RANDBETWEEN.mp4 (58.1 MB)
8 - Advanced Formula Techniques
• 28. Array Formulas (Legacy and Dynamic Arrays).mp4 (44.3 MB)
• 29. Named Ranges for Dynamic Formulas.mp4 (74.9 MB)
• 30. Nested Functions Best Practices.mp4 (51.4 MB)
• 31. Formula Auditing and Troubleshooting Tools.mp4 (47.4 MB)
9 - Financial Functions
• 32. PMT, RATE, NPV, FV, PV.mp4 (60.5 MB)
• 33. IRR, SLN, DB, DDB.mp4 (58.6 MB)
• 34. Loan Amortization Table with Formulas.mp4 (50.1 MB)
• Bonus Resources.txt (0.1 KB)