Isn’t it exciting to have the ability to create your own right-click menu and customize it according to your needs. The default right-click menu doesn’t give much options.
Let’s add some frills to it:
1) Make list
How would you like the idea of creating the list of all the files that are in your folder in just one click?
Here’s the way to do it: Read the rest of this entry »
I have - Table 1 and Table 2
How can I bring salary information in table 2 from table 1 for corresponding dept and jobcode?
Our take on this excel problem
You can join Department and Job Code in both table 1 as well as 2 using concatenate function. And then using vlookup function, you can look up salary from table 1 for a particular department and job code in table 2 as shown below:
Step 1: Concatenate column B and column C
Step 2: Vlookup on the new concatenate column just created
Hope this helps.
General October 21st, 2008
If you want to create a new workbook in some folder and you are already there, then instead of clicking on excel icon and then making your way to the folder by clicking down through the folders until you reach the desired location where you want to save your file. Simply right click in the desired folder and then select New and choose microsoft office excel worksheet. And just rename it.
This article gives you an example of where we may need to keep our formulas intact.
Sometimes 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.
If 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
3.Click on the General tab
4.Enter a new path in Default File Location and hit OK.
This article explains how we can have A-Z letters on a column without typing them in manually.
This article explains how to deal with a situation when your keyboard gets locked without you even knowing it.
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.
This article describes in detail why excel takes so long to open and how can you get around it.
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.
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.
Clever Excel formulas March 30th, 2008
Did you ever wonder why can’t you find asterisk and question mark in your spreadsheet.This article explains it all.
General March 24th, 2008
Did 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.
Excel shortcuts 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.