Favourite Tech Notes

How to merge Scenarios in EXCEL 2010 Prior to starting about our title, lets have a quick recap of "What Scenario is". Scenario can be defined as " Set of combination of values, that can be created for any fixed range of cells and may be used as and when required" . Excel also offers, Scenario Summary to get values of all combinations at once, so that we may look at all available combination at a glance. Merge scenarios Select the worksheet in which to store the merged scenarios results. On the Data tab, in the Data Tools group, click What-If Analysis , and then click Scenario Manager . Click Merge . In the Merge Scenarios dialog box, click the arrow next to Book and select a workbook that contains scenarios that you want to merge in your results.   In the Sheet box, click the name of the worksheet that contains scenarios that you want to merge.  Click OK to merge the scenarios from the selected workshee...

Hiiiiiii , and a very good day to all my readers. I have been receiving queries related to Advanced Excel features including, GOAL SEEK, SCENARIO, PIVOT TABLE, SUBTOTAL, FORMULA etc. We shall be discussing each and every feature of Advance Excel in Detail. Firstly we'll be learning the GOAL SEEK Feature Goal Seek Goal Seek is used t o determine the value of   any  input cell(cell being used in the formula) new value for formula cell is known. Suppose we have following table available with us having details of employees along with Salary figure and computed bonus value as 12 % of Salary Here in the above table, if you would like to determine the new Salary for employee name "SOFT" , for a new Bonus value of 4100 (where Bonus is calculated as 12 % of salary) . To do so,follow the steps mentioned below,   Place cell pointer in formula cell(in our case, Bonus Cell) Data > What If Analysis> Goal Seek  Goal Seek dialog box appears in which supply following deta...