
Accelerate financial modeling in cloud in excel for finance with structure, rigor, and judgment across portfolio optimization, financial statement analysis, and master budgeting.
Explore the cloud interface inside Excel, set up Claude, and run a first demo building a structured discounted cash flow model with bear, base, and bull scenarios.
Explore using Claude in Excel for finance, focusing on prompt context and fidelity, with five-part prompts—role, task, inputs, constraints, output format—to build, review, and forecast auditable models.
Learn to optimize investment portfolios in Excel by measuring return and risk, building the covariance matrix, and applying constraints with Clo.
Claude performs a technical QA review of the portfolio workbook, assessing data flow from prices to returns and solver vs python alignment, noting minor price rounding and missing risk-free rate.
Explore a devil’s advocate review of a portfolio optimization model, identifying weak assumptions, dominant drivers, and limits of interpretation to improve robustness and presentation to management.
Analyze financial statements with cloud and Excel, performing ratio analysis, visualization, and an executive summary. Interpret numbers, spot red flags, and connect findings to the business story to communicate conclusions.
Map the reference financial model by analyzing workbook architecture, sheet roles, inputs, calculations, and outputs. Apply this architecture to adapt to a new Caterpillar case using the Atlantic bottling reference.
Learn how Claude performs a devil's advocate review of the Caterpillar financial model, identifying fragile interpretations, key assumptions, and practical recommendations for management.
Master capital budgeting and investment analysis with debt present value, internal rate of return analysis, risk analysis, and Monte Carlo simulation, using cloud tools for sensitivity analysis and npv/irr insights.
Review a deterministic 1,000 hectare teak plantation model in excel, including outputs like npv and irr and the capm-based cost of equity, while Claude detects and fixes a critical error.
Claude identifies the key drivers before Monte Carlo, showing how price growth and year 10 volume affect net present value and internal rate of return, and recommends two sensitivity tables.
Practice a devil’s advocate review of a financial model in Excel, examining Monte Carlo results, NPV robustness, dominant risk drivers, and necessary disclosures.
Master budgeting and financial projections in excel cloud, build a full system covering sales, cash, financing, and taxes, producing a budgeted income statement and balanced projected balance sheet.
Forecast sales with holdout validation to build a robust master budget and liquidity plan. Compare forecasting methods, rank them by error, and recommend multiplicative hold winters for seasonal growth.
Review the model from a senior lens by challenging assumptions, identifying dominant drivers, exploring breakdown scenarios, and improving documentation to emphasize liquidity over profitability.
AI already has huge potential in business and finance, but real usage is still far behind. That gap creates an opportunity for professionals who learn to use these tools well, before that becomes standard. The problem is that AI can produce work that looks polished very quickly, and when something looks professional, people tend to question it less. That is exactly why this course is not about flashy prompts. It is about using Claude in Excel for finance with speed, yes, but also with structure, rigor, and judgment.
My name is Carlos Martínez. I hold a PhD in Management from the University of St. Gallen in Switzerland, I have written 25 teaching cases, including some in Harvard and University of Michigan case libraries, and I have spent more than five years building finance and analytics courses on Udemy. I designed this course so you do not just generate output. I want you to understand the financial logic, ask better questions, and know how to validate what Claude gives you.
Inside the course, we work through a practical progression. We start with portfolio optimization, then move into financial statement analysis, dashboards, and executive summaries. After that, we go into capital budgeting and investment analysis, including sensitivity analysis and Monte Carlo support. And we close with one of the most valuable areas in real financial work: financial planning, the master budget, and projected financial statements.
You will not only get video lessons. You will also get downloadable Excel files, PDFs of the presentations, reusable prompts, assignments with suggested solutions, access to the Q&A forum, and AI-powered roleplays so you can practice defending your models, assumptions, and conclusions in realistic business conversations.
If you want to work faster without sacrificing quality, and you want a practical framework for using Claude in Excel for real financial work, this course is for you. Take a look at the free lessons, review the details, and if the approach makes sense to you, I would be glad to have you inside the course.