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 |
|---|---|
| آخر تحديث | 24/10/2026 |
| وقت الإكمال | 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