Excel for Commerce | 2016 | Excel for Commerce

03Feb2016: How to use ‘What-If Analysis’ tools in Excel

Microsoft Excel is equipped with “What-If Analysis” tools like scenario manager, Goal-seek and Data table. These tools allow you to use different data sets in one or more formulas to come up with different sets of results. For example, scenario manager can be used to compare two different budgets at the same time using its “Summary”

3 Feb, 2016
Excel for Commerce
0 Comments
Data table, Goal Seek, Scenario Manager, What-if analysis in excel,

Read more

21Jan2016: How to use Solver in Excel

In our day to day lives, at an individual level or at a business level, we come across questions like: “How much should my personal expenses on a particular item be cut down so that my total expenses don’t reach the threshold?” “To what extent should the company increase its advertising spend so that revenue

21 Jan, 2016
Excel for Commerce
0 Comments
ExcelSolver, Solveraddin,

Read more

Scroll