EPW Training runs a five-day advanced Excel course in London, taught in person: Advanced Excel for Financial Analysis and Modeling. It is for people who already use Excel every day and want to build financial and business models that are structured, accurate and easy for others to check: advanced formulas and data preparation, integrated financial statements, scenarios, valuation and sensitivity, and dashboards. It is not an introduction to Excel. 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 London
London is one of the world's leading business and financial centres, with direct flights from the Gulf, Africa and most major cities. The course is hands-on: you build and test models in Excel throughout the week.
Frequently asked questions
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 London?
Five days, in person in London. 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 course in London.
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 London cost?
Five-day courses in London are currently listed at 8,345 GBP or 9,265 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 London or at your own premises. Contact EPW for group pricing and dates.
The same course runs in Kuala Lumpur and Dubai. See also data analytics courses in London and finance and budgeting courses in London.