The Complete Advanced Financial Analyst Course 2024

سرفصل های دوره

Excel, Data and Financial Statement Analysis, Business Analysis, Profitability, Stability and Performance Assessment

1 - Introduction to Financial Analysis Course 101

1 - Welcome Course Overview

2 - What is Ms Excel

3 - Concept of Microsoft Excel

4 - Financial Analysis with MS Excel

2 - Fundamental of Ms Excel

5 - Excel Spreadsheet and Workbook

6 - Data Entry and Shortcuts

7 - Copy Cut and Paste Formats and Dynamics

8 - Excel Formulas

3 - Excel Features for Financial Analysis

9 - Min and Xlook up Function

10 - Max and Xlook up Function

11 - Count if Function

12 - Count ifs Function

13 - Hlook up

14 - Vlook up

15 - Alignment and Borders

16 - Excel Range and Named Cells

17 - Pivot Table

18 - Charts and Graphs

19 - Relative and Absolute Cell References

20 - Excel Hyperlinks

21 - Excel Slicers

4 - Project Financial Analysis on ABC Business Financial

22 - Data Organization

23 - Data Cleaning and Validation

5 - Revenue and Profit Analysis

24 - Gross Profit

24 - Gross-Profit.pdf

25 - Operating Income

25 - Operating-Income.pdf

26 - Net Income

26 - Net-Income.pdf

6 - Expense Management

27 - Total Expense

7 - Efficiency Metrics

28 - Gross Profit Margin

28 - Gross-Profit-Margin-2.pdf

29 - Operating Margin

29 - Operating-Margin.pdf

30 - Net Profit Margin

30 - Net-Profit-Margin.pdf

31 - Inventory Turn Over

31 - Inventory-Turnover.pdf

32 - Accounts-Receivable-Turnover.pdf

32 - Account Receivable Turnover

8 - Liquidity Analysis

33 - Current Ratio

33 - Current-Ratio.pdf

34 - Quick Ratio

34 - Quick-Ratio.pdf

35 - Cash Ratio

35 - Cash-Ratio.pdf

9 - Solvency Analysis

36 - DebttoEquity Ratio

36 - Debt-to-equity.pdf

37 - Debt Ratio

37 - Debt-Ratio.pdf

38 - Equity Ratio

38 - Equity-Ratio.pdf

10 - Risk Analysis

39 - Interest Coverage Ratio

39 - Interest-Coverage-Ratio.pdf

40 - Cash Flow Coverage Ratio

40 - Cash-Flow-Coverage-Ratio.pdf

11 - Profit Margin

41 - Gross Profit Margin

41 - Gross-Profit-Margin-2.docx

42 - Operating Margin

42 - Operating-Margin.pdf

43 - Net Profit Margin

43 - Net-Profit-Margin.pdf

12 - Return on Investment

44 - Return on Asset ROA

44 - Return-on-Assets.pdf

45 - Return on Equity ROE

45 - Return-on-Equity.pdf

46 - Return on Investment

46 - Return-on-Investment.pdf

13 - Time Series Analysis

47 - Revenue Trend

47 - Revenue-Trend.pdf

48 - Net Profit Trend

48 - Net-Income-Trend.pdf

49 - Gross Profit Trend

49 - Gross-Profit-Trend.pdf

50 - Asset Liability Trend

14 - Data Visualization

51 - Financial Data Visualization

52 - Data Presentation

189,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy