Summary  
This chapter demonstrates how to centralize key parameters in a dedicated reference table and use dynamically generated formulas to compute derived metrics (average growth rate, churn rate, projected profit), then iteratively validate and correct those formulas.  

General domain of usage  
Business financial forecasting models



In this chapter, you build the foundation of your forecasting model.

You create a single place where all key inputs and variables are stored, so the rest of your calculations can reference them.




Start by creating a clean table with your main inputs.

Include values such as subscribers, pricing, costs, and projected changes. This table becomes the base for all future calculations.

Keep it simple and readable so you can adjust values easily later.

Create the Assumptions Table


Extend the table with calculated values.

For example, add a proposed price and a churn percentage that changes based on pricing. Ask Copilot to generate the formula, then review how it works.

Add Calculated Fields


Next, calculate projected profit based on your assumptions.

Copilot can generate the formula, but you must verify the logic. In forecasting, small mistakes can lead to incorrect results.

Build the Profit Calculation


If the formula combines percentages incorrectly, adjust it.

Make sure growth and churn are applied step by step, not added together. This keeps the model realistic and prevents incorrect projections.

You can guide Copilot with more precise instructions to fix the formula.

Correct the Formula Logic

Discover how to use Excel with Copilot to solve real business problems. Explore practical workflows that turn messy data into structured, reliable systems. Learn how to build models, automate calculations, and generate insights without memorizing formulas. Understand how to guide Copilot, validate its output, and keep full control over your logic.

Explore the core setup and habits for working with Copilot in Excel. You configure your environment, learn how to write clear prompts, and apply safe workflows before using Copilot on real data. You focus on testing, verifying results, and protecting your files. These skills help you avoid mistakes and use Copilot with confidence further.

Focus on turning messy, inconsistent datasets into clean and usable data. You standardize headers, split combined fields, fix mixed formats, and remove duplicates using Copilot. Consider real-world scenarios and apply structured workflows to clean data safely.

Discover using Copilot to work with clean data and turn it into insights. You extract values, connect multiple datasets, handle errors, and build dynamic summaries. Learn to describe tasks in plain language while Copilot generates and applies the formulas.

Learn how to present data in a clear and interactive way. Create PivotTables, add slicers, build charts, and apply conditional formatting to highlight key insights. Combine all elements into a structured dashboard and use Copilot to support analysis, formatting, and presentation. 

Build a forecasting model using assumptions, pricing scenarios, and 12-month projections. Test different outcomes, guide Copilot through complex logic, and turn your analysis into a clear, decision-ready recommendation.

Turn your work into a reusable, product-like spreadsheet. Clean raw data, combine multiple sources into a single system, build automated reports, and package everything into a polished template with instructions that anyone can use.

Building an Assumptions Sandbox