Udemy - Finance and Excel for Beginners - Learn with Real Example...

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1 - Introduction
• 1 -Introduction.mp4 (5.5 MB)
2 - Get going with Concepts of Finance !
• 1 -Understanding and analysing the income statement.mp4 (103.9 MB)
• 10 -Concept of Terminal value and Using EV EBITDA multiple to compute it.mp4 (21.5 MB)
• 11 -Applying finance concepts using excel.mp4 (4.8 MB)
• 2 -Reading and analysing a Balance Sheet.mp4 (70.0 MB)
• 3 -Understanding and evaluating a cash flow statement.mp4 (58.7 MB)
• 4 -Basics of working capital of a business.mp4 (120.6 MB)
• 5 -Time value of money and Discounted Cash Flow Valuation.mp4 (44.2 MB)
• 6 -Concept of Enterprise Value, Free Cash flows (FCFE,FCFF).mp4 (45.8 MB)
• 7 -Calculating a company's weighted average cost of capital (WACC).mp4 (97.7 MB)
• 8 -Net present value of cash flows (NPV) and internal rate of return (IRR).mp4 (58.2 MB)
• 9 -Concept of valuation multiples.mp4 (43.0 MB)
3 - Excel for 1st time users (this section is for you if you have never used Excel)
• 1 -Opening a fresh excel sheet.mp4 (20.2 MB)
• 2 -Understanding the Structure of an excel sheet.mp4 (27.4 MB)
• 3 -03.xlsx (10.4 KB)
• 3 -Entering data in excel and data formats in excel.mp4 (79.9 MB)
• 4 -04.xlsx (10.7 KB)
• 4 -Formatting data in an excel sheet.mp4 (105.0 MB)
• 5 -05.xlsx (13.1 KB)
• 5 -Learn to copy and paste, use data validation and insert comments.mp4 (207.8 MB)
4 - Get started with Excel Essentials
• 1 -01 and 02.xlsx (13.3 KB)
• 1 -Learn basic numerical formulae.mp4 (56.8 MB)
• 2 -Learn more numerical formulae in Excel !.mp4 (77.9 MB)
• 3 -03.xlsx (11.3 KB)
• 3 -Learn to use Paste Special and Trace Dependents and Precedents in an excel sheet.mp4 (111.3 MB)
• 4 -04.xlsx (14.7 KB)
• 4 -Learn to compute growth rates, average, median, maximums and minimums of data.mp4 (138.2 MB)
• 5 -05.xlsx (19.0 KB)
• 5 -Use Date related functions in excel.mp4 (67.2 MB)
• 6 -06.xlsx (10.4 KB)
• 6 -Learn to use functions that perform Logical Operations.mp4 (134.1 MB)
• 7 -07.xlsx (13.7 KB)
• 7 -Learn More Logical functions in Excel !.mp4 (247.6 MB)
• 8 -08.xlsx (13.6 KB)
• 8 -Tabulate data, sort, filter and analyse large amounts of data.mp4 (244.7 MB)
5 - Unleash Ultimate Excel Power !
• 1 -09.xlsx (27.6 KB)
• 1 -Learn to use Lookup functions in excel.mp4 (277.7 MB)
• 2 -10.xlsx (35.3 KB)
• 2 -Use Pivot Tables in Excel and the Subtotal function.mp4 (202.0 MB)
• 3 -11.xlsx (11.7 KB)
• 3 -Compute EMI for your loan; Perform scenario analysis using What If & Goal Seek.mp4 (124.3 MB)
• 4 -12.xlsx (12.5 KB)
• 4 -Use Data Tables to perform Scenario analyses.mp4 (61.8 MB)
• 5 -13.xlsx (16.0 KB)
• 5 -Use macros for repetitive tasks; Build linked excels with circular references.mp4 (141.7 MB)
• 6 -14.xlsx (28.0 KB)
• 6 -Create charts to easily read and analyse large volumes of data.mp4 (542.2 MB)
6 - Concluding Remarks and Next steps
• 1 -Concluding remarks.mp4 (5.0 MB)
• Bonus Resources.txt (0.1 KB)