Duration : 17 Hours 310 Lessons Size : 9.66 GB (4 PART DOWNLOAD) Table of Contents: 1. Welcome! Course Introduction 2. Microsoft Excel - Quick Introduction 3. Microsoft Excel - Useful Tools 4. Microsoft Excel - Best Practices That Will Make a Difference 5. Microsoft Excel - Beginner, Intermediate & Advanced Functions 6. Microsoft Excel - Financial Functions in Excel 7. Microsoft Excel - Practical Exercise Build a P&L From Scratch 8. Microsoft Excel - Building Professional Charts in Excel 9. Microsoft Excel - Creating Complete Professional Charts from Scratch 10. Microsoft Excel - Working with Pivot Tables in Excel 11. Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting 12. Modeling in Excel - Building a Complete 3-statement Model 13. Modeling in Excel - Let's Build a Flexible Model with Multiple Scenarios 14. Modeling in Excel - We Are Almost There! Completing the 3-Statement Model 15. Accounting - Introduction to Accounting & Bookkeeping 16. Accounting - Types of Revenues, Costs, Assets, and Liabilities 17. Accounting - Revenue Recognition 18. Accounting - Cost Recognition 19. Accounting - Understanding the Big Picture Why, What, When, and How Much 20. Accounting - The Core Principles of Accounting 21. Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand 22. Accounting - The Importance of Timing 23. Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis 24. Advanced Accounting - Trade Receivables 25. Advanced Accounting - Inventory 26. Advanced Accounting - Fixed Assets 27. Advanced Accounting - Trade Payables 28. Advanced Accounting - Financial Liabilities 29. Advanced Accounting - Leasing Liabilties 30. Advanced Accounting - Using Leverage 31. Advanced Accounting - Raising Equity, Types of Equity, and Dividend Payments 32. Financial Statement Analysis - An Introduction 33. Financial Statement Analysis - Subtleties 34. Financial Statement Analysis - Practical Case Study Analyzing P&G's Financials 35. Financial Statement Analysis - Tesla Exercise 36. Working Capital Management 37. Fundamentals of Business & Financial Analysis 38. Finance 101 - The Time Value of Money and Interest Rate Components 39. Finance 101 - The Value of Cash Flows with Different Timing 40. Finance 101 - Loan Calculations 41. Capital Budgeting - Basic Notions 42. Capital Budgeting - A Complete Case Study 43. Tesla Practical Case Study - Building a Financial Planning Model 44. PowerPoint - Introduction to PowerPoint 45. PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User 46. Bonus e Books
