Scenario Manager Excel
Managing scenarios is a key skill for any advanced financial modeler. In this video, Ian Schnoor, FMI’s Executive Director walks through essential techniques to help you build a flexible, clear, and professional scenarios page, whether you're preparing for the AFM exam or improving your day-to-day modeling.How to Find Hardcoded Values in Excel
Are dead inputs and hardcoded values sneaking into your financial models? Dead inputs and hardcoded values can ruin a model. In this video, Ian Schnoor, FMI’s Executive Director, explains why it is essential to check your financial model for dead inputs and hard coded values.How to Review a Financial Model
Have you ever reviewed a financial model that contains errors? Most people have. The reality is that many models contain errors. This Guide will help you check and review a financial model to ensure that it is accurate. Together these tips are a powerful suite of options to help find errors in a model.Purpose of an Executive Summary
The executive summary is your opportunity to present your findings clearly and succinctly. It should be tailored to your audience and reflect the unique aspects of the project, industry, or decision-making scenario the model supports. Learn why executive summaries are so important and what you should consider when building one.Center Across Selection in Excel
Why you should avoid merged cells in your models. Merging cells might seem like a simple formatting fix, but it often creates flexibility issues in your model. Strong financial modelers use Center Across Selection because it maintains your spreadsheet functionality.Excel Formulas for Financial Modeling
Good modeling starts with smart formulas. Whether you're switching scenarios, setting capacity limits, or creating clear report headers, this post shows how to use Excel tools like INDEX, MIN, and TEXTJOIN to streamline both the logic and the presentation of your model.
