Postgraduate Certificate in Financial Analysis Using Excel
-- ViewingNowThe Postgraduate Certificate in Financial Analysis Using Excel is a comprehensive course that equips learners with critical skills in financial analysis, utilizing the powerful capabilities of Excel. This certification is essential in today's data-driven world, where financial analysts are increasingly relied upon to provide data-supported insights for strategic decision-making.
2,030+
Students enrolled
GBP £ 140
GBP £ 202
Save 44% with our special offer
ě´ ęłźě ě ëí´
100% ě¨ëźě¸
ě´ëěë íěľ
ęłľě ę°ëĽí ě¸ěŚě
LinkedIn íëĄíě ěśę°
ěëŁęšě§ 2ę°ě
죟 2-3ěę°
ě¸ě ë ěě
ë기 ę¸°ę° ěě
ęłźě ě¸ëśěŹí
⢠Financial Modeling with Excel: This unit will cover the basics of financial modeling, including building financial statements, creating cash flow projections, and analyzing financial data using Excel.
⢠Advanced Excel Functions for Financial Analysis: This unit will delve into the more complex Excel functions, such as statistical and financial functions, and how to use them to perform advanced financial analysis.
⢠Time Value of Money (TVM) in Excel: This unit will teach students how to calculate the time value of money using Excel, including calculating present and future values, net present value, and internal rate of return.
⢠Risk Analysis and Simulation in Excel: This unit will cover how to use Excel to perform risk analysis and simulation, including sensitivity analysis, scenario analysis, and Monte Carlo simulation.
⢠Data Visualization and Dashboard Creation in Excel: This unit will teach students how to use Excel to create data visualizations and dashboards, enabling them to effectively communicate financial results and trends.
⢠Advanced Data Analysis in Excel: This unit will cover how to use Excel to perform advanced data analysis, including regression analysis, correlation analysis, and time series analysis.
⢠Corporate Finance and Valuation in Excel: This unit will cover how to use Excel to perform corporate finance and valuation analysis, including calculating enterprise value, equity value, and cost of capital.
⢠Financial Statement Analysis in Excel: This unit will teach students how to use Excel to analyze financial statements, including calculating financial ratios, performing trend analysis, and identifying financial red flags.
⢠Mergers, Acquisitions, and Leveraged Buyouts in Excel: This unit will cover how to use Excel to analyze mergers, acquisitions, and leveraged buyouts, including performing deal structuring, financial modeling, and valuation analysis.
⢠Capital Budgeting and Investment Decision Making in Excel: This unit will teach students how to use Excel to make capital budgeting and investment decision, including calculating net present value, internal rate of return, and payback period.
Note: The sequence and names of the
ę˛˝ë Ľ 경ëĄ
ě í ěęą´
- 죟ě ě ëí 기본 ě´í´
- ěě´ ě¸ě´ ëĽěë
- ěť´í¨í° ë° ě¸í°ëˇ ě ꡟ
- 기본 ěť´í¨í° 기ě
- ęłźě ěëŁě ëí íě
ěŹě ęłľě ěę˛Šě´ íěíě§ ěěľëë¤. ě ꡟěąě ěí´ ě¤ęłë ęłźě .
ęłźě ěí
ě´ ęłźě ě ę˛˝ë Ľ ę°ë°ě ěí ě¤ěŠě ě¸ ě§ěęłź 기ě ě ě ęłľíŠëë¤. ꡸ę˛ě:
- ě¸ě ë°ě 기ę´ě ěí´ ě¸ěŚëě§ ěě
- ęśíě´ ěë 기ę´ě ěí´ ęˇě ëě§ ěě
- ęłľě ě겊ě ëł´ěě
ęłźě ě ěąęłľě ěźëĄ ěëŁí늴 ěëŁ ě¸ěŚě뼟 ë°ę˛ ëŠëë¤.
ě ěŹëë¤ě´ ę˛˝ë Ľě ěí´ ě°ëŚŹëĽź ě ííëę°
댏롰 ëĄëŠ ě¤...
ě죟 돝ë ě§ëŹ¸
ě˝ě¤ ěę°ëŁ
- 죟 3-4ěę°
- 쥰기 ě¸ěŚě ë°°ěĄ
- ę°ë°Ší ëąëĄ - ě¸ě ë ě§ ěě
- 죟 2-3ěę°
- ě 기 ě¸ěŚě ë°°ěĄ
- ę°ë°Ší ëąëĄ - ě¸ě ë ě§ ěě
- ě 체 ě˝ě¤ ě ꡟ
- ëě§í¸ ě¸ěŚě
- ě˝ě¤ ěëŁ
ęłźě ě ëł´ ë°ę¸°
íěŹëĄ ě§ëś
ě´ ęłźě ě ëšěŠě ě§ëśí기 ěí´ íěŹëĽź ěí ě˛ęľŹě뼟 ěě˛íě¸ě.
ě˛ęľŹěëĄ ę˛°ě ę˛˝ë Ľ ě¸ěŚě íë
