Graduate Certificate in Excel for Investment Portfolio Analysis
-- ViewingNowThe Graduate Certificate in Excel for Investment Portfolio Analysis is a comprehensive course that empowers learners with essential skills in investment analysis using Excel. This program is crucial in today's data-driven finance industry, where the ability to analyze and interpret complex financial data is highly sought after.
3,390+
Students enrolled
GBP £ 140
GBP £ 202
Save 44% with our special offer
ใใฎใณใผในใซใคใใฆ
100%ใชใณใฉใคใณ
ใฉใใใใงใๅญฆ็ฟ
ๅ ฑๆๅฏ่ฝใช่จผๆๆธ
LinkedInใใญใใฃใผใซใซ่ฟฝๅ
ๅฎไบใพใง2ใถๆ
้ฑ2-3ๆ้
ใใคใงใ้ๅง
ๅพ ๆฉๆ้ใชใ
ใณใผใน่ฉณ็ดฐ
โข Excel Basics for Financial Analysis: Introduction to Excel, basic functions, formulas, and formatting for financial analysis.
โข Data Management in Excel: Data importing, cleaning, and management for financial data in Excel.
โข Advanced Excel Functions: Advanced Excel functions for financial analysis, such as IF, VLOOKUP, HLOOKUP, and GOAL SEEK.
โข Excel Data Analysis Tools: PivotTables, data tables, and data analysis tools for financial analysis in Excel.
โข Financial Modeling in Excel: Building financial models, including discounted cash flow, sensitivity analysis, and scenario analysis.
โข Excel for Portfolio Management: Portfolio management techniques, such as optimization, risk analysis, and performance measurement in Excel.
โข Excel for Investment Analysis: Time value of money, bond and stock valuation, and investment performance analysis in Excel.
โข Excel for Risk Management: Risk management techniques, such as value at risk, expected shortfall, and stress testing in Excel.
โข Excel Dashboards and Visualization: Creating interactive and informative dashboards and visualizations for financial analysis in Excel.
ใญใฃใชใขใใน
ๅ ฅๅญฆ่ฆไปถ
- ไธป้กใฎๅบๆฌ็ใช็่งฃ
- ่ฑ่ชใฎ็ฟ็ๅบฆ
- ใณใณใใฅใผใฟใผใจใคใณใฟใผใใใใขใฏใปใน
- ๅบๆฌ็ใชใณใณใใฅใผใฟใผในใญใซ
- ใณใผในๅฎไบใธใฎ็ฎ่บซ
ไบๅใฎๆญฃๅผใช่ณๆ ผใฏไธ่ฆใใขใฏใปใทใใชใใฃใฎใใใซ่จญ่จใใใใณใผในใ
ใณใผใน็ถๆณ
ใใฎใณใผในใฏใใญใฃใชใข้็บใฎใใใฎๅฎ็จ็ใช็ฅ่ญใจในใญใซใๆไพใใพใใใใใฏ๏ผ
- ่ชๅฏใใใๆฉ้ขใซใใฃใฆ่ชๅฎใใใฆใใชใ
- ่ชๅฏใใใๆฉ้ขใซใใฃใฆ่ฆๅถใใใฆใใชใ
- ๆญฃๅผใช่ณๆ ผใฎ่ฃๅฎ
ใณใผในใๆญฃๅธธใซๅฎไบใใใจใไฟฎไบ่จผๆๆธใๅใๅใใพใใ
ใชใไบบใ ใใญใฃใชใขใฎใใใซ็งใใกใ้ธใถใฎใ
ใฌใใฅใผใ่ชญใฟ่พผใฟไธญ...
ใใใใ่ณชๅ
ใณใผในๆ้
- ้ฑ3-4ๆ้
- ๆฉๆ่จผๆๆธ้ ้
- ใชใผใใณ็ป้ฒ - ใใคใงใ้ๅง
- ้ฑ2-3ๆ้
- ้ๅธธใฎ่จผๆๆธ้ ้
- ใชใผใใณ็ป้ฒ - ใใคใงใ้ๅง
- ใใซใณใผในใขใฏใปใน
- ใใธใฟใซ่จผๆๆธ
- ใณใผในๆๆ
ใณใผในๆ ๅ ฑใๅๅพ
ไผ็คพใจใใฆๆฏๆใ
ใใฎใณใผในใฎๆฏๆใใฎใใใซไผ็คพ็จใฎ่ซๆฑๆธใใชใฏใจในใใใฆใใ ใใใ
่ซๆฑๆธใงๆฏๆใใญใฃใชใข่จผๆๆธใๅๅพ