Curriculum
12 Sections
35 Lessons
6 Weeks
Expand all sections
Collapse all sections
Advanced Excel for Financial Modelling
Learn best practices for building structured financial models using advanced Excel functions.
3
1.1
Named ranges, dynamic arrays, and data validationCopy
1.2
LET, LAMBDA, XLOOKUP, and dynamic tablesCopy
1.3
Hands-on: Build a structured financial modelCopy
Sensitivity and Scenario Analysis
Explore tools for risk assessment and scenario planning in Excel.
3
2.1
Data Tables, Goal Seek, Scenario ManagerCopy
2.2
Monte Carlo simulationsCopy
2.3
Case Study: Risk assessment in forecastingCopy
Financial Statement Modelling
Build dynamic and linked financial statements in Excel.
3
3.1
Income Statement, Balance Sheet, Cash FlowCopy
3.2
Circular references and iterative calculationsCopy
3.3
Hands-on: Construct a three-statement modelCopy
Excel Automation for Financial Modelling
Automate repetitive tasks using VBA and macros.
2
4.1
VBA basics, macros, error handlingCopy
4.2
Hands-on: Write scripts to automate modelsCopy
Introduction to Power BI for Finance
Learn how Power BI complements Excel for financial analysis.
4
5.1
Connecting to financial data sourcesCopy
5.2
Power Query for data cleaningCopy
5.3
Hands-on: Import and shape financial dataCopy
5.4
Data source mapping and transformation stepsCopy
0 Questions
Data Modelling and DAX for Finance
Use DAX to build financial KPIs and perform time-based analysis.
4
6.1
Relationships and data model designCopy
6.2
CALCULATE, FILTER, TIME INTELLIGENCECopy
6.3
Hands-on: Create financial KPIsCopy
6.4
DAX formula building and KPI logicCopy
0 Questions
Interactive Financial Dashboards in Power BI
Design dashboards for executives and decision-makers.
3
7.1
Visual storytelling, slicers, drill-throughCopy
7.2
Hands-on: Build an interactive dashboardCopy
7.3
Dashboard layout and visual selectionCopy
0 Questions
Forecasting and AI in Power BI
Use built-in AI tools for financial forecasting.
4
8.1
Time series forecastingCopy
8.2
AI features in Power BICopy
8.3
Hands-on: Build a forecast modelCopy
8.4
Forecasting accuracy and AI tool usageCopy
0 Questions
Introduction to AI in Financial Modelling
Understand how AI is transforming financial analysis.
4
9.1
AI tools in Excel and Power BI (Copilot, AI Insights)Copy
9.2
Ethical considerationsCopy
9.3
Hands-on: Explore AI-generated insightsCopy
9.4
AI tool identification and ethical scenariosCopy
0 Questions
AI-Powered Forecasting and Predictive Modelling
Use Python and machine learning for financial forecasting.
4
10.1
Revenue prediction modelsCopy
10.2
Anomaly detectionCopy
10.3
Hands-on: Implement AI-driven forecastingCopy
10.4
Model selection and prediction logicCopy
0 Questions
Automation and AI-Driven Decision Making
Automate workflows and integrate AI for smarter decisions.
4
11.1
Power Automate for financial alertsCopy
11.2
Sentiment analysis and Azure AI integrationCopy
11.3
Hands-on: Automate financial triggersCopy
11.4
Workflow mapping and AI integrationCopy
0 Questions
Capstone Project and Course Wrap-Up
Apply all skills in a group project and present insights.
4
12.1
Group challenge: Build an AI-enhanced financial modelCopy
12.2
Presentation and feedbackCopy
12.3
Final Q&A and next stepsCopy
12.4
Activity: Capstone project showcaseCopy
Financial Modeling
Curriculum
This content is protected, please
login
and enroll in the course to view this content!
Home
Courses
Search
Search
Account
Login with your site account
[microsoft_login_button]
Not a member yet?
Register now
Register a new account
Want to become an instructor?
Are you a member?
Login now
Modal title
Main Content