Posted by Shikha on April 30th, 2008
This article explains how to deal with a situation when your keyboard gets locked without you even knowing it.
Read the rest of this entry »
Popularity: 39%
Posted by Shikha on April 29th, 2008
This article shows how to reach other tabs in a workbook quickly when you have lots of them. Apart from simple “CTRL+PageUP/Pagedown” option, it talks about other alternate solutions like “Excel’s activate sheet option” and “Insert hyperlink” which are less time consuming and more efficient ways to navigate comfortably between worksheets.
Read the rest of this entry »
Popularity: 20%
Posted by Shikha on April 29th, 2008
This article describes in detail why excel takes so long to open and how can you get around it.
Read the rest of this entry »
Popularity: 23%
Posted by Shikha on April 14th, 2008
This article shows how to generate a list of all the worksheet names on a worksheet.
Read the rest of this entry »
Popularity: 38%
Posted by Shikha on April 14th, 2008
This article introduces you to “Define Name” feature of excel with which you can give a name to any cell or range of cells and then just use that particular name in other formula’s like vlookup, offset, match etc without having to select it manually every time.
Read the rest of this entry »
Popularity: 18%
Posted by Shikha on April 14th, 2008
This article shows how to get the count using more than one criteria. Additionally, it talks about the “conditional formatting” feature which highlights the important results and spares you the inconvenience of having to look at everything in detail.
Read the rest of this entry »
Popularity: 34%
Posted by Shikha on April 5th, 2008
This article shows how to take screenshots in general and also gives special methods which are excel specific.
Read the rest of this entry »
Popularity: 27%
