• 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

Using Excel

Sharing Workbook Files in Excel

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

Cover to MBA's Guide to Microsoft Excel

Excel provides several useful tools for sharing your actual workbooks, rather than just the information they contain. You can tell Excel to save or open workbooks in formats accept- able to other spreadsheet programs. You can direct Excel to save your workbooks on a net- work drive and then make the … [Read more...] about Sharing Workbook Files in Excel

Filed Under: Using Excel Tagged With: sharing workbooks

Using OLE with Excel

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

Cover to MBA's Guide to Microsoft Excel

Microsoft Windows itself provides a powerful and easy-to-use tool for sharing data known as OLE, or Object Linking and Embedding. With OLE, you can transfer data between Excel and other Windows’ programs, as described in the paragraphs that follow. How OLE Works In order to make sense of OLE, it’s … [Read more...] about Using OLE with Excel

Filed Under: Using Excel Tagged With: sharing workbooks

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

  • « Go to Previous Page
  • Go to page 1
  • Interim pages omitted …
  • Go to page 5
  • Go to page 6
  • Go to page 7
  • Go to page 8
  • Go to page 9
  • Go to page 10
  • Go to Next Page »

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