Excel Tips

For back up the contacts or moving contacts, we require to export contacts from Outlook. One of the way is to save the contacts in Excel CSV format. Saving contacts of MS outlook 2010 in CSV formats has many advantages such as searching and ordering of contacts in Excel or Access. Even though Outlook 2010 supports, exporting [...]

Creating Templates in Excel

Excel templates are very useful whenever we need to do repeated tasks. Excel VBA does it. But Excel VBA is a little hard to learn and implement.Excel templates is nothing but pre defined format. For example if you want to get Agent productivity report in Excel. You have raw reports which has productive hours, non [...]

Multi Conditional lookup in Excel

Have you ever came across a situation wherein you wanted to return a value which matches both row and column?. Vlookup function in Excel returns the value which is matching the row only. In our previous tutorial, we have shown how to perform two column lookup. In this excel tips post, we will guide you [...]

Using Loops in Excel VBA

Looping is used to repeatedly running a set of codes till it completes given condition. The loops are the fundamental component of any programming Language. In Excel VBA too there are many loop constructs. Let us have a close look into basic loop constructs.Basic Loop constructs of Excel VBA:For…..nextDo……WhileDo……UntilWhile……….LoopFor Each……NextFor……Next Loop:This loop is used when there [...]

Removing Duplicates in Excel

We sometime look for easy way to remove duplicate  entries from a large table without any filters or complicated formulas. Starting Office 2007, Microsoft added a direct method to remove duplicates from a range.  There is one shortfall in this method which I will describe later. Use mouse or keyboard arrow keys with “Shift” button [...]

Rotating Tables in Excel

After we create a  tables in Excel, we will realize that the columns could be better as rows and vice versa. So in this post we will have a look into excel tip which describes how to rotate tables or swapping columns and rows in Excel. This tip will work on Excel XP, Excel 2003, [...]

1 2 6 7 8 9