<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" media="screen" href="/~d/styles/rss2full.xsl"?><?xml-stylesheet type="text/css" media="screen" href="http://feeds.feedburner.com/~d/styles/itemcontent.css"?><rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:sy="http://purl.org/rss/1.0/modules/syndication/" version="2.0">

<channel>
	<title>Handy Excel Tips</title>
	
	<link>http://www.handyexceltips.com</link>
	<description>MS Excel Tips, Shortcuts and Techniques to Increase Your Excel Productivity</description>
	<pubDate>Wed, 10 Jun 2009 04:37:46 +0000</pubDate>
	<generator>http://wordpress.org/?v=2.7.1</generator>
	<language>en</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
			<atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="self" href="http://feeds.feedburner.com/HandyExcelTips" type="application/rss+xml" /><feedburner:emailServiceId xmlns:feedburner="http://rssnamespace.org/feedburner/ext/1.0">HandyExcelTips</feedburner:emailServiceId><feedburner:feedburnerHostname xmlns:feedburner="http://rssnamespace.org/feedburner/ext/1.0">http://feedburner.google.com</feedburner:feedburnerHostname><item>
		<title>Reader’s Questions - Performing two-way look up</title>
		<link>http://www.handyexceltips.com/2009/03/16/readers-questions-performing-two-way-look-up/</link>
		<comments>http://www.handyexceltips.com/2009/03/16/readers-questions-performing-two-way-look-up/#comments</comments>
		<pubDate>Mon, 16 Mar 2009 20:08:43 +0000</pubDate>
		<dc:creator>Shikha</dc:creator>
		
		<category><![CDATA[Clever Excel formulas]]></category>

		<guid isPermaLink="false">http://www.handyexceltips.com/?p=269</guid>
		
			<content:encoded><![CDATA[Question:
I have - Table 1 and Table 2
How can I bring salary information in table 2 from table 1 for corresponding dept and jobcode?
Thanks
Bob Lee

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, [...]<br/>
<br/>
[Visit website to continue reading the article]]]></content:encoded>
			<wfw:commentRss>http://www.handyexceltips.com/2009/03/16/readers-questions-performing-two-way-look-up/feed/</wfw:commentRss>
		</item>
		<item>
		<title>How to copy and paste values in filtered data?</title>
		<link>http://www.handyexceltips.com/2008/11/11/how-to-copy-and-paste-values-in-filtered-data/</link>
		<comments>http://www.handyexceltips.com/2008/11/11/how-to-copy-and-paste-values-in-filtered-data/#comments</comments>
		<pubDate>Tue, 11 Nov 2008 13:57:11 +0000</pubDate>
		<dc:creator>Shikha</dc:creator>
		
		<category><![CDATA[Clever Excel formulas]]></category>

		<guid isPermaLink="false">http://www.handyexceltips.com/2008/11/11/how-to-copy-and-paste-values-in-filtered-data/</guid>
		
			<content:encoded><![CDATA[If you copy and paste values from one column to another, when the filter is on and the range is discontinuous,  then it won&#8217;t work and will paste the data into non-visible cells as well.

As an example, I have taken some values in column A and B as shown below:

Now if I apply filter on [...]<br/>
<br/>
[Visit website to continue reading the article]]]></content:encoded>
			<wfw:commentRss>http://www.handyexceltips.com/2008/11/11/how-to-copy-and-paste-values-in-filtered-data/feed/</wfw:commentRss>
		</item>
		<item>
		<title>Save a new worksheet directly in the desired folder</title>
		<link>http://www.handyexceltips.com/2008/10/21/save-a-new-worksheet-directly-in-the-desired-folder/</link>
		<comments>http://www.handyexceltips.com/2008/10/21/save-a-new-worksheet-directly-in-the-desired-folder/#comments</comments>
		<pubDate>Tue, 21 Oct 2008 04:17:51 +0000</pubDate>
		<dc:creator>Shikha</dc:creator>
		
		<category><![CDATA[General]]></category>

		<guid isPermaLink="false">http://www.handyexceltips.com/2008/10/21/save-a-new-worksheet-directly-in-the-desired-folder/</guid>
		
			<content:encoded><![CDATA[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 [...]<br/>
<br/>
[Visit website to continue reading the article]]]></content:encoded>
			<wfw:commentRss>http://www.handyexceltips.com/2008/10/21/save-a-new-worksheet-directly-in-the-desired-folder/feed/</wfw:commentRss>
		</item>
		<item>
		<title>Freezing Formulas</title>
		<link>http://www.handyexceltips.com/2008/09/05/freezing-formulas/</link>
		<comments>http://www.handyexceltips.com/2008/09/05/freezing-formulas/#comments</comments>
		<pubDate>Fri, 05 Sep 2008 09:27:11 +0000</pubDate>
		<dc:creator>Shikha</dc:creator>
		
		<category><![CDATA[Clever Excel formulas]]></category>

		<guid isPermaLink="false">http://www.handyexceltips.com/2008/09/05/freezing-formulas/</guid>
		
			<content:encoded><![CDATA[This article gives you an example of where we may need to keep our formulas intact.

Suppose there are two tabs- Jan and Feb. And they both contain the same fields with exactly the same location. For e.g. Both Jan and Feb have 4 fields as shown below:

Now in the Summary tab, we want to bring [...]<br/>
<br/>
[Visit website to continue reading the article]]]></content:encoded>
			<wfw:commentRss>http://www.handyexceltips.com/2008/09/05/freezing-formulas/feed/</wfw:commentRss>
		</item>
		<item>
		<title>Finding external links</title>
		<link>http://www.handyexceltips.com/2008/07/15/finding-external-links/</link>
		<comments>http://www.handyexceltips.com/2008/07/15/finding-external-links/#comments</comments>
		<pubDate>Tue, 15 Jul 2008 12:18:13 +0000</pubDate>
		<dc:creator>Shikha</dc:creator>
		
		<category><![CDATA[Excel Functions]]></category>

		<category><![CDATA[Macros]]></category>

		<guid isPermaLink="false">http://www.handyexceltips.com/2008/07/15/finding-external-links/</guid>
		
			<content:encoded><![CDATA[This article shows how to locate cells in active workbook which contain links to external workbooks.
If your workbook contains links to other workbooks, you can locate the source files in the &#8220;Links&#8221; tab of the &#8220;Edit&#8221; Menu.

However, this will only show you the external workbook names but would not tell you where these external links [...]<br/>
<br/>
[Visit website to continue reading the article]]]></content:encoded>
			<wfw:commentRss>http://www.handyexceltips.com/2008/07/15/finding-external-links/feed/</wfw:commentRss>
		</item>
		<item>
		<title>Indirect Function</title>
		<link>http://www.handyexceltips.com/2008/07/02/indirect-function/</link>
		<comments>http://www.handyexceltips.com/2008/07/02/indirect-function/#comments</comments>
		<pubDate>Wed, 02 Jul 2008 17:44:52 +0000</pubDate>
		<dc:creator>Shikha</dc:creator>
		
		<category><![CDATA[Excel Functions]]></category>

		<guid isPermaLink="false">http://www.handyexceltips.com/2008/07/02/indirect-function/</guid>
		
			<content:encoded><![CDATA[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 [...]<br/>
<br/>
[Visit website to continue reading the article]]]></content:encoded>
			<wfw:commentRss>http://www.handyexceltips.com/2008/07/02/indirect-function/feed/</wfw:commentRss>
		</item>
		<item>
		<title>Choosing your own “Save File” location</title>
		<link>http://www.handyexceltips.com/2008/06/27/choosing-your-own-save-file-location/</link>
		<comments>http://www.handyexceltips.com/2008/06/27/choosing-your-own-save-file-location/#comments</comments>
		<pubDate>Fri, 27 Jun 2008 09:56:21 +0000</pubDate>
		<dc:creator>Shikha</dc:creator>
		
		<category><![CDATA[General]]></category>

		<guid isPermaLink="false">http://www.handyexceltips.com/2008/06/27/choosing-your-own-save-file-location/</guid>
		
			<content:encoded><![CDATA[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
2.Choose Options
3.Click on the General tab
4.Enter a new path in Default File Location and hit OK.
Share This
Similar Posts:How to add &#8220;My Recent Documents&#8221; to the [...]<br/>
<br/>
[Visit website to continue reading the article]]]></content:encoded>
			<wfw:commentRss>http://www.handyexceltips.com/2008/06/27/choosing-your-own-save-file-location/feed/</wfw:commentRss>
		</item>
		<item>
		<title>Alphabetic Series on Excel</title>
		<link>http://www.handyexceltips.com/2008/06/04/alphabetic-series-on-excel/</link>
		<comments>http://www.handyexceltips.com/2008/06/04/alphabetic-series-on-excel/#comments</comments>
		<pubDate>Wed, 04 Jun 2008 10:35:22 +0000</pubDate>
		<dc:creator>Shikha</dc:creator>
		
		<category><![CDATA[Excel Functions]]></category>

		<category><![CDATA[Excel shortcuts]]></category>

		<guid isPermaLink="false">http://www.handyexceltips.com/2008/06/04/alphabetic-series-on-excel/</guid>
		
			<content:encoded><![CDATA[This article explains how we can have A-Z letters on a column without typing them in manually.

If we want a number series say 1-100, we can simply drag the cursor to expand the series. But if we instead need an alphabetic series say we require A-Z in column A then simple dragging system would not [...]<br/>
<br/>
[Visit website to continue reading the article]]]></content:encoded>
			<wfw:commentRss>http://www.handyexceltips.com/2008/06/04/alphabetic-series-on-excel/feed/</wfw:commentRss>
		</item>
		<item>
		<title>How to unlock keyboard??</title>
		<link>http://www.handyexceltips.com/2008/04/30/how-to-unlock-keyboard/</link>
		<comments>http://www.handyexceltips.com/2008/04/30/how-to-unlock-keyboard/#comments</comments>
		<pubDate>Wed, 30 Apr 2008 14:37:10 +0000</pubDate>
		<dc:creator>Shikha</dc:creator>
		
		<category><![CDATA[General]]></category>

		<guid isPermaLink="false">http://www.handyexceltips.com/2008/04/30/how-to-unlock-keyboard/</guid>
		
			<content:encoded><![CDATA[This article explains how to deal with a situation when your keyboard gets locked without you even knowing it.

Holding down shift key for more than 8 seconds will lock the keyboard and it will stop responding. But if you keep pressing keys for few seconds you would be able to type in but it will [...]<br/>
<br/>
[Visit website to continue reading the article]]]></content:encoded>
			<wfw:commentRss>http://www.handyexceltips.com/2008/04/30/how-to-unlock-keyboard/feed/</wfw:commentRss>
		</item>
		<item>
		<title>Accessing other worksheets in a workbook faster</title>
		<link>http://www.handyexceltips.com/2008/04/29/accessing-other-worksheets-in-a-workbook-faster/</link>
		<comments>http://www.handyexceltips.com/2008/04/29/accessing-other-worksheets-in-a-workbook-faster/#comments</comments>
		<pubDate>Tue, 29 Apr 2008 22:21:57 +0000</pubDate>
		<dc:creator>Shikha</dc:creator>
		
		<category><![CDATA[Excel shortcuts]]></category>

		<guid isPermaLink="false">http://www.handyexceltips.com/2008/04/29/accessing-other-worksheets-in-a-workbook-faster/</guid>
		
			<content:encoded><![CDATA[This article shows how to reach other tabs in a workbook quickly when you have lots of them. Apart from simple &#8220;CTRL+PageUP/Pagedown&#8221; option, it talks about other alternate solutions like &#8220;Excel&#8217;s activate sheet option&#8221; and &#8220;Insert hyperlink&#8221; which are less time consuming and more efficient ways to navigate comfortably between worksheets.

If you have lots of [...]<br/>
<br/>
[Visit website to continue reading the article]]]></content:encoded>
			<wfw:commentRss>http://www.handyexceltips.com/2008/04/29/accessing-other-worksheets-in-a-workbook-faster/feed/</wfw:commentRss>
		</item>
		<item>
		<title>10 ways to open excel faster</title>
		<link>http://www.handyexceltips.com/2008/04/29/10-ways-to-open-excel-more-quickly/</link>
		<comments>http://www.handyexceltips.com/2008/04/29/10-ways-to-open-excel-more-quickly/#comments</comments>
		<pubDate>Tue, 29 Apr 2008 15:20:09 +0000</pubDate>
		<dc:creator>Shikha</dc:creator>
		
		<category><![CDATA[General]]></category>

		<guid isPermaLink="false">http://www.handyexceltips.com/2008/04/29/10-ways-to-open-excel-more-quickly/</guid>
		
			<content:encoded><![CDATA[This article describes in detail why excel takes so long to open and how can you get around it.
If your excel takes forever to open, try out the following solutions&#8230;atleast one of them is sure to work.
1) Add more RAM:
Excel consumes a lot of memory so make sure you have enough RAM. For XP, you [...]<br/>
<br/>
[Visit website to continue reading the article]]]></content:encoded>
			<wfw:commentRss>http://www.handyexceltips.com/2008/04/29/10-ways-to-open-excel-more-quickly/feed/</wfw:commentRss>
		</item>
		<item>
		<title>List Worksheet Names</title>
		<link>http://www.handyexceltips.com/2008/04/14/list-worksheet-names/</link>
		<comments>http://www.handyexceltips.com/2008/04/14/list-worksheet-names/#comments</comments>
		<pubDate>Mon, 14 Apr 2008 19:09:43 +0000</pubDate>
		<dc:creator>Shikha</dc:creator>
		
		<category><![CDATA[Macros]]></category>

		<guid isPermaLink="false">http://www.handyexceltips.com/2008/04/14/list-worksheet-names/</guid>
		
			<content:encoded><![CDATA[This article shows how to generate a list of all the worksheet names on a worksheet. 
To list tab names in excel, we can use the following macro:
Sub ListWorkSheetNames()
Dim Sheetnames
Sheetnames = Sheets.Count
Sheets.Add
ActiveSheet.Name = &#8220;SheetList&#8221;
Sheets(&#8221;SheetList&#8221;).Move after:=Sheets(Sheetnames + 1)
For i = 1 To Sheetnames
Range(&#8221;A&#8221; &#38; i) = Sheets(i).Name
Next i
End...<br/>
<br/>
[Visit website to continue reading the article]]]></content:encoded>
			<wfw:commentRss>http://www.handyexceltips.com/2008/04/14/list-worksheet-names/feed/</wfw:commentRss>
		</item>
		<item>
		<title>Naming cells in Excel</title>
		<link>http://www.handyexceltips.com/2008/04/14/naming-cells-in-excel/</link>
		<comments>http://www.handyexceltips.com/2008/04/14/naming-cells-in-excel/#comments</comments>
		<pubDate>Mon, 14 Apr 2008 16:40:57 +0000</pubDate>
		<dc:creator>Shikha</dc:creator>
		
		<category><![CDATA[Excel shortcuts]]></category>

		<guid isPermaLink="false">http://www.handyexceltips.com/2008/04/14/naming-cells-in-excel/</guid>
		
			<content:encoded><![CDATA[This article introduces you to &#8220;Define Name&#8221; 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&#8217;s like vlookup, offset, match etc without having to select it manually every time.

Naming cells comes in very handy when you need [...]<br/>
<br/>
[Visit website to continue reading the article]]]></content:encoded>
			<wfw:commentRss>http://www.handyexceltips.com/2008/04/14/naming-cells-in-excel/feed/</wfw:commentRss>
		</item>
		<item>
		<title>Sumif array formula OR countif function</title>
		<link>http://www.handyexceltips.com/2008/04/14/sumif-array-formula-or-countif-function/</link>
		<comments>http://www.handyexceltips.com/2008/04/14/sumif-array-formula-or-countif-function/#comments</comments>
		<pubDate>Mon, 14 Apr 2008 08:56:52 +0000</pubDate>
		<dc:creator>Shikha</dc:creator>
		
		<category><![CDATA[Clever Excel formulas]]></category>

		<guid isPermaLink="false">http://www.handyexceltips.com/2008/04/14/sumif-array-formula-or-countif-function/</guid>
		
			<content:encoded><![CDATA[This article shows how to get the count using more than one criteria. Additionally, it talks about the &#8220;conditional formatting&#8221; feature which highlights the important results and spares you the inconvenience of having to look at everything in detail.
Countif function can be used to count the number of entries in some column based on a [...]<br/>
<br/>
[Visit website to continue reading the article]]]></content:encoded>
			<wfw:commentRss>http://www.handyexceltips.com/2008/04/14/sumif-array-formula-or-countif-function/feed/</wfw:commentRss>
		</item>
		<item>
		<title>Excel’s Images and Screenshots</title>
		<link>http://www.handyexceltips.com/2008/04/05/excels-images/</link>
		<comments>http://www.handyexceltips.com/2008/04/05/excels-images/#comments</comments>
		<pubDate>Sat, 05 Apr 2008 18:34:28 +0000</pubDate>
		<dc:creator>Shikha</dc:creator>
		
		<category><![CDATA[General]]></category>

		<guid isPermaLink="false">http://www.handyexceltips.com/2008/04/05/excels-images/</guid>
		
			<content:encoded><![CDATA[This article shows how to take screenshots in general and also gives special methods which are excel specific.

Sometimes for presentation purposes, you only want to pin-point certain areas in your excel spreadsheet, especially when you have a huge spreadsheet with loads of tabs. You can do this by taking images of your relevant tabs. And [...]<br/>
<br/>
[Visit website to continue reading the article]]]></content:encoded>
			<wfw:commentRss>http://www.handyexceltips.com/2008/04/05/excels-images/feed/</wfw:commentRss>
		</item>
	</channel>
</rss>
