http://www.mrexcel.com Learn Excel from Bill Jelen with this daily 2 minute video podcast! en Consult@MrExcel.com (Bill Jelen) podcasts@libsyn.com (Liberated Syndication) Liberated Syndication - libsyn.com Thu, 24 Dec 2009 08:30:00 GMT 180 8619613425Learn Excel from Bill Jelen with this daily 2 minute video podcast. Excel,Microsoft,Excel,MrExcel Bill Jelen consult@mrexcel.com Bill Jelen http://www.feedburner.comhttp://www.feedburner.com/fb/images/pub/fb_pwrd.gif no (c) 2006 Bill JelenExcel,Microsoft,Excel,MrExcelTechnology/Tech News40.98256-81.39754This is an XML content feed. It is intended to be viewed in a newsreader or syndicated to another site, subject to copyright and fair use. http://feedproxy.google.com/~r/feedburner/WeAK/~3/4TC3u5DcXCM/index.php <p><a href="http://feedads.g.doubleclick.net/~a/B8bq9CU3erg5p2vgb9dhALQJnpM/0/da"><img src="http://feedads.g.doubleclick.net/~a/B8bq9CU3erg5p2vgb9dhALQJnpM/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/B8bq9CU3erg5p2vgb9dhALQJnpM/1/da"><img src="http://feedads.g.doubleclick.net/~a/B8bq9CU3erg5p2vgb9dhALQJnpM/1/di" border="0" ismap="true"></img></a></p><font size="2"><p>In today's dueling podcast, we need to look up a value in one of three different tables depending on the product selected. Mike and Bill show many ways to solve the problem in Episode 1165.</p> </font><img src="http://feeds.feedburner.com/~r/LearnExcelFromMrexcelPodcast/~4/5tR9Bkxu-n0" height="1" width="1"/><img src="http://feeds.feedburner.com/~r/feedburner/WeAK/~4/4TC3u5DcXCM" height="1" width="1"/> Vidcast Thu, 24 Dec 2009 08:30:00 GMT http://mrexcel.libsyn.com/index.php?post_id=563154# VLOOKUP, Excel Bill Jelen Change the lookup table based on the product sold Clean consult@MrExcel.com (Bill Jelen)http://mrexcel.libsyn.com/index.php?post_id=563154#http://feedproxy.google.com/~r/LearnExcelFromMrexcelPodcast/~3/5tR9Bkxu-n0/index.php http://feedproxy.google.com/~r/feedburner/WeAK/~3/EakSC9R0vkI/index.php <p><a href="http://feedads.g.doubleclick.net/~a/pROrtLvLnGdRoSsfK8J2r7CLA5M/0/da"><img src="http://feedads.g.doubleclick.net/~a/pROrtLvLnGdRoSsfK8J2r7CLA5M/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/pROrtLvLnGdRoSsfK8J2r7CLA5M/1/da"><img src="http://feedads.g.doubleclick.net/~a/pROrtLvLnGdRoSsfK8J2r7CLA5M/1/di" border="0" ismap="true"></img></a></p><font size="2"><p dir="ltr">Brent asked me how I managed to draw a curved arrow on a worksheet. Episode 1164 takes a look at how to customize the drawing tools to draw in curved arrows.</p> </font><img src="http://feeds.feedburner.com/~r/LearnExcelFromMrexcelPodcast/~4/IkMCO1ULhMM" height="1" width="1"/><img src="http://feeds.feedburner.com/~r/feedburner/WeAK/~4/EakSC9R0vkI" height="1" width="1"/> Vidcast Wed, 23 Dec 2009 13:29:00 GMT http://mrexcel.libsyn.com/index.php?post_id=563152# Excel, business, accounting, spreadsheets, tutorial, technology, MrExcel, Drawing, Arrows Bill Jelen Draw a curved arrow to show a connection between two cells Clean consult@MrExcel.com (Bill Jelen)http://mrexcel.libsyn.com/index.php?post_id=563152#http://feedproxy.google.com/~r/LearnExcelFromMrexcelPodcast/~3/IkMCO1ULhMM/index.php http://feedproxy.google.com/~r/feedburner/WeAK/~3/ePte--oZj_0/index.php <p><a href="http://feedads.g.doubleclick.net/~a/8scajY2_eBERM4HFcVwoVG2tNW8/0/da"><img src="http://feedads.g.doubleclick.net/~a/8scajY2_eBERM4HFcVwoVG2tNW8/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/8scajY2_eBERM4HFcVwoVG2tNW8/1/da"><img src="http://feedads.g.doubleclick.net/~a/8scajY2_eBERM4HFcVwoVG2tNW8/1/di" border="0" ismap="true"></img></a></p><font size="2"><p>Shaun has a large worksheet with 12 monthly reports on it. On a summary worksheet, he would like to show one particular month based on a dropdown. Episode 1163 discusses Paste Special Column Widths, Array Formulas, Match, and OFFSET.</p> </font><img src="http://feeds.feedburner.com/~r/LearnExcelFromMrexcelPodcast/~4/qfZG-OZeypM" height="1" width="1"/><img src="http://feeds.feedburner.com/~r/feedburner/WeAK/~4/ePte--oZj_0" height="1" width="1"/> Vidcast Tue, 22 Dec 2009 14:00:00 GMT http://mrexcel.libsyn.com/index.php?post_id=562357# Excel, Month, Report Bill Jelen Choose a month, show the correct report in Excel Clean consult@MrExcel.com (Bill Jelen)http://mrexcel.libsyn.com/index.php?post_id=562357#http://feedproxy.google.com/~r/LearnExcelFromMrexcelPodcast/~3/qfZG-OZeypM/index.php http://feedproxy.google.com/~r/feedburner/WeAK/~3/DGhVnfHdxKE/index.php <p><a href="http://feedads.g.doubleclick.net/~a/FuSDLCArmZEN_vfFZOSBzdSbEEo/0/da"><img src="http://feedads.g.doubleclick.net/~a/FuSDLCArmZEN_vfFZOSBzdSbEEo/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/FuSDLCArmZEN_vfFZOSBzdSbEEo/1/da"><img src="http://feedads.g.doubleclick.net/~a/FuSDLCArmZEN_vfFZOSBzdSbEEo/1/di" border="0" ismap="true"></img></a></p><font size="2"><p>A simple MATCH formula is not working. In episode 1162, we wander through the Validation dialog, the Name Manager dialog, all trying to figure out why the MATCH formula is returning #N/A.</p> </font><img src="http://feeds.feedburner.com/~r/LearnExcelFromMrexcelPodcast/~4/tGeIGB87gBI" height="1" width="1"/><img src="http://feeds.feedburner.com/~r/feedburner/WeAK/~4/DGhVnfHdxKE" height="1" width="1"/> Vidcast Mon, 21 Dec 2009 15:51:00 GMT http://mrexcel.libsyn.com/index.php?post_id=562355# Excel, Validation, MATCH, Formula Bill Jelen Figuring out why the MATCH of a dropdown cell is not working Clean consult@MrExcel.com (Bill Jelen)http://mrexcel.libsyn.com/index.php?post_id=562355#http://feedproxy.google.com/~r/LearnExcelFromMrexcelPodcast/~3/tGeIGB87gBI/index.php http://feedproxy.google.com/~r/feedburner/WeAK/~3/PchFwwnOlBQ/index.php <p><a href="http://feedads.g.doubleclick.net/~a/PYTXkZsdTdD3jDPdFOYAu4EzpMQ/0/da"><img src="http://feedads.g.doubleclick.net/~a/PYTXkZsdTdD3jDPdFOYAu4EzpMQ/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/PYTXkZsdTdD3jDPdFOYAu4EzpMQ/1/da"><img src="http://feedads.g.doubleclick.net/~a/PYTXkZsdTdD3jDPdFOYAu4EzpMQ/1/di" border="0" ismap="true"></img></a></p><font size="2"><p>Today's dueling podcast question is how to return the sum of all columns from a VLOOKUP. Mike and Bill show you various methods in episode 1161.</p> </font><img src="http://feeds.feedburner.com/~r/LearnExcelFromMrexcelPodcast/~4/iU_m81tk5jk" height="1" width="1"/><img src="http://feeds.feedburner.com/~r/feedburner/WeAK/~4/PchFwwnOlBQ" height="1" width="1"/> Vidcast Fri, 18 Dec 2009 14:00:00 GMT http://mrexcel.libsyn.com/index.php?post_id=561202# Excel, VLOOKUP Bill Jelen Return many columns in a VLOOKUP Clean consult@MrExcel.com (Bill Jelen)http://mrexcel.libsyn.com/index.php?post_id=561202#http://feedproxy.google.com/~r/LearnExcelFromMrexcelPodcast/~3/iU_m81tk5jk/index.php http://feedproxy.google.com/~r/feedburner/WeAK/~3/PvzPhGJtsfM/index.php <p><a href="http://feedads.g.doubleclick.net/~a/jY0yu21U4bPyRQ33h8tPlUfw_y8/0/da"><img src="http://feedads.g.doubleclick.net/~a/jY0yu21U4bPyRQ33h8tPlUfw_y8/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/jY0yu21U4bPyRQ33h8tPlUfw_y8/1/da"><img src="http://feedads.g.doubleclick.net/~a/jY0yu21U4bPyRQ33h8tPlUfw_y8/1/di" border="0" ismap="true"></img></a></p><font size="2"><p>Riham asks if there is any way to arrange the sheet tabs in two rows. While there is not, episode 1160 shows various ways of dealing with the issue.</p> </font><img src="http://feeds.feedburner.com/~r/LearnExcelFromMrexcelPodcast/~4/91RIn1YhDVw" height="1" width="1"/><img src="http://feeds.feedburner.com/~r/feedburner/WeAK/~4/PvzPhGJtsfM" height="1" width="1"/> Vidcast Thu, 17 Dec 2009 21:22:00 GMT http://mrexcel.libsyn.com/index.php?post_id=561191# Excel, Worksheets Bill Jelen Can you show worksheet tabs in two rows? Clean consult@MrExcel.com (Bill Jelen)http://mrexcel.libsyn.com/index.php?post_id=561191#http://feedproxy.google.com/~r/LearnExcelFromMrexcelPodcast/~3/91RIn1YhDVw/index.php http://feedproxy.google.com/~r/feedburner/WeAK/~3/EOiNUQjUENw/index.php <p><a href="http://feedads.g.doubleclick.net/~a/2sYQflnRmvth00RJJ4wIYkKaqGE/0/da"><img src="http://feedads.g.doubleclick.net/~a/2sYQflnRmvth00RJJ4wIYkKaqGE/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/2sYQflnRmvth00RJJ4wIYkKaqGE/1/da"><img src="http://feedads.g.doubleclick.net/~a/2sYQflnRmvth00RJJ4wIYkKaqGE/1/di" border="0" ismap="true"></img></a></p><font size="2"><p dir="ltr">Using PowerPivot for Excel 2010 to mashup data on two different worksheets. </p> <p dir="ltr">&nbsp;</p> </font><img src="http://feeds.feedburner.com/~r/LearnExcelFromMrexcelPodcast/~4/SOVBsp_vrlU" height="1" width="1"/><img src="http://feeds.feedburner.com/~r/feedburner/WeAK/~4/EOiNUQjUENw" height="1" width="1"/> Vidcast Wed, 16 Dec 2009 20:54:00 GMT http://mrexcel.libsyn.com/index.php?post_id=560808# PowerPivot Bill Jelen Pivoting 1.8 million Excel rows using PowerPivot Clean consult@MrExcel.com (Bill Jelen)http://mrexcel.libsyn.com/index.php?post_id=560808#http://feedproxy.google.com/~r/LearnExcelFromMrexcelPodcast/~3/SOVBsp_vrlU/index.php http://feedproxy.google.com/~r/feedburner/WeAK/~3/PC7GVD4Ed3w/index.php <p><a href="http://feedads.g.doubleclick.net/~a/ZuhBWSZkLl-9K56XwlzAMXVFmkg/0/da"><img src="http://feedads.g.doubleclick.net/~a/ZuhBWSZkLl-9K56XwlzAMXVFmkg/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/ZuhBWSZkLl-9K56XwlzAMXVFmkg/1/da"><img src="http://feedads.g.doubleclick.net/~a/ZuhBWSZkLl-9K56XwlzAMXVFmkg/1/di" border="0" ismap="true"></img></a></p><font size="2"><p>David asks how to use Text to Columns to grab the right-most two characters from a column. Episode 1158 shows you how.</p> </font><img src="http://feeds.feedburner.com/~r/LearnExcelFromMrexcelPodcast/~4/gJVCYDpYPyE" height="1" width="1"/><img src="http://feeds.feedburner.com/~r/feedburner/WeAK/~4/PC7GVD4Ed3w" height="1" width="1"/> Vidcast Tue, 15 Dec 2009 13:30:00 GMT http://mrexcel.libsyn.com/index.php?post_id=560278# formula Bill Jelen Grab the right-most two characters from a variable length cell Clean consult@MrExcel.com (Bill Jelen)http://mrexcel.libsyn.com/index.php?post_id=560278#http://feedproxy.google.com/~r/LearnExcelFromMrexcelPodcast/~3/gJVCYDpYPyE/index.php http://feedproxy.google.com/~r/feedburner/WeAK/~3/CV4hw5Z2a-M/index.php <p><a href="http://feedads.g.doubleclick.net/~a/mvODshOFd5NNBRftToFTu3bPBH4/0/da"><img src="http://feedads.g.doubleclick.net/~a/mvODshOFd5NNBRftToFTu3bPBH4/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/mvODshOFd5NNBRftToFTu3bPBH4/1/da"><img src="http://feedads.g.doubleclick.net/~a/mvODshOFd5NNBRftToFTu3bPBH4/1/di" border="0" ismap="true"></img></a></p><font size="2"><p>Announcing new software for Excel: Easy-XL adds 50 new data analysis features to Excel. Episode 1157 shows some of the cool features of Easy-XL.</p> </font><img src="http://feeds.feedburner.com/~r/LearnExcelFromMrexcelPodcast/~4/B8H8ob6DLM8" height="1" width="1"/><img src="http://feeds.feedburner.com/~r/feedburner/WeAK/~4/CV4hw5Z2a-M" height="1" width="1"/> Vidcast Mon, 14 Dec 2009 16:29:00 GMT http://mrexcel.libsyn.com/index.php?post_id=559881# utility Bill Jelen Easy-XL software for data analysis in Excel. Clean consult@MrExcel.com (Bill Jelen)http://mrexcel.libsyn.com/index.php?post_id=559881#http://feedproxy.google.com/~r/LearnExcelFromMrexcelPodcast/~3/B8H8ob6DLM8/index.php http://feedproxy.google.com/~r/feedburner/WeAK/~3/IebLF6iUJNM/index.php <p><a href="http://feedads.g.doubleclick.net/~a/D8hrRaLg6Qci7P7ju1KaMQJZtLE/0/da"><img src="http://feedads.g.doubleclick.net/~a/D8hrRaLg6Qci7P7ju1KaMQJZtLE/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/D8hrRaLg6Qci7P7ju1KaMQJZtLE/1/da"><img src="http://feedads.g.doubleclick.net/~a/D8hrRaLg6Qci7P7ju1KaMQJZtLE/1/di" border="0" ismap="true"></img></a></p><font size="2"><p>Ed asks how to assign a list of weekdays to a name in Excel. Episode 1156 shows you how.</p> <p>...This blog is the video podcast companion to the book, &lt;a href=&quot;http://www.mrexcel.com/learnexcel2.shtml&quot;&gt;Learn Excel 97-2007 from MrExcel&lt;/a&gt;. Download a new two minute video every workday to learn one of the 377 tips from the book!</p> </font><img src="http://feeds.feedburner.com/~r/LearnExcelFromMrexcelPodcast/~4/ALufXZrsFPs" height="1" width="1"/><img src="http://feeds.feedburner.com/~r/feedburner/WeAK/~4/IebLF6iUJNM" height="1" width="1"/> podcasts Fri, 11 Dec 2009 14:32:00 GMT http://mrexcel.libsyn.com/index.php?post_id=558888# Bill Jelen Name a list of Excel values Clean consult@MrExcel.com (Bill Jelen)http://mrexcel.libsyn.com/index.php?post_id=558888#http://feedproxy.google.com/~r/LearnExcelFromMrexcelPodcast/~3/ALufXZrsFPs/index.php http://feedproxy.google.com/~r/feedburner/WeAK/~3/rfVqZxrQMuE/index.php <p><a href="http://feedads.g.doubleclick.net/~a/RmEbZqrbPTrXWGxKIHAVSQEy7N0/0/da"><img src="http://feedads.g.doubleclick.net/~a/RmEbZqrbPTrXWGxKIHAVSQEy7N0/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/RmEbZqrbPTrXWGxKIHAVSQEy7N0/1/da"><img src="http://feedads.g.doubleclick.net/~a/RmEbZqrbPTrXWGxKIHAVSQEy7N0/1/di" border="0" ismap="true"></img></a></p><font size="2"><p>A question from Texas about setting up a chart in Excel. The goal is to show a mix of points that contain thousands and/or millions. While typing the K or M abbreviations might seem like a good way to get the table to appear, it is not a good way to have numbers that you can chart. Episode 1155 shows you how to solve the problem.</p> </font><img src="http://feeds.feedburner.com/~r/LearnExcelFromMrexcelPodcast/~4/ZR56EW3PiZk" height="1" width="1"/><img src="http://feeds.feedburner.com/~r/feedburner/WeAK/~4/rfVqZxrQMuE" height="1" width="1"/> podcasts Wed, 9 Dec 2009 13:25:00 GMT http://mrexcel.libsyn.com/index.php?post_id=558133# Format Bill Jelen Format numbers in thousands or millions No consult@MrExcel.com (Bill Jelen)http://mrexcel.libsyn.com/index.php?post_id=558133#http://feedproxy.google.com/~r/LearnExcelFromMrexcelPodcast/~3/ZR56EW3PiZk/index.php http://feedproxy.google.com/~r/feedburner/WeAK/~3/ede0RCRu44A/index.php <p><a href="http://feedads.g.doubleclick.net/~a/qbId7l0pxdrI0Gtw7hbkLzod8lI/0/da"><img src="http://feedads.g.doubleclick.net/~a/qbId7l0pxdrI0Gtw7hbkLzod8lI/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/qbId7l0pxdrI0Gtw7hbkLzod8lI/1/da"><img src="http://feedads.g.doubleclick.net/~a/qbId7l0pxdrI0Gtw7hbkLzod8lI/1/di" border="0" ismap="true"></img></a></p><font size="2"><p>Take geographic data from Excel and plot it as a route in MapPoint. Episode 1154 shows you how.</p> </font><img src="http://feeds.feedburner.com/~r/LearnExcelFromMrexcelPodcast/~4/xA4uwau0PrE" height="1" width="1"/><img src="http://feeds.feedburner.com/~r/feedburner/WeAK/~4/ede0RCRu44A" height="1" width="1"/> Vidcast Mon, 7 Dec 2009 16:40:00 GMT http://mrexcel.libsyn.com/index.php?post_id=557337# Bill Jelen No consult@MrExcel.com (Bill Jelen)http://mrexcel.libsyn.com/index.php?post_id=557337#http://feedproxy.google.com/~r/LearnExcelFromMrexcelPodcast/~3/xA4uwau0PrE/index.php http://feedproxy.google.com/~r/feedburner/WeAK/~3/i7LHZfXMpwk/index.php <p><a href="http://feedads.g.doubleclick.net/~a/vl2eEBCvucstiut0-k-wZLdkDvw/0/da"><img src="http://feedads.g.doubleclick.net/~a/vl2eEBCvucstiut0-k-wZLdkDvw/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/vl2eEBCvucstiut0-k-wZLdkDvw/1/da"><img src="http://feedads.g.doubleclick.net/~a/vl2eEBCvucstiut0-k-wZLdkDvw/1/di" border="0" ismap="true"></img></a></p>Lotfy from Egypt asks how to create a weekly report from daily transactional data. Mike and Bill show you several different methods in <a href="http://mrexcel.libsyn.com/media/mrexcel/podcast1153.mp4">Episode 1153</a>.<br/><br/>This blog is the video podcast companion to the book, <a href="http://www.mrexcel.com/learnexcel2.shtml">Learn Excel 97-2007 from MrExcel</a>. Download a new two minute video every workday to learn one of the 377 tips from the book!<br/><img src="http://feeds.feedburner.com/~r/LearnExcelFromMrexcelPodcast/~4/P-ivCR4Ga0w" height="1" width="1"/><img src="http://feeds.feedburner.com/~r/feedburner/WeAK/~4/i7LHZfXMpwk" height="1" width="1"/> podcasts Fri, 27 Nov 2009 14:00:00 GMT http://mrexcel.libsyn.com/index.php?post_id=553283# Excel, business, accounting, spreadsheets, tutorial, technology, MrExcel, dates, Pivot Table, formula, SUMIFS, Duel, Bill Jelen Roll daily data up by week in this dueling Excel podcast Clean consult@MrExcel.com (Bill Jelen)http://mrexcel.libsyn.com/index.php?post_id=553283#http://feedproxy.google.com/~r/LearnExcelFromMrexcelPodcast/~3/P-ivCR4Ga0w/index.php http://feedproxy.google.com/~r/feedburner/WeAK/~3/o6topKav9QI/index.php <p><a href="http://feedads.g.doubleclick.net/~a/cp28jOMcBTSHlcI0OLS2BtHFEEI/0/da"><img src="http://feedads.g.doubleclick.net/~a/cp28jOMcBTSHlcI0OLS2BtHFEEI/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/cp28jOMcBTSHlcI0OLS2BtHFEEI/1/da"><img src="http://feedads.g.doubleclick.net/~a/cp28jOMcBTSHlcI0OLS2BtHFEEI/1/di" border="0" ismap="true"></img></a></p>Harold from Tulsa asked how to write a macro to simulate double-clicking the fill handle. <a href="http://mrexcel.libsyn.com/media/mrexcel/podcast1152.mp4">Episode 1152</a> shows you how.<br/><br/>This blog is the video podcast companion to the book, <a href="http://www.mrexcel.com/learnexcel2.shtml">Learn Excel 97-2007 from MrExcel</a>. Download a new two minute video every workday to learn one of the 377 tips from the book!<br/><img src="http://feeds.feedburner.com/~r/LearnExcelFromMrexcelPodcast/~4/Wpq-LOhWJJg" height="1" width="1"/><img src="http://feeds.feedburner.com/~r/feedburner/WeAK/~4/o6topKav9QI" height="1" width="1"/> podcasts Wed, 25 Nov 2009 14:00:00 GMT http://mrexcel.libsyn.com/index.php?post_id=552487# Excel, business, accounting, spreadsheets, tutorial, technology, MrExcel, VBA Bill Jelen Write a macro to replicate double-clicking the fill handle Clean consult@MrExcel.com (Bill Jelen)http://mrexcel.libsyn.com/index.php?post_id=552487#http://feedproxy.google.com/~r/LearnExcelFromMrexcelPodcast/~3/Wpq-LOhWJJg/index.php http://feedproxy.google.com/~r/feedburner/WeAK/~3/d-RNwdh3Nok/index.php <p><a href="http://feedads.g.doubleclick.net/~a/7YDNwcp-hv4NXVDhHCjRBLcUD3Q/0/da"><img src="http://feedads.g.doubleclick.net/~a/7YDNwcp-hv4NXVDhHCjRBLcUD3Q/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/7YDNwcp-hv4NXVDhHCjRBLcUD3Q/1/da"><img src="http://feedads.g.doubleclick.net/~a/7YDNwcp-hv4NXVDhHCjRBLcUD3Q/1/di" border="0" ismap="true"></img></a></p>How can you add a watermark behind your spreadsheet? It is not obvious, but <a href="http://mrexcel.libsyn.com/media/mrexcel/podcast1151.mp4">Episode 1151</a> shows you a couple of methods.<br/><br/>This blog is the video podcast companion to the book, <a href="http://www.mrexcel.com/learnexcel2.shtml">Learn Excel 97-2007 from MrExcel</a>. Download a new two minute video every workday to learn one of the 377 tips from the book!<br/><img src="http://feeds.feedburner.com/~r/LearnExcelFromMrexcelPodcast/~4/SOXrSODRnj4" height="1" width="1"/><img src="http://feeds.feedburner.com/~r/feedburner/WeAK/~4/d-RNwdh3Nok" height="1" width="1"/> podcasts Tue, 24 Nov 2009 14:00:00 GMT http://mrexcel.libsyn.com/index.php?post_id=552464# Excel, business, accounting, spreadsheets, tutorial, technology, MrExcel, formatting, Pictures Bill Jelen Add a watermark behind your spreadsheet Clean consult@MrExcel.com (Bill Jelen)http://mrexcel.libsyn.com/index.php?post_id=552464#http://feedproxy.google.com/~r/LearnExcelFromMrexcelPodcast/~3/SOXrSODRnj4/index.php http://feedproxy.google.com/~r/feedburner/WeAK/~3/5CPciay27y4/index.php <p><a href="http://feedads.g.doubleclick.net/~a/bYYj9yPo3M0c-pPcYcu0PvKUoco/0/da"><img src="http://feedads.g.doubleclick.net/~a/bYYj9yPo3M0c-pPcYcu0PvKUoco/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/bYYj9yPo3M0c-pPcYcu0PvKUoco/1/da"><img src="http://feedads.g.doubleclick.net/~a/bYYj9yPo3M0c-pPcYcu0PvKUoco/1/di" border="0" ismap="true"></img></a></p>In Episode 1150, I wanted to add data bars to a series of words. <a href="http://mrexcel.libsyn.com/media/mrexcel/podcast1150.mp4">Episode 1150</a> shows you how.<br/><br/>This blog is the video podcast companion to the book, <a href="http://www.mrexcel.com/learnexcel2.shtml">Learn Excel 97-2007 from MrExcel</a>. Download a new two minute video every workday to learn one of the 377 tips from the book!<br/><img src="http://feeds.feedburner.com/~r/LearnExcelFromMrexcelPodcast/~4/kLBYEO_9U48" height="1" width="1"/><img src="http://feeds.feedburner.com/~r/feedburner/WeAK/~4/5CPciay27y4" height="1" width="1"/> podcasts Mon, 23 Nov 2009 14:00:00 GMT http://mrexcel.libsyn.com/index.php?post_id=550368# Excel, business, accounting, spreadsheets, tutorial, technology, MrExcel, data bar, VBA, conditional formatting, format, Bill Jelen Add data bars to words Clean consult@MrExcel.com (Bill Jelen)http://mrexcel.libsyn.com/index.php?post_id=550368#http://feedproxy.google.com/~r/LearnExcelFromMrexcelPodcast/~3/kLBYEO_9U48/index.php http://feedproxy.google.com/~r/feedburner/WeAK/~3/1eLRvnxiHtg/index.php <p><a href="http://feedads.g.doubleclick.net/~a/UmYtemWVCCFepQq8YFT9cjR_ODw/0/da"><img src="http://feedads.g.doubleclick.net/~a/UmYtemWVCCFepQq8YFT9cjR_ODw/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/UmYtemWVCCFepQq8YFT9cjR_ODw/1/da"><img src="http://feedads.g.doubleclick.net/~a/UmYtemWVCCFepQq8YFT9cjR_ODw/1/di" border="0" ismap="true"></img></a></p>Someone put a bunch of mathematical calculations in column A as text and we want to evaluate those formulas. Mike and Bill provide dueling ways to solve this problem in <a href="http://mrexcel.libsyn.com/media/mrexcel/podcast1149.mp4">Episode 1149</a>.<br/><br/>This blog is the video podcast companion to the book, <a href="http://www.mrexcel.com/learnexcel2.shtml">Learn Excel 97-2007 from MrExcel</a>. Download a new two minute video every workday to learn one of the 377 tips from the book!<img src="http://feeds.feedburner.com/~r/LearnExcelFromMrexcelPodcast/~4/kOHeXW5NO5M" height="1" width="1"/><img src="http://feeds.feedburner.com/~r/feedburner/WeAK/~4/1eLRvnxiHtg" height="1" width="1"/> podcasts Fri, 20 Nov 2009 14:00:00 GMT http://mrexcel.libsyn.com/index.php?post_id=548851# Excel, business, accounting, spreadsheets, tutorial, technology, MrExcel, Duel, evaluate, formula, Text Bill Jelen Learn to evaluate formulas entered as text Clean consult@MrExcel.com (Bill Jelen)http://mrexcel.libsyn.com/index.php?post_id=548851#http://feedproxy.google.com/~r/LearnExcelFromMrexcelPodcast/~3/kOHeXW5NO5M/index.php http://feedproxy.google.com/~r/feedburner/WeAK/~3/icQpvFUFesI/index.php <p><a href="http://feedads.g.doubleclick.net/~a/dwj1AzcMOZ7Kt6yrK_bkBQWLMV8/0/da"><img src="http://feedads.g.doubleclick.net/~a/dwj1AzcMOZ7Kt6yrK_bkBQWLMV8/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/dwj1AzcMOZ7Kt6yrK_bkBQWLMV8/1/da"><img src="http://feedads.g.doubleclick.net/~a/dwj1AzcMOZ7Kt6yrK_bkBQWLMV8/1/di" border="0" ismap="true"></img></a></p>Ram asks how to split a word into individual letters, and then count how many times each letter appears. <a href="http://mrexcel.libsyn.com/media/mrexcel/podcast1148.mp4">Episode 1148</a> shows you how.<br/><br/>This blog is the video podcast companion to the book, <a href="http://www.mrexcel.com/learnexcel2.shtml">Learn Excel 97-2007 from MrExcel</a>. Download a new two minute video every workday to learn one of the 377 tips from the book!<br/><img src="http://feeds.feedburner.com/~r/LearnExcelFromMrexcelPodcast/~4/5iK2AOA7j80" height="1" width="1"/><img src="http://feeds.feedburner.com/~r/feedburner/WeAK/~4/icQpvFUFesI" height="1" width="1"/> podcasts Thu, 19 Nov 2009 14:00:00 GMT http://mrexcel.libsyn.com/index.php?post_id=548844# Excel, business, accounting, spreadsheets, tutorial, technology, MrExcel, MID, COUNTIF, SUMPRODUCT Bill Jelen Split a Word into letters and count how many times each letter appears. Clean consult@MrExcel.com (Bill Jelen)http://mrexcel.libsyn.com/index.php?post_id=548844#http://feedproxy.google.com/~r/LearnExcelFromMrexcelPodcast/~3/5iK2AOA7j80/index.php http://feedproxy.google.com/~r/feedburner/WeAK/~3/VfI7NSe6sS0/index.php <p><a href="http://feedads.g.doubleclick.net/~a/wLhcWmJ3ESzWuBPEKT-uMMwKCkA/0/da"><img src="http://feedads.g.doubleclick.net/~a/wLhcWmJ3ESzWuBPEKT-uMMwKCkA/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/wLhcWmJ3ESzWuBPEKT-uMMwKCkA/1/da"><img src="http://feedads.g.doubleclick.net/~a/wLhcWmJ3ESzWuBPEKT-uMMwKCkA/1/di" border="0" ismap="true"></img></a></p>Wang asks how to change part of one data label to be red. Unfortunately, the label is then broken. A macro should solve this, but it does not. <a href="http://mrexcel.libsyn.com/media/mrexcel/podcast1147.mp4">Episode 1147</a> discusses this problem.<br/><br/>This blog is the video podcast companion to the book, <a href="http://www.mrexcel.com/learnexcel2.shtml">Learn Excel 97-2007 from MrExcel</a>. Download a new two minute video every workday to learn one of the 377 tips from the book!<br/><br/><img src="http://feeds.feedburner.com/~r/LearnExcelFromMrexcelPodcast/~4/ZCMK9Zk-pLo" height="1" width="1"/><img src="http://feeds.feedburner.com/~r/feedburner/WeAK/~4/VfI7NSe6sS0" height="1" width="1"/> podcasts Wed, 18 Nov 2009 14:00:00 GMT http://mrexcel.libsyn.com/index.php?post_id=548521# Excel, business, accounting, spreadsheets, tutorial, technology, MrExcel, charts Bill Jelen Changing the color of part of a chart label breaks the label Clean consult@MrExcel.com (Bill Jelen)http://mrexcel.libsyn.com/index.php?post_id=548521#http://feedproxy.google.com/~r/LearnExcelFromMrexcelPodcast/~3/ZCMK9Zk-pLo/index.php http://feedproxy.google.com/~r/feedburner/WeAK/~3/g8F2gdqJzgo/index.php <p><a href="http://feedads.g.doubleclick.net/~a/7Rs1qukq0yH-QcBTqdOLAalUpPE/0/da"><img src="http://feedads.g.doubleclick.net/~a/7Rs1qukq0yH-QcBTqdOLAalUpPE/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/7Rs1qukq0yH-QcBTqdOLAalUpPE/1/da"><img src="http://feedads.g.doubleclick.net/~a/7Rs1qukq0yH-QcBTqdOLAalUpPE/1/di" border="0" ismap="true"></img></a></p>Mark asks how to fill blanks in with the data from above. Now...if you've watched this podcast, you've seen the trick for this, but Mark's data has something preventing Go To Special Blanks from working! So - another way to go. <a href="http://mrexcel.libsyn.com/media/mrexcel/podcast1146.mp4">Episode 1146</a> shows you how.<br/><br/>This blog is the video podcast companion to the book, <a href="http://www.mrexcel.com/learnexcel2.shtml">Learn Excel 97-2007 from MrExcel</a>. Download a new two minute video every workday to learn one of the 377 tips from the book!<br/><br/><img src="http://feeds.feedburner.com/~r/LearnExcelFromMrexcelPodcast/~4/eUhqMiMQuQE" height="1" width="1"/><img src="http://feeds.feedburner.com/~r/feedburner/WeAK/~4/g8F2gdqJzgo" height="1" width="1"/> podcasts Tue, 17 Nov 2009 14:00:00 GMT http://mrexcel.libsyn.com/index.php?post_id=548052# Excel, business, accounting, spreadsheets, tutorial, technology, MrExcel, GoTo Special Blanks, Blank Cells, Blanks, AutoFilter, Bill Jelen Fill pseudo-blank cells with the value from above No consult@MrExcel.com (Bill Jelen)http://mrexcel.libsyn.com/index.php?post_id=548052#http://feedproxy.google.com/~r/LearnExcelFromMrexcelPodcast/~3/eUhqMiMQuQE/index.php http://feedproxy.google.com/~r/feedburner/WeAK/~3/6eAi16ijjTM/index.php <p><a href="http://feedads.g.doubleclick.net/~a/R-Qw06z2g8tb7at71uGAmSkO0ek/0/da"><img src="http://feedads.g.doubleclick.net/~a/R-Qw06z2g8tb7at71uGAmSkO0ek/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/R-Qw06z2g8tb7at71uGAmSkO0ek/1/da"><img src="http://feedads.g.doubleclick.net/~a/R-Qw06z2g8tb7at71uGAmSkO0ek/1/di" border="0" ismap="true"></img></a></p>Diane from Michigan wants to split a column of names into two columns. <a href="http://mrexcel.libsyn.com/media/mrexcel/podcast1145.mp4">Episode 1145</a> shows two approaches and the problems with each.<br/><br/>This blog is the video podcast companion to the book, <a href="http://www.mrexcel.com/learnexcel2.shtml">Learn Excel 97-2007 from MrExcel</a>. Download a new two minute video every workday to learn one of the 377 tips from the book!<br/><img src="http://feeds.feedburner.com/~r/LearnExcelFromMrexcelPodcast/~4/j2UOjzAik0Y" height="1" width="1"/><img src="http://feeds.feedburner.com/~r/feedburner/WeAK/~4/6eAi16ijjTM" height="1" width="1"/> podcasts Mon, 16 Nov 2009 14:00:00 GMT http://mrexcel.libsyn.com/index.php?post_id=547723# Excel, business, accounting, spreadsheets, tutorial, technology, MrExcel, text to columns, Names, LEFT, MID Bill Jelen The hassles in splitting a range of names into two columns Clean consult@MrExcel.com (Bill Jelen)http://mrexcel.libsyn.com/index.php?post_id=547723#http://feedproxy.google.com/~r/LearnExcelFromMrexcelPodcast/~3/j2UOjzAik0Y/index.php http://feedproxy.google.com/~r/feedburner/WeAK/~3/xDOL5Q2IWyA/index.php <p><a href="http://feedads.g.doubleclick.net/~a/-SjQaovwKoZsz4uoZ8FETVIZ2C0/0/da"><img src="http://feedads.g.doubleclick.net/~a/-SjQaovwKoZsz4uoZ8FETVIZ2C0/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/-SjQaovwKoZsz4uoZ8FETVIZ2C0/1/da"><img src="http://feedads.g.doubleclick.net/~a/-SjQaovwKoZsz4uoZ8FETVIZ2C0/1/di" border="0" ismap="true"></img></a></p>Martin from Sweden sends in a question about doing a range VLOOKUP where the lookup table is not sorted. Mike and Bill duel it out in today's <a href="http://mrexcel.libsyn.com/media/mrexcel/podcast1144.mp4">Episode 1144</a>.<br/><br/>This blog is the video podcast companion to the book, <a href="http://www.mrexcel.com/learnexcel2.shtml">Learn Excel 97-2007 from MrExcel</a>. Download a new two minute video every workday to learn one of the 377 tips from the book!<br/><img src="http://feeds.feedburner.com/~r/LearnExcelFromMrexcelPodcast/~4/NgR0Z91nhW4" height="1" width="1"/><img src="http://feeds.feedburner.com/~r/feedburner/WeAK/~4/xDOL5Q2IWyA" height="1" width="1"/> podcasts Fri, 13 Nov 2009 14:00:00 GMT http://mrexcel.libsyn.com/index.php?post_id=547254# Excel, business, accounting, spreadsheets, tutorial, technology, MrExcel, VLOOKUP, lookup, SMALL, MIN, formula Bill Jelen Do a range lookup when the table can not be sorted. Clean consult@MrExcel.com (Bill Jelen)http://mrexcel.libsyn.com/index.php?post_id=547254#http://feedproxy.google.com/~r/LearnExcelFromMrexcelPodcast/~3/NgR0Z91nhW4/index.php http://feedproxy.google.com/~r/feedburner/WeAK/~3/JVeyK1RhEiM/index.php <p><a href="http://feedads.g.doubleclick.net/~a/RrSzomMGTYK2IZz2j-9qZswLGG8/0/da"><img src="http://feedads.g.doubleclick.net/~a/RrSzomMGTYK2IZz2j-9qZswLGG8/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/RrSzomMGTYK2IZz2j-9qZswLGG8/1/da"><img src="http://feedads.g.doubleclick.net/~a/RrSzomMGTYK2IZz2j-9qZswLGG8/1/di" border="0" ismap="true"></img></a></p>Michael from Kansas City asks how to build a floating quartile chart. <a href="http://mrexcel.libsyn.com/media/mrexcel/podcast1143.mp4">Episode 1143</a> shows you how.<br/><br/>This blog is the video podcast companion to the book, <a href="http://www.mrexcel.com/learnexcel2.shtml">Learn Excel 97-2007 from MrExcel</a>. Download a new two minute video every workday to learn one of the 377 tips from the book!<br/><img src="http://feeds.feedburner.com/~r/LearnExcelFromMrexcelPodcast/~4/R86JDccc50w" height="1" width="1"/><img src="http://feeds.feedburner.com/~r/feedburner/WeAK/~4/JVeyK1RhEiM" height="1" width="1"/> podcasts Thu, 12 Nov 2009 14:00:00 GMT http://mrexcel.libsyn.com/index.php?post_id=547219# Excel, business, accounting, spreadsheets, tutorial, technology, MrExcel, chart Bill Jelen Build a floating quartile chart Clean consult@MrExcel.com (Bill Jelen)http://mrexcel.libsyn.com/index.php?post_id=547219#http://feedproxy.google.com/~r/LearnExcelFromMrexcelPodcast/~3/R86JDccc50w/index.php http://feedproxy.google.com/~r/feedburner/WeAK/~3/oiq4b4aiPNg/index.php <p><a href="http://feedads.g.doubleclick.net/~a/ky51JMC0TEWa3V2fhqnfE0PUDzg/0/da"><img src="http://feedads.g.doubleclick.net/~a/ky51JMC0TEWa3V2fhqnfE0PUDzg/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/ky51JMC0TEWa3V2fhqnfE0PUDzg/1/da"><img src="http://feedads.g.doubleclick.net/~a/ky51JMC0TEWa3V2fhqnfE0PUDzg/1/di" border="0" ismap="true"></img></a></p>You can specify up to eight colors in the custom number format box. But wait...you can actually do all 56 colors from the Excel 2003 color palette! <a href="http://mrexcel.libsyn.com/media/mrexcel/podcast1142.mp4">Episode 1142</a> shows you how.<br/><br/>This blog is the video podcast companion to the book, <a href="http://www.mrexcel.com/learnexcel2.shtml">Learn Excel 97-2007 from MrExcel</a>. Download a new two minute video every workday to learn one of the 377 tips from the book!<br/><img src="http://feeds.feedburner.com/~r/LearnExcelFromMrexcelPodcast/~4/OHk2S8Am_ec" height="1" width="1"/><img src="http://feeds.feedburner.com/~r/feedburner/WeAK/~4/oiq4b4aiPNg" height="1" width="1"/> podcasts Wed, 11 Nov 2009 14:00:00 GMT http://mrexcel.libsyn.com/index.php?post_id=545845# Excel, business, accounting, spreadsheets, tutorial, technology, MrExcel, Formatting Bill Jelen Use more than 8 colors in the custom number format Clean consult@MrExcel.com (Bill Jelen)http://mrexcel.libsyn.com/index.php?post_id=545845#http://feedproxy.google.com/~r/LearnExcelFromMrexcelPodcast/~3/OHk2S8Am_ec/index.php http://feedproxy.google.com/~r/feedburner/WeAK/~3/BiUvZdbiqjc/index.php <p><a href="http://feedads.g.doubleclick.net/~a/3yaPkJzkparIaZH0waLk6o-OOsg/0/da"><img src="http://feedads.g.doubleclick.net/~a/3yaPkJzkparIaZH0waLk6o-OOsg/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/3yaPkJzkparIaZH0waLk6o-OOsg/1/da"><img src="http://feedads.g.doubleclick.net/~a/3yaPkJzkparIaZH0waLk6o-OOsg/1/di" border="0" ismap="true"></img></a></p>Rob from Cambridge needs to divide nine cells by nine other cells and sum them up. In <a href="http://mrexcel.libsyn.com/media/mrexcel/podcast1141.mp4">Episode 1141</a>, we look at an array formula to solve this problem.<br/><br/>This blog is the video podcast companion to the book, <a href="http://www.mrexcel.com/learnexcel2.shtml">Learn Excel 97-2007 from MrExcel</a>. Download a new two minute video every workday to learn one of the 377 tips from the book!<br/><img src="http://feeds.feedburner.com/~r/LearnExcelFromMrexcelPodcast/~4/ryRCBEoy668" height="1" width="1"/><img src="http://feeds.feedburner.com/~r/feedburner/WeAK/~4/BiUvZdbiqjc" height="1" width="1"/> podcasts Tue, 10 Nov 2009 14:00:00 GMT http://mrexcel.libsyn.com/index.php?post_id=545834# Excel, business, accounting, spreadsheets, tutorial, technology, MrExcel, array, formula Bill Jelen Array formula to sum one range divided by another range Clean consult@MrExcel.com (Bill Jelen)http://mrexcel.libsyn.com/index.php?post_id=545834#http://feedproxy.google.com/~r/LearnExcelFromMrexcelPodcast/~3/ryRCBEoy668/index.php http://feedproxy.google.com/~r/feedburner/WeAK/~3/FAy8LzIFgvU/index.php <p><a href="http://feedads.g.doubleclick.net/~a/jMQqlllDF9bQShNbvBLK5OeXFws/0/da"><img src="http://feedads.g.doubleclick.net/~a/jMQqlllDF9bQShNbvBLK5OeXFws/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/jMQqlllDF9bQShNbvBLK5OeXFws/1/da"><img src="http://feedads.g.doubleclick.net/~a/jMQqlllDF9bQShNbvBLK5OeXFws/1/di" border="0" ismap="true"></img></a></p>A cool way to streamline a VBA loop using SpecialCells. <a href="http://mrexcel.libsyn.com/media/mrexcel/podcast1140.mp4">Episode 1140</a> shows you how.<br/><br/>This blog is the video podcast companion to the book, <a href="http://www.mrexcel.com/learnexcel2.shtml">Learn Excel 97-2007 from MrExcel</a>. Download a new two minute video every workday to learn one of the 377 tips from the book!<br/><img src="http://feeds.feedburner.com/~r/LearnExcelFromMrexcelPodcast/~4/Q2Qqo05g-Hc" height="1" width="1"/><img src="http://feeds.feedburner.com/~r/feedburner/WeAK/~4/FAy8LzIFgvU" height="1" width="1"/> podcasts Mon, 9 Nov 2009 14:00:00 GMT http://mrexcel.libsyn.com/index.php?post_id=545536# Excel, business, accounting, spreadsheets, tutorial, technology, MrExcel, VBA, Go To Special, formula Bill Jelen Avoid a VBA loop using SpecialCells Clean consult@MrExcel.com (Bill Jelen)http://mrexcel.libsyn.com/index.php?post_id=545536#http://feedproxy.google.com/~r/LearnExcelFromMrexcelPodcast/~3/Q2Qqo05g-Hc/index.php http://feedproxy.google.com/~r/feedburner/WeAK/~3/v2JToPGivoU/index.php <p><a href="http://feedads.g.doubleclick.net/~a/BKz0mTGn6mroG2idhP-O8V78ST4/0/da"><img src="http://feedads.g.doubleclick.net/~a/BKz0mTGn6mroG2idhP-O8V78ST4/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/BKz0mTGn6mroG2idhP-O8V78ST4/1/da"><img src="http://feedads.g.doubleclick.net/~a/BKz0mTGn6mroG2idhP-O8V78ST4/1/di" border="0" ismap="true"></img></a></p>A viewer from Portugal sends in a question about finding which row contains the match. <a href="http://mrexcel.libsyn.com/media/mrexcel/podcast1139.mp4">Episode 1139</a> shows you a few ways to go!<br/><br/>This blog is the video podcast companion to the book, <a href="http://www.mrexcel.com/learnexcel2.shtml">Learn Excel 97-2007 from MrExcel</a>. Download a new two minute video every workday to learn one of the 377 tips from the book!<br/><img src="http://feeds.feedburner.com/~r/LearnExcelFromMrexcelPodcast/~4/4cYnFTnOpqY" height="1" width="1"/><img src="http://feeds.feedburner.com/~r/feedburner/WeAK/~4/v2JToPGivoU" height="1" width="1"/> podcasts Fri, 6 Nov 2009 14:00:00 GMT http://mrexcel.libsyn.com/index.php?post_id=545157# Excel, business, accounting, spreadsheets, tutorial, technology, MrExcel, INDEX, MATCH, Offset Bill Jelen Combining OFFSET, INDEX, MATCH to solve a problem Clean consult@MrExcel.com (Bill Jelen)http://mrexcel.libsyn.com/index.php?post_id=545157#http://feedproxy.google.com/~r/LearnExcelFromMrexcelPodcast/~3/4cYnFTnOpqY/index.php http://feedproxy.google.com/~r/feedburner/WeAK/~3/WImoPDZXDZM/index.php <p><a href="http://feedads.g.doubleclick.net/~a/ACDdnB_r2vwFEnjR3GksIpWvwzk/0/da"><img src="http://feedads.g.doubleclick.net/~a/ACDdnB_r2vwFEnjR3GksIpWvwzk/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/ACDdnB_r2vwFEnjR3GksIpWvwzk/1/da"><img src="http://feedads.g.doubleclick.net/~a/ACDdnB_r2vwFEnjR3GksIpWvwzk/1/di" border="0" ismap="true"></img></a></p>Rod from Cincinati asks how to solve the problem of trailing spaces in the lookup table. I had never tried it before, but you can apply a TRIM to the entire lookup table. <a href="http://mrexcel.libsyn.com/media/mrexcel/podcast1138.mp4">Episode 1138</a> shows you how.<br/><br/>This blog is the video podcast companion to the book, <a href="http://www.mrexcel.com/learnexcel2.shtml">Learn Excel 97-2007 from MrExcel</a>. Download a new two minute video every workday to learn one of the 377 tips from the book!<br/><img src="http://feeds.feedburner.com/~r/LearnExcelFromMrexcelPodcast/~4/rJSEu8IdwIo" height="1" width="1"/><img src="http://feeds.feedburner.com/~r/feedburner/WeAK/~4/WImoPDZXDZM" height="1" width="1"/> podcasts Thu, 5 Nov 2009 14:00:00 GMT http://mrexcel.libsyn.com/index.php?post_id=545146# Excel, business, accounting, spreadsheets, tutorial, technology, MrExcel, TRIM, lookup, formula Bill Jelen Get rid of trailing spaces in your lookup table Clean consult@MrExcel.com (Bill Jelen)http://mrexcel.libsyn.com/index.php?post_id=545146#http://feedproxy.google.com/~r/LearnExcelFromMrexcelPodcast/~3/rJSEu8IdwIo/index.php http://feedproxy.google.com/~r/feedburner/WeAK/~3/UMIS5L1TXZk/index.php <p><a href="http://feedads.g.doubleclick.net/~a/ZNyZpKL_kCfMzxCT7ITWg7j7AQY/0/da"><img src="http://feedads.g.doubleclick.net/~a/ZNyZpKL_kCfMzxCT7ITWg7j7AQY/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/ZNyZpKL_kCfMzxCT7ITWg7j7AQY/1/da"><img src="http://feedads.g.doubleclick.net/~a/ZNyZpKL_kCfMzxCT7ITWg7j7AQY/1/di" border="0" ismap="true"></img></a></p>In <a href="http://mrexcel.libsyn.com/media/mrexcel/podcast1137.mp4">Episode 1137</a>, a cool way to remove all hyperlinks from a spreadsheet.<br/><br/>This blog is the video podcast companion to the book, <a href="http://www.mrexcel.com/learnexcel2.shtml">Learn Excel 97-2007 from MrExcel</a>. Download a new two minute video every workday to learn one of the 377 tips from the book!<br/><img src="http://feeds.feedburner.com/~r/LearnExcelFromMrexcelPodcast/~4/ct1RVlKkjqs" height="1" width="1"/><img src="http://feeds.feedburner.com/~r/feedburner/WeAK/~4/UMIS5L1TXZk" height="1" width="1"/> podcasts Wed, 4 Nov 2009 14:00:00 GMT http://mrexcel.libsyn.com/index.php?post_id=544695# Excel, business, accounting, spreadsheets, tutorial, technology, MrExcel, hyperlink, shortcuts, Bill Jelen Remove all hyperlinks from a range Clean consult@MrExcel.com (Bill Jelen)http://mrexcel.libsyn.com/index.php?post_id=544695#http://feedproxy.google.com/~r/LearnExcelFromMrexcelPodcast/~3/ct1RVlKkjqs/index.php http://feedproxy.google.com/~r/feedburner/WeAK/~3/NX6lasgcwe4/index.php <p><a href="http://feedads.g.doubleclick.net/~a/-5j08gp27l6q4ilnrHff58NyNao/0/da"><img src="http://feedads.g.doubleclick.net/~a/-5j08gp27l6q4ilnrHff58NyNao/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/-5j08gp27l6q4ilnrHff58NyNao/1/da"><img src="http://feedads.g.doubleclick.net/~a/-5j08gp27l6q4ilnrHff58NyNao/1/di" border="0" ismap="true"></img></a></p>Mary from Louisiana passes along a cool tip for applying AutoFilter dropdowns to a subset of your records. <a href="http://mrexcel.libsyn.com/media/mrexcel/podcast1136.mp4">Episode 1136</a> shows you how.<br/><br/>This blog is the video podcast companion to the book, <a href="http://www.mrexcel.com/learnexcel2.shtml">Learn Excel 97-2007 from MrExcel</a>. Download a new two minute video every workday to learn one of the 377 tips from the book!<br/><img src="http://feeds.feedburner.com/~r/LearnExcelFromMrexcelPodcast/~4/Lhb8iFBPlWw" height="1" width="1"/><img src="http://feeds.feedburner.com/~r/feedburner/WeAK/~4/NX6lasgcwe4" height="1" width="1"/> podcasts Tue, 3 Nov 2009 14:00:00 GMT http://mrexcel.libsyn.com/index.php?post_id=544684# Excel, business, accounting, spreadsheets, tutorial, technology, MrExcel, Filter, AutoFilter, shortcuts, Bill Jelen Apply AutoFilter dropdowns to a portion of your columns. Clean consult@MrExcel.com (Bill Jelen)http://mrexcel.libsyn.com/index.php?post_id=544684#http://feedproxy.google.com/~r/LearnExcelFromMrexcelPodcast/~3/Lhb8iFBPlWw/index.php http://feedproxy.google.com/~r/feedburner/WeAK/~3/1Kmcr3q7NGs/index.php <p><a href="http://feedads.g.doubleclick.net/~a/1fYVbHUP_76dyJTMhXBce_Pb3cU/0/da"><img src="http://feedads.g.doubleclick.net/~a/1fYVbHUP_76dyJTMhXBce_Pb3cU/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/1fYVbHUP_76dyJTMhXBce_Pb3cU/1/da"><img src="http://feedads.g.doubleclick.net/~a/1fYVbHUP_76dyJTMhXBce_Pb3cU/1/di" border="0" ismap="true"></img></a></p>Nick asks how to do a pretty lengthy bonus calculation. It might be too complex for the Excel 2003 nested IF limit, so I decided to use the range version of VLOOKUP. But...as a twist, I embed the table right in the formula. <a href="http://mrexcel.libsyn.com/media/mrexcel/podcast1135.mp4">Episode 1135</a> shows you how.<br/><br/>This blog is the video podcast companion to the book, <a href="http://www.mrexcel.com/learnexcel2.shtml">Learn Excel 97-2007 from MrExcel</a>. Download a new two minute video every workday to learn one of the 377 tips from the book!<br/><img src="http://feeds.feedburner.com/~r/LearnExcelFromMrexcelPodcast/~4/EAWUhVg2Ph8" height="1" width="1"/><img src="http://feeds.feedburner.com/~r/feedburner/WeAK/~4/1Kmcr3q7NGs" height="1" width="1"/> podcasts Mon, 2 Nov 2009 14:00:00 GMT http://mrexcel.libsyn.com/index.php?post_id=543189# Excel, business, accounting, spreadsheets, tutorial, technology, MrExcel, Formula, VLOOKUP, IF Bill Jelen Embedding a lookup table in a VLOOKUP Clean consult@MrExcel.com (Bill Jelen)http://mrexcel.libsyn.com/index.php?post_id=543189#http://feedproxy.google.com/~r/LearnExcelFromMrexcelPodcast/~3/EAWUhVg2Ph8/index.php http://feedproxy.google.com/~r/feedburner/WeAK/~3/kcxVj35Vnws/index.php <p><a href="http://feedads.g.doubleclick.net/~a/gSfUhAEiSvwWbqVhQFNProxnWas/0/da"><img src="http://feedads.g.doubleclick.net/~a/gSfUhAEiSvwWbqVhQFNProxnWas/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/gSfUhAEiSvwWbqVhQFNProxnWas/1/da"><img src="http://feedads.g.doubleclick.net/~a/gSfUhAEiSvwWbqVhQFNProxnWas/1/di" border="0" ismap="true"></img></a></p>Today's Dueling Excel Podcast is a question sent in by Hassan. Hassan wants to enter a name and a through-month and then add up that person's sales from January through the selected month. Mike and Bill show various methods in <a href="http://mrexcel.libsyn.com/media/mrexcel/podcast1134.mp4">Episode 1134</a>.<br/><br/>This blog is the video podcast companion to the book, <a href="http://www.mrexcel.com/learnexcel2.shtml">Learn Excel 97-2007 from MrExcel</a>. Download a new two minute video every workday to learn one of the 377 tips from the book!<br/><img src="http://feeds.feedburner.com/~r/LearnExcelFromMrexcelPodcast/~4/RJTN0O6plnA" height="1" width="1"/><img src="http://feeds.feedburner.com/~r/feedburner/WeAK/~4/kcxVj35Vnws" height="1" width="1"/> podcasts Fri, 30 Oct 2009 13:00:00 GMT http://mrexcel.libsyn.com/index.php?post_id=543181# Excel, business, accounting, spreadsheets, tutorial, technology, MrExcel, formula, INDEX, Offset, MONTH Bill Jelen Dynamically add up cells based on a name and through month. Clean consult@MrExcel.com (Bill Jelen)http://mrexcel.libsyn.com/index.php?post_id=543181#http://feedproxy.google.com/~r/LearnExcelFromMrexcelPodcast/~3/RJTN0O6plnA/index.php http://feedproxy.google.com/~r/feedburner/WeAK/~3/ReuVv7qcsXg/index.php <p><a href="http://feedads.g.doubleclick.net/~a/uX05M229f1bDhDUrbv7HfBc6bQM/0/da"><img src="http://feedads.g.doubleclick.net/~a/uX05M229f1bDhDUrbv7HfBc6bQM/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/uX05M229f1bDhDUrbv7HfBc6bQM/1/da"><img src="http://feedads.g.doubleclick.net/~a/uX05M229f1bDhDUrbv7HfBc6bQM/1/di" border="0" ismap="true"></img></a></p>Patricia called the other day with a problem which will be familiar to everyone who works in a public school district. The state pays the school for every student who is enrolled on the magic date of October 1. Given a start date and end date, how can you tell if the date is in that range? <a href="http://mrexcel.libsyn.com/media/mrexcel/podcast1133.mp4">Episode 1133</a> shows you how.<br/> <br/>This blog is the video podcast companion to the book, <a href="http://www.mrexcel.com/learnexcel2.shtml">Learn Excel 97-2007 from MrExcel</a>. Download a new two minute video every workday to learn one of the 377 tips from the book!<br/><img src="http://feeds.feedburner.com/~r/LearnExcelFromMrexcelPodcast/~4/XyE-wVuN_K4" height="1" width="1"/><img src="http://feeds.feedburner.com/~r/feedburner/WeAK/~4/ReuVv7qcsXg" height="1" width="1"/> podcasts Thu, 29 Oct 2009 13:00:00 GMT http://mrexcel.libsyn.com/index.php?post_id=542388# Excel, business, accounting, spreadsheets, tutorial, technology, MrExcel, dates, formulas Bill Jelen How many students were enrolled on October 1? Clean consult@MrExcel.com (Bill Jelen)http://mrexcel.libsyn.com/index.php?post_id=542388#http://feedproxy.google.com/~r/LearnExcelFromMrexcelPodcast/~3/XyE-wVuN_K4/index.php http://feedproxy.google.com/~r/feedburner/WeAK/~3/pacWleVESfQ/index.php <p><a href="http://feedads.g.doubleclick.net/~a/5jz-DmINZiKcVY2_GJKOcKTFwts/0/da"><img src="http://feedads.g.doubleclick.net/~a/5jz-DmINZiKcVY2_GJKOcKTFwts/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/5jz-DmINZiKcVY2_GJKOcKTFwts/1/da"><img src="http://feedads.g.doubleclick.net/~a/5jz-DmINZiKcVY2_GJKOcKTFwts/1/di" border="0" ismap="true"></img></a></p>The Excel fill handle is really cool with quarters. But wait....it can not do quarters and years. But wait...it can do them but in a hideous format. <a href="http://mrexcel.libsyn.com/media/mrexcel/podcast1132.mp4">Episode 1132</a> asks&nbsp; - &quot;Does anyone have a better way?&quot;<br/><br/><br/>This blog is the video podcast companion to the book, <a href="http://www.mrexcel.com/learnexcel2.shtml">Learn Excel 97-2007 from MrExcel</a>. Download a new two minute video every workday to learn one of the 377 tips from the book!<br/><img src="http://feeds.feedburner.com/~r/LearnExcelFromMrexcelPodcast/~4/nzg4dLtalnc" height="1" width="1"/><img src="http://feeds.feedburner.com/~r/feedburner/WeAK/~4/pacWleVESfQ" height="1" width="1"/> podcasts Wed, 28 Oct 2009 13:00:00 GMT http://mrexcel.libsyn.com/index.php?post_id=541940# Excel, business, accounting, spreadsheets, tutorial, technology, MrExcel, dates, quarters Bill Jelen Excel Quarter Fill Handle Conundrum Clean consult@MrExcel.com (Bill Jelen)http://mrexcel.libsyn.com/index.php?post_id=541940#http://feedproxy.google.com/~r/LearnExcelFromMrexcelPodcast/~3/nzg4dLtalnc/index.php (c) 2006 Bill JelenBill Jelennonadult