• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Stephen L. Nelson

Author. Accountant. Aspiring Apiarist.

  • Articles
  • e-Books
    • Maximizing Section 199A Deduction
    • Setting a a Reasonable S Corporation Salary
    • Small Business Tax Deduction Secrets
    • Real Estate Tax Loopholes & Secrets
    • DIY LLC Formation and Incorporation Kits
    • Sample LLC Operating Agreements
    • Sample Corporation By-Laws
  • Contact

business modeling

Optimization Modeling with Solver in Excel

May 18, 2015 By Stephen L. Nelson Leave a Comment

Cover to MBA's Guide to Microsoft Excel

Excel’s Solver tool lets you solve optimization-modeling problems, also commonly known as linear programming programs. With an optimization-modeling problem, you want to optimize an objective function but at the same time recognize that there are constraints, or limits. While this abstract … [Read more...] about Optimization Modeling with Solver in Excel

Filed Under: Finance, Using Excel Tagged With: business modeling

Simple Modeling with Goal Seek in Excel

May 18, 2015 By Stephen L. Nelson Leave a Comment

Cover to MBA's Guide to Microsoft Excel

You can use the Goal Seek command to determine which input value for a formula pro- duces a specified formula result. Goal Seek, then, lets you quantify what needs to happen in order to achieve some specified result. Rather than supplying a set of formula inputs and letting Excel calculate the … [Read more...] about Simple Modeling with Goal Seek in Excel

Filed Under: Finance, Using Excel Tagged With: business modeling

What-If Analysis with Scenario Manager in Excel

May 18, 2015 By Stephen L. Nelson Leave a Comment

Cover to MBA's Guide to Microsoft Excel

Data tables, as discussed in the earlier sections of this chapter, let you perform what-if analysis when you change one variable and explore the effect on a small handful of formulas or when you change two variables and explore the effect on a single formula. But this approach doesn’t work except in … [Read more...] about What-If Analysis with Scenario Manager in Excel

Filed Under: Finance, Using Excel Tagged With: business modeling

What-If Analysis with Data Tables in Excel

May 18, 2015 By Stephen L. Nelson Leave a Comment

Cover to MBA's Guide to Microsoft Excel

Excel lets you easily create simple data tables that show how changing a formula input affects the formula result. You can, for example, build simple one-variable data tables that show how changing a single input value affects one or more formulas. And you can also create more com- plicated … [Read more...] about What-If Analysis with Data Tables in Excel

Filed Under: Finance, Using Excel Tagged With: business modeling

Primary Sidebar

Article Categories

  • Accounting
  • Business Planning
  • Finance
  • Real Estate
  • Statistics
  • Taxes
  • Using Excel

Copyright © 2025 Stephen L. Nelson, Inc. · Contact · Steve’s Bio · Publications · Glossary