{"id":108860,"date":"2025-06-25T15:50:35","date_gmt":"2025-06-25T10:20:35","guid":{"rendered":"https:\/\/www.mygreatlearning.com\/blog\/what-if-analysis-in-excel\/"},"modified":"2025-06-24T10:29:27","modified_gmt":"2025-06-24T04:59:27","slug":"what-if-analysis-in-excel","status":"publish","type":"post","link":"https:\/\/www.mygreatlearning.com\/blog\/what-if-analysis-in-excel\/","title":{"rendered":"Guide to do What-If Analysis in Excel"},"content":{"rendered":"\n<p>Have you ever wondered how a slight change in your budget, sales numbers, or interest rate might affect your final results? That\u2019s precisely where <strong>What-If Analysis in Excel<\/strong> comes in.<\/p>\n\n\n\n<p>Whether you're planning a budget, forecasting sales, or making business decisions, What-If Analysis helps you explore different possibilities before committing to one.<\/p>\n\n\n\n<p>In this tutorial, we\u2019ll walk through what defines What-If Analysis, and show you exactly which tools are used to perform What-If Analysis in Excel.<\/p>\n\n\n\n    <div class=\"courses-cta-container\">\n        <div class=\"courses-cta-card\">\n            <div class=\"courses-cta-header\">\n                <div class=\"courses-learn-icon\"><\/div>\n                <span class=\"courses-learn-text\">Academy Pro<\/span>\n            <\/div>\n            <p class=\"courses-cta-title\">\n                <a href=\"https:\/\/www.mygreatlearning.com\/academy\/premium\/master-data-analytics-in-excel\" class=\"courses-cta-title-link\">Excel for Data Analysis<\/a>\n            <\/p>\n            <p class=\"courses-cta-description\">Learn Excel for powerful data analysis and enhance your skills for better decision-making.<\/p>\n            <div class=\"courses-cta-stats\">\n                <div class=\"courses-stat-item\">\n                    <div class=\"courses-stat-icon courses-user-icon\"><\/div>\n                    <span>5.5 Hrs<\/span>\n                <\/div>\n                <div class=\"courses-stat-item\">\n                    <div class=\"courses-stat-icon courses-star-icon\"><\/div>\n                    <span>2 Projects<\/span>\n                <\/div>\n            <\/div>\n            <a href=\"https:\/\/www.mygreatlearning.com\/academy\/premium\/master-data-analytics-in-excel\" class=\"courses-cta-button\">\n                Learn Excel for Data Analysis\n                <div class=\"courses-arrow-icon\"><\/div>\n            <\/a>\n        <\/div>\n    <\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"what-is-what-if-analysis-in-excel\">What is What-If Analysis in Excel?<\/h2>\n\n\n\n<p>Essentially, it gives you the opportunity to explore new possibilities by examining your data. It makes exploring what happens if you change different values in your spreadsheet simple. Simply put, you\u2019re trying out what-ifs, keeping your actual data intact.<\/p>\n\n\n\n<p>Think of What-If Analysis as a way to forecast different outcomes. Instead of guessing, Excel gives you answers based on real formulas and inputs. It\u2019s especially helpful when planning for uncertain situations, like estimating profits under different sales volumes or adjusting costs in a project.<\/p>\n\n\n\n<p>What-If Analysis can be done in Excel with three built-in tools:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Scenario Manager:<\/strong> You can set up different scenarios and look at what happens under each one.<\/li>\n\n\n\n<li><strong>Goal Seek:<\/strong> If you set a target outcome, Goal Seek helps provide the input needed to reach that result.<\/li>\n\n\n\n<li><strong>Data Tables:<\/strong> Great for testing multiple values at once, you can see how adjusting a couple of variables affects your total.<\/li>\n<\/ul>\n\n\n\n<p>Every tool is unique, and using their powers together gives What-If Analysis the flexibility and strength it has.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"getting-started-preparing-your-data\">Getting Started: Preparing Your Data<\/h2>\n\n\n\n<p>A well-structured and neat spreadsheet is crucial for any type of analysis. Initially, you should double-check your calculations, how references to cells are used, and that the layout is clear.<\/p>\n\n\n\n<p>For setting up a clean, structured spreadsheet, this <a href=\"https:\/\/www.mygreatlearning.com\/academy\/premium\/excel-training-beginners-to-advanced\">Excel training course<\/a> covers everything from foundational basics to advanced Excel functions, helping you build the skills needed for effective data analysis.<\/p>\n\n\n\n<p>To understand more better, take <a href=\"https:\/\/www.mygreatlearning.com\/blog\/data-analysis-quiz\/\">Data Analysis Quiz<\/a>.<\/p>\n\n\n\n<p>If your task is to make a sales forecast, here are some points to remember. You may design a standard sheet that demands basic information such as unit price, items sold, fixed costs, and variable costs. Then, using a formula, you calculate total revenue and profit.<\/p>\n\n\n\n<p>This kind of setup makes it easy to use What-If Analysis in Excel later on. For example, you can test what happens to profit if sales go up, or if you reduce production costs. With your data structured correctly, the tools: Scenario Manager, Goal Seek, and Data Tables, can do the heavy lifting.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"using-scenario-manager\">Using Scenario Manager<\/h2>\n\n\n\n<p>The <strong>Scenario Manager<\/strong> is one of the most powerful tools for What-If Analysis in Excel. It lets you create different input value scenarios to compare various outcomes. This is great for planning or evaluating best- and worst-case situations.<\/p>\n\n\n\n<p>Scenario Manager pairs well with lesser-known Excel features.<\/p>\n\n\n\n<p>Here\u2019s how to use Scenario Manager:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Go to the \u201cData\u201d tab on the Excel ribbon.<\/li>\n\n\n\n<li>Click \u201cWhat-If Analysis\u201d, then select \u201cScenario Manager.\u201d<\/li>\n<\/ul>\n\n\n<figure class=\"wp-block-image size-large zoomable\" data-full=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-4.png\"><img decoding=\"async\" width=\"1024\" height=\"525\" src=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-4-1024x525.png\" alt=\"\" class=\"wp-image-108908\" srcset=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-4-1024x525.png 1024w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-4-300x154.png 300w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-4-768x394.png 768w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-4-1536x787.png 1536w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-4-150x77.png 150w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-4.png 1600w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>In the dialog box, click \u201cAdd\u201d to create your first scenario maybe increase in price that projects change in inventory value.<\/li>\n<\/ul>\n\n\n<figure class=\"wp-block-image size-large zoomable\" data-full=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-5.png\"><img decoding=\"async\" width=\"1024\" height=\"507\" src=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-5-1024x507.png\" alt=\"\" class=\"wp-image-108909\" srcset=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-5-1024x507.png 1024w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-5-300x149.png 300w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-5-768x380.png 768w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-5-1536x760.png 1536w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-5-150x74.png 150w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-5.png 1600w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Choose the input cells (for example: unit price), and enter the values for this scenario.<\/li>\n<\/ul>\n\n\n<figure class=\"wp-block-image size-large zoomable\" data-full=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-6.png\"><img decoding=\"async\" width=\"1024\" height=\"527\" src=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-6-1024x527.png\" alt=\"\" class=\"wp-image-108910\" srcset=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-6-1024x527.png 1024w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-6-300x154.png 300w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-6-768x395.png 768w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-6-1536x790.png 1536w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-6-150x77.png 150w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-6.png 1600w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Repeat the process for additional scenarios, like a decrease in price that projects change in inventory value.<\/li>\n<\/ul>\n\n\n<figure class=\"wp-block-image size-large zoomable\" data-full=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-7.png\"><img decoding=\"async\" width=\"1024\" height=\"509\" src=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-7-1024x509.png\" alt=\"\" class=\"wp-image-108911\" srcset=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-7-1024x509.png 1024w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-7-300x149.png 300w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-7-768x382.png 768w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-7-1536x763.png 1536w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-7-150x75.png 150w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-7.png 1600w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Once your scenarios are added, click \u201cShow\u201d to view each one or use \u201cSummary\u201d to generate a comparison table.<\/li>\n<\/ul>\n\n\n\n<p>This tool is ideal when you need to review what might change if the company\u2019s strategy or the market changes. A simple action allows you to change your outlook from optimistic to pessimistic without repeating any calculations.<\/p>\n\n\n\n<p>Using Scenario Manager allows you to contrast several outcomes, so you can pick the best strategy for your company. It\u2019s a perfect entry point into mastering What-If Analysis in Excel.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"using-goal-seek\">Using Goal Seek<\/h2>\n\n\n\n<p>Another popular tool used to perform What-If Analysis in Excel is <strong>Goal Seek<\/strong>. It\u2019s simple, fast, and incredibly useful when you know the result you want but need Excel\u2019s help to figure out the input that gets you there.<\/p>\n\n\n\n<p>Here\u2019s how Goal Seek works:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Go to the \u201cData\u201d tab, click \u201cWhat-If Analysis,\u201d and select \u201cGoal Seek.\u201d<\/li>\n<\/ul>\n\n\n<figure class=\"wp-block-image size-large zoomable\" data-full=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-8.png\"><img decoding=\"async\" width=\"1024\" height=\"490\" src=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-8-1024x490.png\" alt=\"\" class=\"wp-image-108912\" srcset=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-8-1024x490.png 1024w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-8-300x144.png 300w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-8-768x368.png 768w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-8-1536x735.png 1536w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-8-150x72.png 150w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-8.png 1600w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>In the pop-up box:\n<ul class=\"wp-block-list\">\n<li>Set the \u201cSet cell\u201d to the formula cell (e.g., inventory value).<\/li>\n\n\n\n<li>Set the \u201cTo value\u201d to your goal (e.g., $2,000).<\/li>\n\n\n\n<li>Set the \u201cBy changing cell\u201d to the input you want to tweak (e.g., unit price).<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n<figure class=\"wp-block-image size-large zoomable\" data-full=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-9.png\"><img decoding=\"async\" width=\"1024\" height=\"528\" src=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-9-1024x528.png\" alt=\"\" class=\"wp-image-108913\" srcset=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-9-1024x528.png 1024w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-9-300x155.png 300w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-9-768x396.png 768w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-9-1536x792.png 1536w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-9-150x77.png 150w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-9.png 1600w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Excel will calculate exactly what unit price you need to reach your goal - $2000 worth inventory value.<\/li>\n<\/ul>\n\n\n<figure class=\"wp-block-image size-large zoomable\" data-full=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-10.png\"><img decoding=\"async\" width=\"1024\" height=\"508\" src=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-10-1024x508.png\" alt=\"\" class=\"wp-image-108914\" srcset=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-10-1024x508.png 1024w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-10-300x149.png 300w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-10-768x381.png 768w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-10-1536x762.png 1536w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-10-150x74.png 150w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-10.png 1600w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>Example:<\/strong> Let\u2019s say your spreadsheet calculates profit based on units sold. You want to know how many units you need to sell to earn $10,000. With Goal Seek, Excel will tell you the answer in seconds, and no manual trial-and-error is required.<\/p>\n\n\n\n<p>Goal Seek is perfect for simple \u201creverse-engineering\u201d tasks and fits seamlessly into any What-If Excel workflow.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"using-data-tables\">Using Data Tables<\/h2>\n\n\n\n<p>When you want to see how changing one or two variables affects your results, <strong>Data Tables<\/strong> are the go-to tool in What-If Analysis in Excel. They're ideal for quickly comparing many outcomes without rewriting formulas or creating new scenarios.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"types-of-data-tables\">Types of Data Tables:<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>One-variable Data Table:<\/strong> Analyzes how changing a single input affects a result.<\/li>\n\n\n\n<li><strong>Two-variable Data Table:<\/strong> Examines how two inputs change one outcome.<\/li>\n<\/ul>\n\n\n\n<p>Here\u2019s how to set up a Data Table:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Set up your formula, for example, profit based on price and quantity.<\/li>\n<\/ul>\n\n\n<figure class=\"wp-block-image size-full zoomable\" data-full=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image.png\"><img decoding=\"async\" width=\"441\" height=\"459\" src=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image.png\" alt=\"\" class=\"wp-image-108904\" srcset=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image.png 441w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-288x300.png 288w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-150x156.png 150w\" sizes=\"(max-width: 441px) 100vw, 441px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Arrange your input values:\n<ul class=\"wp-block-list\">\n<li>For a one-variable table, list input values vertically in one column.<\/li>\n\n\n\n<li>For a two-variable table, list one set of values down a column and the other across a row.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Select the full range (inputs + formula cell).<\/li>\n<\/ul>\n\n\n<figure class=\"wp-block-image size-full zoomable\" data-full=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-1.png\"><img decoding=\"async\" width=\"445\" height=\"535\" src=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-1.png\" alt=\"\" class=\"wp-image-108905\" srcset=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-1.png 445w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-1-250x300.png 250w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-1-150x180.png 150w\" sizes=\"(max-width: 445px) 100vw, 445px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Go to the \u201cData\u201d tab &gt; \u201cWhat-If Analysis\u201d &gt; \u201cData Table.\u201d<\/li>\n<\/ul>\n\n\n<figure class=\"wp-block-image size-full zoomable\" data-full=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-2.png\"><img decoding=\"async\" width=\"445\" height=\"535\" src=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-2.png\" alt=\"\" class=\"wp-image-108906\" srcset=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-2.png 445w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-2-250x300.png 250w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-2-150x180.png 150w\" sizes=\"(max-width: 445px) 100vw, 445px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>In the dialog box:\n<ul class=\"wp-block-list\">\n<li>Enter the Row input cell (if applicable).<\/li>\n\n\n\n<li>Enter the Column input cell.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Click OK, and watch Excel instantly fill in your results.<\/li>\n<\/ul>\n\n\n<figure class=\"wp-block-image size-full zoomable\" data-full=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-3.png\"><img decoding=\"async\" width=\"445\" height=\"535\" src=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-3.png\" alt=\"\" class=\"wp-image-108907\" srcset=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-3.png 445w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-3-250x300.png 250w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/image-3-150x180.png 150w\" sizes=\"(max-width: 445px) 100vw, 445px\" \/><\/figure>\n\n\n\n<p><strong>Example:<\/strong> Imagine testing how different interest rates affect a loan payment, or how various combinations of price and quantity affect revenue.<\/p>\n\n\n\n<p>With just a few clicks, Data Tables help you explore multiple outcomes side by side, saving time and improving your decision-making with minimal effort.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"real-life-example-or-use-case\">Real-Life Example or Use Case<\/h2>\n\n\n\n<p>Let\u2019s say you\u2019re planning next quarter\u2019s product launch and want to estimate profit under different pricing strategies and sales volumes.<\/p>\n\n\n\n<p>You start by using Scenario Manager to model best-case, average, and worst-case projections.<\/p>\n\n\n\n<p>Then, you apply Goal Seek to figure out how many units you need to sell to meet a profit target.<\/p>\n\n\n\n<p>Finally, you use a two-variable Data Table to test how changes in both price and volume affect your bottom line.<\/p>\n\n\n\n<p>To take your analysis further, combining Excel with SQL can enhance your ability to handle real business data. Check out this <a href=\"https:\/\/www.mygreatlearning.com\/academy\/premium\/master-data-analytics-in-sql-excel\">Data Analytics in SQL &amp; Excel Course<\/a> to elevate your analytics skills.<\/p>\n\n\n\n<p>Excel\u2019s What-If Analysis helps show how you can mix various techniques to make well-informed decisions based on data.<\/p>\n\n\n\n<p>Having these tools handy can allow you, in finance, marketing, or project management, to understand outcomes, set appropriate goals, and decide your next action.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"tips-best-practices\">Tips &amp; Best Practices<\/h2>\n\n\n\n<p>To get the most out of What-If Analysis in Excel, a little structure goes a long way.<\/p>\n\n\n\n<p>Start by keeping your formulas consistent. Avoid mixing different logic or cell references in your calculations. Consistency makes your scenarios and data tables much easier to manage and interpret.<\/p>\n\n\n\n<p>Always label your scenarios clearly. Use names like \u201cBest Case,\u201d \u201cBase Case,\u201d or \u201cQ4 Forecast\u201d so you know exactly what each one represents, especially when sharing your file with others.<\/p>\n\n\n\n<p>Lastly, make sure to use cell references instead of hard-coded numbers in your formulas. This allows Excel to update your outputs dynamically when inputs change, essential for tools like Goal Seek and Data Tables.<\/p>\n\n\n\n<p>Following these best practices helps you create clean, flexible models that make your What-If Analysis more powerful and reliable.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"conclusion\">Conclusion<\/h2>\n\n\n\n<p>In this tutorial, we explored What-If Analysis in Excel using tools like Scenario Manager, Goal Seek, and Data Tables. You\u2019ve learned how to test different scenarios, set goals, and evaluate multiple outcomes with ease.<\/p>\n\n\n\n<p>The best way to get comfortable is to practice with real datasets, try out different tools, and see how they work together. And while Excel tools like Scenario Manager and Data Tables are excellent for early-stage planning, professionals often upgrade to more advanced data techniques like predictive modeling or optimization in business analytics or data science roles.<\/p>\n\n\n\n<p>Whether you\u2019re analyzing budgets, forecasts, or business decisions, What-If Analysis is a powerful Excel capability. To get the most out of these tools\u2014especially if you\u2019re new to spreadsheets starting with a <strong><a href=\"https:\/\/www.mygreatlearning.com\/academy\/learn-for-free\/courses\/excel-for-beginners\">Free Excel course<\/a><\/strong> can help you learn the basics and progress smoothly toward advanced Excel analysis techniques.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Curious how small changes can impact your Excel models? Discover how to use What-If Analysis tools\u2014Scenario Manager, Goal Seek, and Data Tables\u2014to explore possibilities and make smarter decisions.<\/p>\n","protected":false},"author":41,"featured_media":108915,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[9],"tags":[36822],"content_type":[],"class_list":["post-108860","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-science","tag-excel"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.3 (Yoast SEO v27.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>What-If Analysis in Excel: A Beginner\u2019s Guide<\/title>\n<meta name=\"description\" content=\"Learn how to use What-If Analysis in Excel with this step-by-step guide covering Scenario Manager, Goal Seek, and Data Tables. Perfect for budgeting, forecasting, and decision-making.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.mygreatlearning.com\/blog\/what-if-analysis-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Guide to do What-If Analysis in Excel\" \/>\n<meta property=\"og:description\" content=\"Learn how to use What-If Analysis in Excel with this step-by-step guide covering Scenario Manager, Goal Seek, and Data Tables. Perfect for budgeting, forecasting, and decision-making.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.mygreatlearning.com\/blog\/what-if-analysis-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Great Learning Blog: Free Resources what Matters to shape your Career!\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/GreatLearningOfficial\/\" \/>\n<meta property=\"article:published_time\" content=\"2025-06-25T10:20:35+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/what-if-excel.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"698\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Great Learning Editorial Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/Great_Learning\" \/>\n<meta name=\"twitter:site\" content=\"@Great_Learning\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Great Learning Editorial Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/what-if-analysis-in-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/what-if-analysis-in-excel\\\/\"},\"author\":{\"name\":\"Great Learning Editorial Team\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#\\\/schema\\\/person\\\/6f993d1be4c584a335951e836f2656ad\"},\"headline\":\"Guide to do What-If Analysis in Excel\",\"datePublished\":\"2025-06-25T10:20:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/what-if-analysis-in-excel\\\/\"},\"wordCount\":1476,\"publisher\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/what-if-analysis-in-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/06\\\/what-if-excel.webp\",\"keywords\":[\"excel\"],\"articleSection\":[\"Data Science and Analytics\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/what-if-analysis-in-excel\\\/\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/what-if-analysis-in-excel\\\/\",\"name\":\"What-If Analysis in Excel: A Beginner\u2019s Guide\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/what-if-analysis-in-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/what-if-analysis-in-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/06\\\/what-if-excel.webp\",\"datePublished\":\"2025-06-25T10:20:35+00:00\",\"description\":\"Learn how to use What-If Analysis in Excel with this step-by-step guide covering Scenario Manager, Goal Seek, and Data Tables. Perfect for budgeting, forecasting, and decision-making.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/what-if-analysis-in-excel\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/what-if-analysis-in-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/what-if-analysis-in-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/06\\\/what-if-excel.webp\",\"contentUrl\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/06\\\/what-if-excel.webp\",\"width\":1280,\"height\":698,\"caption\":\"What-If Analysis in Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/what-if-analysis-in-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog\",\"item\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Science and Analytics\",\"item\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/data-science\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Guide to do What-If Analysis in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/\",\"name\":\"Great Learning Blog\",\"description\":\"Learn, Upskill &amp; Career Development Guide and Resources\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#organization\"},\"alternateName\":\"Great Learning\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#organization\",\"name\":\"Great Learning\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/GL-Logo.jpg\",\"contentUrl\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/GL-Logo.jpg\",\"width\":900,\"height\":900,\"caption\":\"Great Learning\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/GreatLearningOfficial\\\/\",\"https:\\\/\\\/x.com\\\/Great_Learning\",\"https:\\\/\\\/www.instagram.com\\\/greatlearningofficial\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/school\\\/great-learning\\\/\",\"https:\\\/\\\/in.pinterest.com\\\/greatlearning12\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/beaconelearning\\\/\"],\"description\":\"Great Learning is a leading global ed-tech company for professional training and higher education. It offers comprehensive, industry-relevant, hands-on learning programs across various business, technology, and interdisciplinary domains driving the digital economy. These programs are developed and offered in collaboration with the world's foremost academic institutions.\",\"email\":\"info@mygreatlearning.com\",\"legalName\":\"Great Learning Education Services Pvt. Ltd\",\"foundingDate\":\"2013-11-29\",\"numberOfEmployees\":{\"@type\":\"QuantitativeValue\",\"minValue\":\"1001\",\"maxValue\":\"5000\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#\\\/schema\\\/person\\\/6f993d1be4c584a335951e836f2656ad\",\"name\":\"Great Learning Editorial Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/unnamed.webp\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/unnamed.webp\",\"contentUrl\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/unnamed.webp\",\"caption\":\"Great Learning Editorial Team\"},\"description\":\"The Great Learning Editorial Staff includes a dynamic team of subject matter experts, instructors, and education professionals who combine their deep industry knowledge with innovative teaching methods. Their mission is to provide learners with the skills and insights needed to excel in their careers, whether through upskilling, reskilling, or transitioning into new fields.\",\"sameAs\":[\"https:\\\/\\\/www.mygreatlearning.com\\\/\",\"https:\\\/\\\/in.linkedin.com\\\/school\\\/great-learning\\\/\",\"https:\\\/\\\/x.com\\\/https:\\\/\\\/twitter.com\\\/Great_Learning\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCObs0kLIrDjX2LLSybqNaEA\"],\"award\":[\"Best EdTech Company of the Year 2024\",\"Education Economictimes Outstanding Education\\\/Edtech Solution Provider of the Year 2024\",\"Leading E-learning Platform 2024\"],\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/author\\\/greatlearning\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"What-If Analysis in Excel: A Beginner\u2019s Guide","description":"Learn how to use What-If Analysis in Excel with this step-by-step guide covering Scenario Manager, Goal Seek, and Data Tables. Perfect for budgeting, forecasting, and decision-making.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.mygreatlearning.com\/blog\/what-if-analysis-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"Guide to do What-If Analysis in Excel","og_description":"Learn how to use What-If Analysis in Excel with this step-by-step guide covering Scenario Manager, Goal Seek, and Data Tables. Perfect for budgeting, forecasting, and decision-making.","og_url":"https:\/\/www.mygreatlearning.com\/blog\/what-if-analysis-in-excel\/","og_site_name":"Great Learning Blog: Free Resources what Matters to shape your Career!","article_publisher":"https:\/\/www.facebook.com\/GreatLearningOfficial\/","article_published_time":"2025-06-25T10:20:35+00:00","og_image":[{"width":1280,"height":698,"url":"http:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/what-if-excel.webp","type":"image\/webp"}],"author":"Great Learning Editorial Team","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/Great_Learning","twitter_site":"@Great_Learning","twitter_misc":{"Written by":"Great Learning Editorial Team","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.mygreatlearning.com\/blog\/what-if-analysis-in-excel\/#article","isPartOf":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/what-if-analysis-in-excel\/"},"author":{"name":"Great Learning Editorial Team","@id":"https:\/\/www.mygreatlearning.com\/blog\/#\/schema\/person\/6f993d1be4c584a335951e836f2656ad"},"headline":"Guide to do What-If Analysis in Excel","datePublished":"2025-06-25T10:20:35+00:00","mainEntityOfPage":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/what-if-analysis-in-excel\/"},"wordCount":1476,"publisher":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/what-if-analysis-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/what-if-excel.webp","keywords":["excel"],"articleSection":["Data Science and Analytics"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.mygreatlearning.com\/blog\/what-if-analysis-in-excel\/","url":"https:\/\/www.mygreatlearning.com\/blog\/what-if-analysis-in-excel\/","name":"What-If Analysis in Excel: A Beginner\u2019s Guide","isPartOf":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/what-if-analysis-in-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/what-if-analysis-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/what-if-excel.webp","datePublished":"2025-06-25T10:20:35+00:00","description":"Learn how to use What-If Analysis in Excel with this step-by-step guide covering Scenario Manager, Goal Seek, and Data Tables. Perfect for budgeting, forecasting, and decision-making.","breadcrumb":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/what-if-analysis-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mygreatlearning.com\/blog\/what-if-analysis-in-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mygreatlearning.com\/blog\/what-if-analysis-in-excel\/#primaryimage","url":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/what-if-excel.webp","contentUrl":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/what-if-excel.webp","width":1280,"height":698,"caption":"What-If Analysis in Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.mygreatlearning.com\/blog\/what-if-analysis-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog","item":"https:\/\/www.mygreatlearning.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Data Science and Analytics","item":"https:\/\/www.mygreatlearning.com\/blog\/data-science\/"},{"@type":"ListItem","position":3,"name":"Guide to do What-If Analysis in Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.mygreatlearning.com\/blog\/#website","url":"https:\/\/www.mygreatlearning.com\/blog\/","name":"Great Learning Blog","description":"Learn, Upskill &amp; Career Development Guide and Resources","publisher":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/#organization"},"alternateName":"Great Learning","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.mygreatlearning.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.mygreatlearning.com\/blog\/#organization","name":"Great Learning","url":"https:\/\/www.mygreatlearning.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mygreatlearning.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/06\/GL-Logo.jpg","contentUrl":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/06\/GL-Logo.jpg","width":900,"height":900,"caption":"Great Learning"},"image":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/GreatLearningOfficial\/","https:\/\/x.com\/Great_Learning","https:\/\/www.instagram.com\/greatlearningofficial\/","https:\/\/www.linkedin.com\/school\/great-learning\/","https:\/\/in.pinterest.com\/greatlearning12\/","https:\/\/www.youtube.com\/user\/beaconelearning\/"],"description":"Great Learning is a leading global ed-tech company for professional training and higher education. It offers comprehensive, industry-relevant, hands-on learning programs across various business, technology, and interdisciplinary domains driving the digital economy. These programs are developed and offered in collaboration with the world's foremost academic institutions.","email":"info@mygreatlearning.com","legalName":"Great Learning Education Services Pvt. Ltd","foundingDate":"2013-11-29","numberOfEmployees":{"@type":"QuantitativeValue","minValue":"1001","maxValue":"5000"}},{"@type":"Person","@id":"https:\/\/www.mygreatlearning.com\/blog\/#\/schema\/person\/6f993d1be4c584a335951e836f2656ad","name":"Great Learning Editorial Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/02\/unnamed.webp","url":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/02\/unnamed.webp","contentUrl":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/02\/unnamed.webp","caption":"Great Learning Editorial Team"},"description":"The Great Learning Editorial Staff includes a dynamic team of subject matter experts, instructors, and education professionals who combine their deep industry knowledge with innovative teaching methods. Their mission is to provide learners with the skills and insights needed to excel in their careers, whether through upskilling, reskilling, or transitioning into new fields.","sameAs":["https:\/\/www.mygreatlearning.com\/","https:\/\/in.linkedin.com\/school\/great-learning\/","https:\/\/x.com\/https:\/\/twitter.com\/Great_Learning","https:\/\/www.youtube.com\/channel\/UCObs0kLIrDjX2LLSybqNaEA"],"award":["Best EdTech Company of the Year 2024","Education Economictimes Outstanding Education\/Edtech Solution Provider of the Year 2024","Leading E-learning Platform 2024"],"url":"https:\/\/www.mygreatlearning.com\/blog\/author\/greatlearning\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/what-if-excel.webp",1280,698,false],"thumbnail":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/what-if-excel-150x150.webp",150,150,true],"medium":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/what-if-excel-300x164.webp",300,164,true],"medium_large":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/what-if-excel-768x419.webp",768,419,true],"large":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/what-if-excel-1024x558.webp",1024,558,true],"1536x1536":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/what-if-excel.webp",1280,698,false],"2048x2048":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/what-if-excel.webp",1280,698,false],"web-stories-poster-portrait":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/what-if-excel-640x698.webp",640,698,true],"web-stories-publisher-logo":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/what-if-excel-96x96.webp",96,96,true],"web-stories-thumbnail":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/06\/what-if-excel-150x82.webp",150,82,true]},"uagb_author_info":{"display_name":"Great Learning Editorial Team","author_link":"https:\/\/www.mygreatlearning.com\/blog\/author\/greatlearning\/"},"uagb_comment_info":0,"uagb_excerpt":"Curious how small changes can impact your Excel models? Discover how to use What-If Analysis tools\u2014Scenario Manager, Goal Seek, and Data Tables\u2014to explore possibilities and make smarter decisions.","_links":{"self":[{"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/posts\/108860","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/users\/41"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/comments?post=108860"}],"version-history":[{"count":8,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/posts\/108860\/revisions"}],"predecessor-version":[{"id":115123,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/posts\/108860\/revisions\/115123"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/media\/108915"}],"wp:attachment":[{"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/media?parent=108860"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/categories?post=108860"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/tags?post=108860"},{"taxonomy":"content_type","embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/content_type?post=108860"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}