Idyllic Other Layouts

Month: April 2012

Excel Freeze Panes Overview When working with very large spreadsheets headings located at the top and down the left side of the worksheet often disappear if you scroll too far to the right or down. Without the headings, it’s hard to keep track of which column or row of data…

It’s very important to learn some simple tricks to go on the way of preparing “DASHBOARD”. Here we’ll learn one part of the dashboard. The circled part is what we’ll learn here. Let’s say you want to show 50% of some target as completed. Here is how it works. 1>…

Here is a quick Excel tip to kick start your time. Sometimes, we want to enter same data in to several cells. You can use CTRL+Enter to do this in a snap. Select all the cells where you want to enter the same data. Type the data Press CTRL+Enter Done!…

Getting Unique Items from a List of Cells There are 3 simple ways to do this: Using Advanced Data Filter Using countif() and auto filter Using formulas as described here Assuming you have data as shown in the picture aside (and wishing you will have customers like those): First add…

Your boss is a rigid. He says you should double underline the grand total in a report. As the results show in the below figure, you only have an underline icon on the Formatting toolbar. So, what do you do now? Select the Grand Total cell. From the menu, select…