AI-Enhanced Financial Analysis
Advanced · 2h 30min · 9 modules. Use generative AI, Excel and Python to run ratio, horizontal/vertical, correlation and time-series analysis on a 5-year Egyptian company case — with validation, governance and a capstone.
| 担当者 | Rehaf Foula |
|---|---|
| 最終更新 | 2026/10/24 |
| 完了時間 | 12 時間 5 分 |
| メンバー | 1 |
-
Module 1 — Introduction4レッスン · 32 分
-
Getting Started: Your Guided and Extended Paths新規 10 xp
-
無料プレビュー 新規 10 xp
-
Demonstration and Guidelines for Safe AI Use新規 10 xp
-
Case Dataset and Copy-Ready Materials新規
-
-
Module 2 — What Is AI? The Basics2レッスン · 17 分
-
Artificial Intelligence: From Machine Learning to Generative Finance新規 10 xp
-
Interactive Exercise: Choose the Right Tool and Control新規 10 xp
-
-
Module 3 — Optional: Custom GPT Design4レッスン · 41 分
-
Optional Resources: Assistant Design Pack新規
-
Set Up a Custom GPT or Claude Project for Financial Analysis新規 10 xp
-
Demonstration: Build and Test the NDCP Analysis Assistant新規 10 xp
-
Optional Reflection: Would You Release This Assistant?新規 10 xp
-
-
Module 4 — AI-Powered Financial Ratio Analysis9レッスン · 1 時間 24 分
-
Ratio Analysis Resources and Prompt Pack新規
-
Format Financial Data for Reliable AI Analysis新規 10 xp
-
Comprehend and Validate Data Before Calculation新規 10 xp
-
Calculate Liquidity and Solvency Ratios新規 10 xp
-
Continue with Profitability and Efficiency Ratios新規 10 xp
-
Complete the Analysis with DuPont and Integrated Interpretation新規 10 xp
-
Create Decision-Useful Ratio Charts新規 10 xp
-
Prompt Engineering for Ratio Tables and Charts新規 10 xp
-
Chapter Summary: Ratio Analysis Control Sheet新規 10 xp
-
-
Module 5 — Advanced Vertical and Horizontal Analysis9レッスン · 1 時間 23 分
-
Statement Analysis Downloads and Templates新規
-
Use Generative AI to Analyse Financial Statements新規 10 xp
-
Horizontal Analysis: Change Across Time新規 10 xp
-
Human-Readable vs Machine-Readable Financial Data新規 10 xp
-
Visualise Statement Trends Without Distortion新規 10 xp
-
Build the Correlation Matrix新規 10 xp
-
Review Correlations with Professional Scepticism新規 10 xp
-
Vertical Analysis: Common-Size Statements新規 10 xp
-
Combine Vertical and Horizontal Analysis新規 10 xp
-
-
Module 6 — Time Series Analysis9レッスン · 1 時間 22 分
-
Time-Series Data and Forecasting Pack新規
-
Time Series: Trend, Seasonality, Cycles, and Noise新規 10 xp
-
Seasonality in Egyptian FMCG: Ramadan and Summer Effects新規 10 xp
-
Refresher: Moving Averages, Decomposition, and Stationarity新規 10 xp
-
🎬 Augmented Dickey-Fuller (ADF) Test Explained with SAS + Interpretation新規
-
Create a Linear Regression Forecast with AI新規 10 xp
-
Interact with Forecast Data and Challenge the Model新規 10 xp
-
Worked Exercise: Forecast with Linear Regression新規 10 xp
-
Interactive Exercise: Approve, Revise, or Reject the Forecast新規 10 xp
-
-
Module 7 — Using Generative AI for Finance in the Real World5レッスン · 45 分
-
AI in FP&A and Budgeting新規 10 xp
-
AI-Assisted Variance Analysis新規 10 xp
-
Credit and Risk Assessment with Generative AI新規 10 xp
-
Governance, Data Privacy, and Sustainable Tool Adoption新規 10 xp
-
Reflection: Where Will AI Add Value in Your Finance Team?新規 10 xp
-
-
Module 8 — Conclusion2レッスン · 14 分
-
Course Summary: The Controlled AI Analysis Workflow新規 10 xp
-
Conclusion and Next Steps: Keep the Method, Adapt the Tool新規 10 xp
-
-
Module 9 — Final Assessment2レッスン · 5 時間 27 分
-
Final Exam: Advanced AI-Enhanced Financial Analysis新規 10 xp
-
Capstone Assignment: AI-Assisted Financial Analysis of NDCP新規
-
Course overview
An advanced professional course for FP&A professionals, finance and accounting leaders and analysts in Egypt and the Middle East. Using a fictional listed Egyptian FMCG company with five years of EGP financial statements, you will apply generative AI (ChatGPT and Claude), Excel and Python to ratio analysis, horizontal and vertical analysis, correlation analysis, time-series forecasting, FP&A and risk assessment, while keeping human validation and governance at the centre.
Learning objectives
- Understand the role of AI in financial analysis, and where human judgement remains essential
- Perform and validate AI-powered ratio analysis: liquidity, solvency, profitability, efficiency and DuPont
- Conduct advanced vertical and horizontal analysis, visualisation and correlation analysis
- Build, test and challenge time-series and linear-regression forecasts with AI, Excel and Python
- Apply generative AI safely to budgeting, variance analysis, credit and risk assessment
- Adapt your workflow as AI tools evolve
Who should take this course
FP&A professionals, finance and accounting leaders, and anyone with solid finance and accounting knowledge who wants to work faster and better with AI.
Prerequisites
Accounting fundamentals, reading financial statements, financial analysis fundamentals, critical thinking, basic maths and statistics.
Course details
- Level: Advanced
- Guided learning time: 2h 30min core path (plus optional deep dives, downloads and capstone)
- 9 modules · 44 lessons, exercises and resources · final exam · capstone assignment
- Tools: ChatGPT or Claude (with data analysis), Excel, optional Python