Posts

Showing posts from 2012

How to merge Scenarios in EXCEL 2010

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

Sparkling Text using Photoshop CS5.5

Image
Sparkling Text: Add Sparkle to your Name Create a new Photoshop document with following specification Set the Fore Ground color to # 09531f and Background color to #f9d46. Choose Gradient Fill and their in Radial Fill to fill the Background of your Photoshop Document Your Photoshop document looks something like shown below Now Filter>Noise > Add Noise and do the setting as shown below:   Afterwards, Filter> Blur>Gaussian Blur   Now, Choose the Horizontal Text Tool and click to type some text, like shown below   Let us now begin with our desired task of making our text to SPARKLE. So  , now we are going to play with Layer Styles , Double click the Text Layer to open the Layer Style dialog box and perform all the settings given in the following steps. However, one must not be afraid of playing with colors and other layer style setting to get more interesting results, one of which I am going to show you ...

How to get Print dialog using JavaScript in ASP.net Page

Image
Hello, and very Good Morning to all. Today, I am going to show you a simple and quicker way to get a Print Dialog Box on your ASP.Net page via JavaScript. Just follow the code given below: <html > <head> <title>Untitled Document</title> <script language="javascript" type="text/javascript">                                 function check_print()                                 {                                            ...

Excel: Sparklines

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

All C programs Solutions

C-Ready Program Solutions Question : Entering Data & other Operations on 2D Numeric Array main() {                 int num[3][3],r,c;                 int sum;                 clrscr();                 printf("Entering Data:");                 getch();                 for(r=0;r<3;r=r+1)                 {                           ...