How to Use Excel Like A Pro 2.0

 A forecast often feels complete the moment the numbers work. The assumptions are in place, the calculations balance, and the final output appears reasonable. Yet that is usually the point where experienced decision-makers begin asking questions rather than accepting answers.

This was the central theme explored during dbrownconsulting's latest How to Use Excel Like a Pro 2.0 webinar, where analyst Desmond Nwokolo challenged a common misconception about spreadsheet expertise. The session was not about formulas, shortcuts, or complicated Excel tricks. It was about something much more valuable: understanding uncertainty well enough to make better decisions.

Many professionals associate advanced Excel skills with technical complexity. The assumption is that becoming proficient means learning increasingly sophisticated formulas, mastering obscure functions, or developing shortcuts that make spreadsheets faster to build. However, the session took a different position. Technical skill matters, but its value ultimately depends on whether it helps answer the questions that businesses actually care about. Those questions are rarely about formulas. More often, they are about what happens when reality differs from expectation.

To illustrate this, Desmond described a situation many analysts have encountered. A forecast is prepared using the best available information. Assumptions are made about sales volumes, pricing, costs, exchange rates, and other factors that drive performance. The resulting model produces a clear answer, and confidence is high until someone asks a simple question:

"What if these assumptions are wrong?"

Difference Between Building a Forecast and Supporting a Decision

One of the most important distinctions made during the session was the difference between producing a forecast and supporting a decision.

Forecasts are built on assumptions. No matter how much research goes into them, they remain estimates of what might happen in the future. Businesses, however, do not operate in certainty. Market conditions change, costs fluctuate, customer behaviour shifts, and competitive activity introduces new variables. A forecast that considers only one possible outcome risks creating a false sense of confidence.

This explains why decision-makers often push back on single-number projections. They are not necessarily questioning the quality of the analysis. Rather, they are trying to understand the range of possibilities that could emerge if conditions change.

Desmond addressed this directly when explaining the purpose of Excel's What-If Analysis tools by saying, "Instead of going with one single number, you will be able to go with a range of outcomes."

The shift from a single answer to multiple possibilities is what transforms a spreadsheet from a reporting tool into a decision-support tool.

Why Boards Want Ranges Instead of Certainty

The webinar's case study provided a practical example of this challenge.

Participants were introduced to Zenith Food Co., a company considering a significant investment in a new product launch. Based on initial assumptions, the finance team had prepared projections showing a positive Net Present Value (NPV), suggesting the project would create value. On paper, the conclusion appeared reasonable.

The board, however, wanted more than a positive projection. Pricing could vary. Volumes could rise or fall. Costs could become volatile. Market conditions could change.

Before committing substantial capital, they wanted to understand what the outcome would look like under different circumstances. The question moved from whether the project worked under ideal assumptions to whether it remained attractive when reality inevitably became more complicated.

This reflects a broader truth about decision-making. Leaders are rarely interested in a single outcome. They want to understand the boundaries of risk.

Where Sensitivity Analysis Becomes Powerful

To address this challenge, Desmond introduced sensitivity analysis.

Rather than treating assumptions as fixed, sensitivity analysis examines how changes in those assumptions affect a particular outcome. A business can test different pricing levels, volume assumptions, or cost scenarios and immediately see how those changes influence a metric such as profit or NPV.

The speaker explained it simply by saying: "Sensitivity analysis is just saying if one or two of my inputs or assumptions change, how will it affect my outputs?"

The strength of this approach lies in visibility. Instead of discovering risks after a decision has been made, decision-makers can explore those risks beforehand.

Questions such as:

• What if volume falls below expectations?
• What if pricing pressure increases?
• What happens if costs rise unexpectedly?

can all be addressed before resources are committed.

The value is not the spreadsheet itself. The value is the quality of the conversation it enables.

When a Few Assumptions Are Not Enough

Business reality, however, rarely changes one variable at a time.

Price, volume, costs, and market conditions often move simultaneously. A decision-maker may therefore need to evaluate complete business situations rather than isolated changes.

This is where Scenario Manager becomes valuable.

While sensitivity analysis typically focuses on one or two assumptions and one output, Scenario Manager allows professionals to test multiple assumptions at the same time and examine their impact across several business metrics.

Rather than asking what happens if price changes, organizations can explore entire scenarios:

• What does a realistic worst-case environment look like?
• How does performance change in a best-case scenario?
• Which assumptions matter most when evaluating risk?

This broader perspective reflects how decisions are actually made. Business leaders rarely face isolated variables. They manage systems where multiple factors interact simultaneously.

The Real Skill Behind Professional Excel Use

The real value of Excel is not found in the number of formulas someone can memorize. It is found in their ability to use information to reduce uncertainty.

When Desmond described these tools as mechanisms for helping professionals answer business questions and make decisions, he was pointing to a much larger skill set than spreadsheet proficiency.

Professionals become more valuable when they can explain outcomes, test assumptions, evaluate alternatives, and provide confidence in uncertain situations. The spreadsheet simply becomes the environment where that work happens.

Viewed from that perspective, sensitivity analysis and scenario planning are not technical exercises. They are decision-making exercises.

Why This Matters Beyond Excel

One reason this discussion resonates far beyond spreadsheet training is because the underlying thinking applies to every aspect of financial analysis.

Strong financial modeling is not about predicting the future perfectly. It is about understanding the range of outcomes that the future might produce and preparing decision-makers accordingly.

The professionals who stand out are not necessarily the ones who produce the most detailed forecasts. They are the ones who can explain what happens when assumptions change, identify where risks emerge, and help organizations navigate uncertainty with greater confidence.

That progression, from building spreadsheets to supporting decisions, sits at the heart of effective financial modeling.

It is also why programmes such as the Financial Modeling Academy continue to attract growing interest from finance professionals. Technical skills remain important, but they become significantly more valuable when combined with the ability to interpret business scenarios, evaluate investments, and support strategic decisions under uncertainty.

Registration for the next Financial Modeling Academy cohort is officially open, thereby providing another opportunity for professionals looking to strengthen those capabilities through a structured pathway developed in partnership with the Financial Modeling Institute (FMI), Canada.

You can learn more and apply here: https://bit.ly/FMARoutes

Note: The most useful forecast is rarely the one that produces a single answer. It is the one that helps decision-makers understand what happens when that answer changes.