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.
| Responsable | Rehaf Foula |
|---|---|
| Última actualización | 24/10/2026 |
| Tiempo de finalización | 12 horas 5 minutos |
| Miembros | 1 |
-
Module 1 — Introduction4Lecciones · 32 min
-
Getting Started: Your Guided and Extended PathsNuevo 10 xp
-
Vista previa gratis Nuevo 10 xp
-
Demonstration and Guidelines for Safe AI UseNuevo 10 xp
-
Case Dataset and Copy-Ready MaterialsNuevo
-
-
Module 2 — What Is AI? The Basics2Lecciones · 17 min
-
Artificial Intelligence: From Machine Learning to Generative FinanceNuevo 10 xp
-
Interactive Exercise: Choose the Right Tool and ControlNuevo 10 xp
-
-
Module 3 — Optional: Custom GPT Design4Lecciones · 41 min
-
Optional Resources: Assistant Design PackNuevo
-
Set Up a Custom GPT or Claude Project for Financial AnalysisNuevo 10 xp
-
Demonstration: Build and Test the NDCP Analysis AssistantNuevo 10 xp
-
Optional Reflection: Would You Release This Assistant?Nuevo 10 xp
-
-
Module 4 — AI-Powered Financial Ratio Analysis9Lecciones · 1 h 24 min
-
Ratio Analysis Resources and Prompt PackNuevo
-
Format Financial Data for Reliable AI AnalysisNuevo 10 xp
-
Comprehend and Validate Data Before CalculationNuevo 10 xp
-
Calculate Liquidity and Solvency RatiosNuevo 10 xp
-
Continue with Profitability and Efficiency RatiosNuevo 10 xp
-
Complete the Analysis with DuPont and Integrated InterpretationNuevo 10 xp
-
Create Decision-Useful Ratio ChartsNuevo 10 xp
-
Prompt Engineering for Ratio Tables and ChartsNuevo 10 xp
-
Chapter Summary: Ratio Analysis Control SheetNuevo 10 xp
-
-
Module 5 — Advanced Vertical and Horizontal Analysis9Lecciones · 1 h 23 min
-
Statement Analysis Downloads and TemplatesNuevo
-
Use Generative AI to Analyse Financial StatementsNuevo 10 xp
-
Horizontal Analysis: Change Across TimeNuevo 10 xp
-
Human-Readable vs Machine-Readable Financial DataNuevo 10 xp
-
Visualise Statement Trends Without DistortionNuevo 10 xp
-
Build the Correlation MatrixNuevo 10 xp
-
Review Correlations with Professional ScepticismNuevo 10 xp
-
Vertical Analysis: Common-Size StatementsNuevo 10 xp
-
Combine Vertical and Horizontal AnalysisNuevo 10 xp
-
-
Module 6 — Time Series Analysis9Lecciones · 1 h 22 min
-
Time-Series Data and Forecasting PackNuevo
-
Time Series: Trend, Seasonality, Cycles, and NoiseNuevo 10 xp
-
Seasonality in Egyptian FMCG: Ramadan and Summer EffectsNuevo 10 xp
-
Refresher: Moving Averages, Decomposition, and StationarityNuevo 10 xp
-
🎬 Augmented Dickey-Fuller (ADF) Test Explained with SAS + InterpretationNuevo
-
Create a Linear Regression Forecast with AINuevo 10 xp
-
Interact with Forecast Data and Challenge the ModelNuevo 10 xp
-
Worked Exercise: Forecast with Linear RegressionNuevo 10 xp
-
Interactive Exercise: Approve, Revise, or Reject the ForecastNuevo 10 xp
-
-
Module 7 — Using Generative AI for Finance in the Real World5Lecciones · 45 min
-
AI in FP&A and BudgetingNuevo 10 xp
-
AI-Assisted Variance AnalysisNuevo 10 xp
-
Credit and Risk Assessment with Generative AINuevo 10 xp
-
Governance, Data Privacy, and Sustainable Tool AdoptionNuevo 10 xp
-
Reflection: Where Will AI Add Value in Your Finance Team?Nuevo 10 xp
-
-
Module 8 — Conclusion2Lecciones · 14 min
-
Course Summary: The Controlled AI Analysis WorkflowNuevo 10 xp
-
Conclusion and Next Steps: Keep the Method, Adapt the ToolNuevo 10 xp
-
-
Module 9 — Final Assessment2Lecciones · 5 h 27 min
-
Final Exam: Advanced AI-Enhanced Financial AnalysisNuevo 10 xp
-
Capstone Assignment: AI-Assisted Financial Analysis of NDCPNuevo
-
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