Finding external links
Posted by Shikha on July 15th, 2008This article shows how to locate cells in active workbook which contain links to external workbooks.
Share This
Popularity: 10%
Indirect Function
Posted by Shikha on July 2nd, 2008Sometimes we want to pull out data on one sheet from different worksheets, all of them having the same structure.We can do that using the vlookup or hlookup function as the case may be. However, while selecting the appropriate range we will have to go to each tab and select the range manually. This can be very time consuming especially if there are lots of tabs. Excel’s indirect function can help us get around this.
Share ThisPopularity: 13%
Choosing your own “Save File” location
Posted by Shikha on June 27th, 2008If we save some file without giving the path, then it will automatically get saved at the default location. We can change the Default File Location as:
1.Click on the Tools menu
2.Choose Options
3.Click on the General tab
4.Enter a new path in Default File Location and hit OK.
Popularity: 9%
Alphabetic Series on Excel
Posted by Shikha on June 4th, 2008This article explains how we can have A-Z letters on a column without typing them in manually.
Share ThisPopularity: 22%
How to unlock keyboard??
Posted by Shikha on April 30th, 2008This article explains how to deal with a situation when your keyboard gets locked without you even knowing it.
Share ThisPopularity: 17%
Accessing other worksheets in a workbook faster
Posted by Shikha on April 29th, 2008This 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.
Share ThisPopularity: 16%
10 ways to open excel faster
Posted by Shikha on April 29th, 2008This article describes in detail why excel takes so long to open and how can you get around it.
Share ThisPopularity: 20%
List Worksheet Names
Posted by Shikha on April 14th, 2008This article shows how to generate a list of all the worksheet names on a worksheet.
Share This
Popularity: 26%
Naming cells in Excel
Posted by Shikha on April 14th, 2008This 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.
Share This
Popularity: 15%
Sumif array formula OR countif function
Posted by Shikha on April 14th, 2008This 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.
Share This
Popularity: 28%
Excel’s Images and Screenshots
Posted by Shikha on April 5th, 2008This article shows how to take screenshots in general and also gives special methods which are excel specific.
Share This
Popularity: 24%
How to find or replace asterisk(*) and question mark(?) in MS excel??
Posted by Shikha on March 30th, 2008Did you ever wonder why can’t you find asterisk and question mark in your spreadsheet.This article explains it all.
Share ThisPopularity: 26%
Run Command shortcuts
Posted by Shikha on March 30th, 2008This article gives you a quick and easy way to access applications like excel, word, notepad, mspaint, internet explorer etc. In addition, it shows how to display “Run” tab on the start menu.
Share This
Popularity: 20%
Splitting Large Excel files into smaller parts using Winzip
Posted by Shikha on March 24th, 2008Did you ever have problems sending excel files of several MBs through your email systems?? Sometimes it rejects it because it exceeds the quota size or takes forever to send…….This article shows how to split huge excel files into smaller parts which can easily be sent.Plus, it explains how to put them back together.
Share This
Popularity: 16%
How to add “My Recent Documents” to the Start Menu?
Posted by Shikha on March 10th, 2008
This article is about how to access your recent documents. Most of you would be familiar with the “My Recent Documents” option on the “Start” Menu but this just shows 15 recently visited files….Which is clearly not enough so in this article we have given alternate options which are more comprehensive.
Share ThisPopularity: 32%
Generating list of contents of any folder
Posted by Shikha on March 5th, 2008This article shows how to make a list of the folders, or even the files inside a folder on an excel spreadsheet.This is a very useful tool as it is impossible to type in the names manually especially when there are plenty of files.
Share ThisPopularity: 41%
Now share your excel sheets using Microsoft’s Office Live Workspace
Posted by Shikha on March 5th, 2008Performing Two-Criteria Lookup
Posted by Shikha on January 26th, 2008At first sight, this article may look long-winded to you, but trust me, with a little concentration and patience, this article alone can help you master all the difficult excel functions like offset, indirect, index, match etc. So, if you are ready to take the plunge, here is the magic article.
Share ThisPopularity: 88%
Dragging a formula down
Posted by Shikha on January 16th, 2008This article shows the magic of Shift and Control keys and how we can use them with arrow keys to work faster.
Share ThisPopularity: 21%
Insert Excel Spreadsheet into Microsoft Word Document
Posted by Shikha on January 15th, 2008This article is a basic guideline on how to insert excel spreadsheet into word document. It gives a comprehensive list of the available options and describes each one of them in graphic detail.
Share ThisPopularity: 100%