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...

Hi, every one, it has been a long time, since my last post in Feb 2012 as i was busy with some of new Books and of course the translations of the same. Here,  we are going to learn about Microsoft Excels 2010 New feature : Spark lines. What is SparkLine??? Sparklines can be defined as " a short single cell chart prepared on specified range of numeric cells" . This is a new feature introduced with Excel 2010 and provides you feasibility to create short charts that can be place anywhere in your worksheet. Major remarkable feature of Sparklines is that "it takes very less space on sheet and are quite easy to manage" Various formatting options are available as Sparklines  Tools and we may set formatting as per our requirements. Now we are going to study the complete process of preparing and managing sparklines. Step 1: Open Microsoft Office Excel 2010 and create a blank workbook( if you are already have an existing data file, skip this step and continue wit...