EPW Training runs a five-day advanced Excel course in Malaysia, taught in person in Kuala Lumpur: Advanced Excel for Financial Analysis and Modeling. It is for people who already use Excel at work and want to build reliable financial and business models: a clear model structure, advanced formulas, integrated financial statements, scenarios, valuation and sensitivity, and dashboards that managers can read. It is not a beginner course. The course starts about twice a month.
What the advanced Excel course covers
- Day 1: model architecture and data foundations: separating inputs, calculations and outputs, workbook structure, tables, data validation and version control
- Day 2: advanced formulas and data preparation: conditional aggregation, advanced lookups, dynamic-array and date functions, query workflows and formula auditing
- Day 3: integrated financial models: revenue and cost drivers, capital expenditure and depreciation, working capital and cash flow, and integrity checks
- Day 4: scenarios, valuation and sensitivity: base, upside and downside cases, data tables, goal seek and discounted cash-flow valuation
- Day 5: dashboards, automation and model assurance: decision-focused charts, interactive summaries, reusable templates and peer review
Choose the right course
- Excel modelling: Advanced Excel for Financial Analysis and Modeling.
- Financial analysis and reporting: Financial Analysis and Reporting for Decision Makers.
- Dashboards and business intelligence: Power BI for Data Analysis and Business Dashboards and Business Intelligence and Data-Driven Decision Making.
- Sector models: Oil and Gas Financial Modeling and Investment Analysis Intensive.
Who should attend
- Financial analysts, accountants and FP&A staff
- Business, commercial and planning analysts
- Managers who build budgets, forecasts or investment cases in Excel
- Experienced Excel users who want more structured, reliable models
Why train in Kuala Lumpur
Kuala Lumpur is Malaysia's capital and a major business centre in South-East Asia, with direct flights from the Gulf and across Asia. The course is hands-on: you build and test models in Excel throughout the week.
Frequently asked questions
Where in Malaysia do the courses run?
The courses run in Kuala Lumpur. Any course can also be delivered in-house at your own premises elsewhere in Malaysia.
Is this a beginner Excel course?
No. It is an advanced course for people who already use Excel at work. It focuses on building financial and business models, not on Excel basics.
How long is the Excel course in Kuala Lumpur?
Five days, in person in Kuala Lumpur. The course starts about twice a month.
Does the course cover Power BI?
No. Power BI is a separate five-day course: see Power BI training in Malaysia.
Is this a Microsoft certification course?
No. Advanced Excel for Financial Analysis and Modeling is an EPW Training course and leads to an EPW Training certificate of completion, not a Microsoft exam.
How much does a course in Kuala Lumpur cost?
Five-day courses in Kuala Lumpur are currently listed at 9,450 GBP or 10,490 GBP, depending on the course. The exact fee is shown next to every date on each course page. Travel, accommodation, meals and visa fees are not included.
Do I get a certificate?
Yes. Everyone who completes a course receives an EPW Training certificate of completion.
Can a course run for our team only?
Yes. Any of these courses can be delivered in-house, in Kuala Lumpur or at your own premises. Contact EPW for group pricing and dates.
The same course runs in London and Dubai. See also data analytics training in Malaysia, or browse all finance and accounting courses in Kuala Lumpur.