# Top 25 Microsoft Excel Advanced Formulas: Hands-on Tutorial

#### Syed Raza, Web Developer | Entrepreneur-CEO www.claydesk.com

Play Speed
• 0.5x
• 1x (Normal)
• 1.25x
• 1.5x
• 2x
19 Lessons (3h 2m)
• 1. Abouttheinstructor HB

2:17
• 2. Whatwillilearn final HB

2:07
• 3. Logical AND and IF formula HB

9:43
• 4. Logical IFERROR and XOR formula FULL AND FINAL6 HB

12:23
• 5. PV and FV formula HB

14:59
• 6. PMT PPMT PRICE YIELD formulas HB

11:40
• 7. PRICE ACCRINT ACCRINTM COUPONDAYS REAL WORLD BOND EVALUATION HB

10:28
• 8. DEPRECIATION Lecture HB

7:43
• 9. SLN SYD DB DDB VDB Depreciation formulas HB

13:46
• 10. TEXT and CONCATENATION formula HB

11:09
• 11. PROPER UPPER LOWER case and SUBSTITUTE formula final HB

10:13
• 12. LOOKUP VLOOKUP HLOOKUP MATCH INDEX Formulas Lecture slides HB

4:58
• 13. LOOKUP VLOOKUP HLOOKUP MATCH INDEX Formulas Tutorial HB

12:17
• 14. HLOOKUP MATCH INDEX Formulas Tutorial HB

17:45
• 15. Modifying templates HB

11:06
• 16. Copying macros between workbooks HB

4:24
• 17. External data HB

10:15
• 18. Tracking changesnew HB

11:50
• 19. Conclusion final final HB

2:33

## About This Class

The old 80/20 rule for software—that 80% of a program’s users use only 20% of a program’s features—doesn’t apply to Microsoft Excel. Instead, this program probably operates under what could be called the 95/5 rule: Ninety-five percent of Excel users use a mere 5% of the program’s power!

I have designed this practical course to give you the ability to master the Top 25 Microsoft Excel formulas with real world examples, by demystifying the building of worksheet formulas, and presenting the most useful Excel functions in an accessible and jargon-free manner.