<?xml version="1.0" encoding="UTF-8"?>
<howcast version="0.1">
  <video>
    <id>265244</id>
    <category-id>1499</category-id>
    <category-hierarchy>
      <category id="1470">Technology</category>
      <category parent_id="1470" id="1494">Computer Software</category>
      <category parent_id="1494" id="1499">Spreadsheets</category>
    </category-hierarchy>
    <easy-steps>false</easy-steps>
    <created-at>Tue, 13 Oct 2009 06:59:13 -0700</created-at>
    <filename>/system/videos/5/87/40/26/264087.flv</filename>
    <tags>Excel, business, accounting, spreadsheets, tutorial, technology, MrExcel, VLOOKUP</tags>
    <title>VLOOKUP #N/a - 1121 - Learn Excel From MrExcel Podcast</title>
    <description>
      <![CDATA[The most common error from your VLOOKUP formula is the #N/A error. Episode 1121 looks at how to find the #N/A and then three ways of adding those new values to your lookup table.

This blog is the video podcast companion to the book, Learn Excel ...]]>
    </description>
    <permalink>http://www.howcast.com/videos/265244-VLOOKUP-Na-1121-Learn-Excel-From-MrExcel-Podcast</permalink>
    <edit-url>http://www.howcast.com/videos/265244-VLOOKUP-Na-1121-Learn-Excel-From-MrExcel-Podcast/edit</edit-url>
    <state>live</state>
    <duration>249</duration>
    <width>640</width>
    <height>480</height>
    <embed>&lt;object width="425" height="352" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" id="howcastplayer"&gt;&lt;param name="movie" value="http://www.howcast.com/flash/howcast_player.swf?file=265244"&gt;&lt;/param&gt;&lt;param name="allowFullScreen" value="true"&gt;&lt;/param&gt;&lt;param name="allowScriptAccess" value="always"&gt;&lt;/param&gt;&lt;embed src="http://www.howcast.com/flash/howcast_player.swf?file=265244" type="application/x-shockwave-flash" width="425" height="352" allowFullScreen="true" allowScriptAccess="always" &gt;&lt;/embed&gt;&lt;/object&gt;</embed>
    <rating>0</rating>
    <username>mrexcel</username>
    <thumbnail-url>http://img.howcast.com/system/thumbnails/265244/120_xxlarge_maintained_aspect.jpg</thumbnail-url>
    <views>8</views>
    <overlay>
      <titlecard>false</titlecard>
      <steps>false</steps>
      <overlays>false</overlays>
    </overlay>
    <ingredients>There are no ingredients needed</ingredients>
    <markers>
    </markers>
    <related-videos>
      <video>
        <category-id>1499</category-id>
        <id>2782</id>
        <title>How To Create a Chart With One Keystroke in Microsoft Office Excel 2003</title>
        <type nil="true"></type>
        <views>804</views>
        <created-at>Wed, 02 Apr 2008 07:26:24 -0700</created-at>
        <rating>2</rating>
        <username>Livelessons</username>
        <description>
          <![CDATA[Lesson 2 from Power Excel 2003 with MrExcel
Livelessons- Video training from technology experts
ISBN: 978-0-7897-3824-0
http://www.informit.com/store/product.aspx?isbn=0789738244]]>
        </description>
        <embed>
          <![CDATA[<object width="425" height="352" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" id="howcastplayer"><param name="movie" value="http://www.howcast.com/flash/howcast_player.swf?file=2782"></param><param name="allowFullScreen" value="true"></param><param name="allowScriptAccess" value="always"></param><embed src="http://www.howcast.com/flash/howcast_player.swf?file=2782" type="application/x-shockwave-flash" width="425" height="352" allowFullScreen="true" allowScriptAccess="always" ></embed></object>]]>
        </embed>
        <duration>309</duration>
        <filename>http://media.howcast.com/system/videos/3/82/27/2782.flv</filename>
        <tags>microsoft, office, Excel, 2003, Create a chart, Jelen, MrExcel, LiveLessons, spreadsheet, Chart</tags>
        <category-hierarchy>
          <category id="1470">Technology</category>
          <category parent_id="1470" id="1494">Computer Software</category>
          <category parent_id="1494" id="1499">Spreadsheets</category>
        </category-hierarchy>
        <comment-count>0</comment-count>
        <thumbnail-url>http://img.howcast.com/system/thumbnails/2782/15_xxlarge_maintained_aspect.jpg</thumbnail-url>
        <permalink>http://www.howcast.com/videos/2782-How-To-Create-a-Chart-With-One-Keystroke-in-Microsoft-Office-Excel-2003</permalink>
      </video>
      <video>
        <category-id>1499</category-id>
        <id>2786</id>
        <title>How To Sort By Color, Filter By Color Using Microsoft Office Excel 2007</title>
        <type nil="true"></type>
        <views>1618</views>
        <created-at>Wed, 02 Apr 2008 07:55:07 -0700</created-at>
        <rating>3</rating>
        <username>Livelessons</username>
        <description>
          <![CDATA[Lesson 15 from Power Excel 2007 with MrExcel
Livelessons-Video training from technology experts
ISBN: 978-0-7897-3825-7
http://www.informit.com/store/product.aspx?isbn=0789738252]]>
        </description>
        <embed>
          <![CDATA[<object width="425" height="352" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" id="howcastplayer"><param name="movie" value="http://www.howcast.com/flash/howcast_player.swf?file=2786"></param><param name="allowFullScreen" value="true"></param><param name="allowScriptAccess" value="always"></param><embed src="http://www.howcast.com/flash/howcast_player.swf?file=2786" type="application/x-shockwave-flash" width="425" height="352" allowFullScreen="true" allowScriptAccess="always" ></embed></object>]]>
        </embed>
        <duration>341</duration>
        <filename>http://media.howcast.com/system/videos/0/86/27/2786.flv</filename>
        <tags>Sort by color. filter by color, Excel, microsoft, office, 2007, Jelen, MrExcel, LiveLessons, spreadsheet, Sort, filter</tags>
        <category-hierarchy>
          <category id="1470">Technology</category>
          <category parent_id="1470" id="1494">Computer Software</category>
          <category parent_id="1494" id="1499">Spreadsheets</category>
        </category-hierarchy>
        <comment-count>0</comment-count>
        <thumbnail-url>http://img.howcast.com/system/thumbnails/2786/15_xxlarge_maintained_aspect.jpg</thumbnail-url>
        <permalink>http://www.howcast.com/videos/2786-How-To-Sort-By-Color-Filter-By-Color-Using-Microsoft-Office-Excel-2007</permalink>
      </video>
      <video>
        <category-id>1499</category-id>
        <id>2790</id>
        <title>How To Enter Formulas in Excel 2003- 3 Easy Ways</title>
        <type nil="true"></type>
        <views>3718</views>
        <created-at>Wed, 02 Apr 2008 09:54:22 -0700</created-at>
        <rating>3</rating>
        <username>Livelessons</username>
        <description>
          <![CDATA[Lesson 61 from Power Excel 2003 with MrExcel
Livelessons- Video training from technology experts
Over 6 hrs of Excel 2003 training.
ISBN: 978-0-7897-3824-0
http://www.informit.com/store/product.aspx?isbn=0789738244
]]>
        </description>
        <embed>
          <![CDATA[<object width="425" height="352" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" id="howcastplayer"><param name="movie" value="http://www.howcast.com/flash/howcast_player.swf?file=2790"></param><param name="allowFullScreen" value="true"></param><param name="allowScriptAccess" value="always"></param><embed src="http://www.howcast.com/flash/howcast_player.swf?file=2790" type="application/x-shockwave-flash" width="425" height="352" allowFullScreen="true" allowScriptAccess="always" ></embed></object>]]>
        </embed>
        <duration>221</duration>
        <filename>http://media.howcast.com/system/videos/4/90/27/2790.flv</filename>
        <tags>Using Formulas in Excel, microsoft, office, Excel, 2003, Jelen, MrExcel, LiveLessons, spreadsheet, Formulas</tags>
        <category-hierarchy>
          <category id="1470">Technology</category>
          <category parent_id="1470" id="1494">Computer Software</category>
          <category parent_id="1494" id="1499">Spreadsheets</category>
        </category-hierarchy>
        <comment-count>3</comment-count>
        <thumbnail-url>http://img.howcast.com/system/thumbnails/2790/15_xxlarge_maintained_aspect.jpg</thumbnail-url>
        <permalink>http://www.howcast.com/videos/2790-How-To-Enter-Formulas-in-Excel-2003-3-Easy-Ways</permalink>
      </video>
      <video>
        <category-id>1499</category-id>
        <id>2794</id>
        <title>How To Customize All Future Workbooks in Excel 2007</title>
        <type nil="true"></type>
        <views>181</views>
        <created-at>Wed, 02 Apr 2008 11:26:39 -0700</created-at>
        <rating>1</rating>
        <username>Livelessons</username>
        <description>
          <![CDATA[Lesson 29 from Power Excel 2007 with MrExcel
Livelessons-Video training from technology experts
ISB: 978-0-7897-3825-7
http://www.informit.com/store/product.aspx?isbn=0789738252]]>
        </description>
        <embed>
          <![CDATA[<object width="425" height="352" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" id="howcastplayer"><param name="movie" value="http://www.howcast.com/flash/howcast_player.swf?file=2794"></param><param name="allowFullScreen" value="true"></param><param name="allowScriptAccess" value="always"></param><embed src="http://www.howcast.com/flash/howcast_player.swf?file=2794" type="application/x-shockwave-flash" width="425" height="352" allowFullScreen="true" allowScriptAccess="always" ></embed></object>]]>
        </embed>
        <duration>558</duration>
        <filename>http://media.howcast.com/system/videos/1/94/27/2794.flv</filename>
        <tags>Customize Workboos Excel, microsoft, office, Excel, 2007, Jelen, MrExcel, LiveLessons, spreadsheet, Workbook, customize</tags>
        <category-hierarchy>
          <category id="1470">Technology</category>
          <category parent_id="1470" id="1494">Computer Software</category>
          <category parent_id="1494" id="1499">Spreadsheets</category>
        </category-hierarchy>
        <comment-count>0</comment-count>
        <thumbnail-url>http://img.howcast.com/system/thumbnails/2794/15_xxlarge_maintained_aspect.jpg</thumbnail-url>
        <permalink>http://www.howcast.com/videos/2794-How-To-Customize-All-Future-Workbooks-in-Excel-2007</permalink>
      </video>
      <video>
        <category-id>1499</category-id>
        <id>5683</id>
        <title>How To Create a Simple Macro in Microsoft Excel 2003</title>
        <type nil="true"></type>
        <views>4172</views>
        <created-at>Wed, 30 Apr 2008 23:04:19 -0700</created-at>
        <rating>2</rating>
        <username>chrisleroy</username>
        <description>
          <![CDATA[Learn how to create a macro in Microsoft Excel and then how to run the macro.

If you would like to learn more about Microsoft Excel 2003 visit our website - www.NQTraining.com/learnexcel.asp or learn your shortcuts at - www.NQTraining.com/microsoftofficecheatsheets.asp ]]>
        </description>
        <embed>
          <![CDATA[<object width="425" height="352" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" id="howcastplayer"><param name="movie" value="http://www.howcast.com/flash/howcast_player.swf?file=5683"></param><param name="allowFullScreen" value="true"></param><param name="allowScriptAccess" value="always"></param><embed src="http://www.howcast.com/flash/howcast_player.swf?file=5683" type="application/x-shockwave-flash" width="425" height="352" allowFullScreen="true" allowScriptAccess="always" ></embed></object>]]>
        </embed>
        <duration>274</duration>
        <filename>http://media.howcast.com/system/videos/6/83/56/5683.flv</filename>
        <tags>ms excel, Macro, macros, simple macros, microsoft excel, microsoft excel 2003, excel shortcuts</tags>
        <category-hierarchy>
          <category id="1470">Technology</category>
          <category parent_id="1470" id="1494">Computer Software</category>
          <category parent_id="1494" id="1499">Spreadsheets</category>
        </category-hierarchy>
        <comment-count>0</comment-count>
        <thumbnail-url>http://img.howcast.com/system/thumbnails/5683/5_xxlarge_maintained_aspect.jpg</thumbnail-url>
        <permalink>http://www.howcast.com/videos/5683-How-To-Create-a-Simple-Macro-in-Microsoft-Excel-2003</permalink>
      </video>
      <video>
        <category-id>1499</category-id>
        <id>5688</id>
        <title>Basic Excel: How To Create a Loan Calculator</title>
        <type nil="true"></type>
        <views>457</views>
        <created-at>Wed, 30 Apr 2008 23:57:36 -0700</created-at>
        <rating>1</rating>
        <username>chrisleroy</username>
        <description>
          <![CDATA[Learn how to create a loan calculator using the PMT() function in Microsoft Excel 2003.

If you want to learn more about Microsoft Excel 2003 then visit our website - www.NQTraining.com/learnExcel.asp]]>
        </description>
        <embed>
          <![CDATA[<object width="425" height="352" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" id="howcastplayer"><param name="movie" value="http://www.howcast.com/flash/howcast_player.swf?file=5688"></param><param name="allowFullScreen" value="true"></param><param name="allowScriptAccess" value="always"></param><embed src="http://www.howcast.com/flash/howcast_player.swf?file=5688" type="application/x-shockwave-flash" width="425" height="352" allowFullScreen="true" allowScriptAccess="always" ></embed></object>]]>
        </embed>
        <duration>263</duration>
        <filename>http://media.howcast.com/system/videos/4/88/56/5688.flv</filename>
        <tags>pmt, pmt(), loan calculator, microsoft excel, ms excel, excel 2003</tags>
        <category-hierarchy>
          <category id="1470">Technology</category>
          <category parent_id="1470" id="1494">Computer Software</category>
          <category parent_id="1494" id="1499">Spreadsheets</category>
        </category-hierarchy>
        <comment-count>0</comment-count>
        <thumbnail-url>http://img.howcast.com/system/thumbnails/5688/130_xxlarge_maintained_aspect.jpg</thumbnail-url>
        <permalink>http://www.howcast.com/videos/5688-Basic-Excel-How-To-Create-a-Loan-Calculator</permalink>
      </video>
      <video>
        <category-id>1499</category-id>
        <id>5690</id>
        <title>Advanced Excel: How To Create a Drop Down Box in a Cell</title>
        <type nil="true"></type>
        <views>1900</views>
        <created-at>Thu, 01 May 2008 00:09:38 -0700</created-at>
        <rating>1</rating>
        <username>chrisleroy</username>
        <description>
          <![CDATA[Learn how to create a drop down box in a worksheet cell using the Data Validation function.

If you would like to learn more about Microsoft Excel visit our website - www.NQTraining.com/learnexcel.asp ]]>
        </description>
        <embed>
          <![CDATA[<object width="425" height="352" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" id="howcastplayer"><param name="movie" value="http://www.howcast.com/flash/howcast_player.swf?file=5690"></param><param name="allowFullScreen" value="true"></param><param name="allowScriptAccess" value="always"></param><embed src="http://www.howcast.com/flash/howcast_player.swf?file=5690" type="application/x-shockwave-flash" width="425" height="352" allowFullScreen="true" allowScriptAccess="always" ></embed></object>]]>
        </embed>
        <duration>273</duration>
        <filename>http://media.howcast.com/system/videos/6/90/56/5690.flv</filename>
        <tags>data validation, drop down box, microsoft excel, excel 2003</tags>
        <category-hierarchy>
          <category id="1470">Technology</category>
          <category parent_id="1470" id="1494">Computer Software</category>
          <category parent_id="1494" id="1499">Spreadsheets</category>
        </category-hierarchy>
        <comment-count>0</comment-count>
        <thumbnail-url>http://img.howcast.com/system/thumbnails/5690/135_xxlarge_maintained_aspect.jpg</thumbnail-url>
        <permalink>http://www.howcast.com/videos/5690-Advanced-Excel-How-To-Create-a-Drop-Down-Box-in-a-Cell</permalink>
      </video>
      <video>
        <category-id>1499</category-id>
        <id>20109</id>
        <title>How To Group Dates By Month and Quarter in a Pivot Table in Microsoft Excel 2003</title>
        <type nil="true"></type>
        <views>2877</views>
        <created-at>Wed, 16 Jul 2008 23:35:51 -0700</created-at>
        <rating>2</rating>
        <username>chrisleroy</username>
        <description>
          <![CDATA[Learn how to create a pivot table from scratch and then group the dates in your pivot table into Months, Quarters and Year in Microsoft Excel 2003.

For more information on Micrsoft Excel visit - www.NQTraining.com/learnexcel.asp]]>
        </description>
        <embed>
          <![CDATA[<object width="425" height="352" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" id="howcastplayer"><param name="movie" value="http://www.howcast.com/flash/howcast_player.swf?file=20109"></param><param name="allowFullScreen" value="true"></param><param name="allowScriptAccess" value="always"></param><embed src="http://www.howcast.com/flash/howcast_player.swf?file=20109" type="application/x-shockwave-flash" width="425" height="352" allowFullScreen="true" allowScriptAccess="always" ></embed></object>]]>
        </embed>
        <duration>263</duration>
        <filename>http://media.howcast.com/system/videos/5/09/01/02/20109.flv</filename>
        <tags>grouping dates, group months, pivot table, microsoft excel, excel 2003, ms excel 2003</tags>
        <category-hierarchy>
          <category id="1470">Technology</category>
          <category parent_id="1470" id="1494">Computer Software</category>
          <category parent_id="1494" id="1499">Spreadsheets</category>
        </category-hierarchy>
        <comment-count>0</comment-count>
        <thumbnail-url>http://img.howcast.com/system/thumbnails/20109/130_xxlarge_maintained_aspect.jpg</thumbnail-url>
        <permalink>http://www.howcast.com/videos/20109-How-To-Group-Dates-By-Month-and-Quarter-in-a-Pivot-Table-in-Microsoft-Excel-2003</permalink>
      </video>
      <video>
        <category-id>1499</category-id>
        <id>24433</id>
        <title>Episode 816 - Total Red Cells</title>
        <type nil="true"></type>
        <views>33</views>
        <created-at>Thu, 07 Aug 2008 13:29:37 -0700</created-at>
        <rating>1</rating>
        <username>mrexcel</username>
        <description>
          <![CDATA[Say that you need to add up all of the red cells. This is easier in Excel 2007 using Filter by Color. &lt;a href="http://mrexcel.libsyn.com/media/mrexcel/podcast816.mp4"&gt;Episode 816&lt;/a&gt; will show you how to do this in Excel 2007 as well as a clever trick using find ]]>
        </description>
        <embed>
          <![CDATA[<object width="425" height="352" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" id="howcastplayer"><param name="movie" value="http://www.howcast.com/flash/howcast_player.swf?file=24433"></param><param name="allowFullScreen" value="true"></param><param name="allowScriptAccess" value="always"></param><embed src="http://www.howcast.com/flash/howcast_player.swf?file=24433" type="application/x-shockwave-flash" width="425" height="352" allowFullScreen="true" allowScriptAccess="always" ></embed></object>]]>
        </embed>
        <duration>140</duration>
        <filename>http://media.howcast.com/system/videos/3/33/44/02/24433.flv</filename>
        <tags>Excel, business, accounting, spreadsheets, technology, MrExcel, Excel 2007, tutorial, filter</tags>
        <category-hierarchy>
          <category id="1470">Technology</category>
          <category parent_id="1470" id="1494">Computer Software</category>
          <category parent_id="1494" id="1499">Spreadsheets</category>
        </category-hierarchy>
        <comment-count>0</comment-count>
        <thumbnail-url>http://img.howcast.com/system/thumbnails/24433/70_xxlarge_maintained_aspect.jpg</thumbnail-url>
        <permalink>http://www.howcast.com/videos/24433-Episode-816-Total-Red-Cells</permalink>
      </video>
      <video>
        <category-id>1499</category-id>
        <id>24435</id>
        <title>Episode 815 - 801 Chart Redux</title>
        <type nil="true"></type>
        <views>24</views>
        <created-at>Thu, 07 Aug 2008 13:33:07 -0700</created-at>
        <rating>1</rating>
        <username>mrexcel</username>
        <description>
          <![CDATA[I was pretty happy with my tricky chart back in Episode 801, but
couldn't find a way to be tricky in Excel 2007. Today, both Eddie and
Ricardo send in brilliant ideas to get the sum of three stacked columns
to appear on top of the stack of columns. &lt;a href="http://mrex]]>
        </description>
        <embed>
          <![CDATA[<object width="425" height="352" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" id="howcastplayer"><param name="movie" value="http://www.howcast.com/flash/howcast_player.swf?file=24435"></param><param name="allowFullScreen" value="true"></param><param name="allowScriptAccess" value="always"></param><embed src="http://www.howcast.com/flash/howcast_player.swf?file=24435" type="application/x-shockwave-flash" width="425" height="352" allowFullScreen="true" allowScriptAccess="always" ></embed></object>]]>
        </embed>
        <duration>193</duration>
        <filename>http://media.howcast.com/system/videos/5/35/44/02/24435.flv</filename>
        <tags>Excel, business, accounting, spreadsheets, technology, MrExcel, charting, Excel 2007, tutorial</tags>
        <category-hierarchy>
          <category id="1470">Technology</category>
          <category parent_id="1470" id="1494">Computer Software</category>
          <category parent_id="1494" id="1499">Spreadsheets</category>
        </category-hierarchy>
        <comment-count>0</comment-count>
        <thumbnail-url>http://img.howcast.com/system/thumbnails/24435/95_xxlarge_maintained_aspect.jpg</thumbnail-url>
        <permalink>http://www.howcast.com/videos/24435-Episode-815-801-Chart-Redux</permalink>
      </video>
      <video>
        <category-id>1499</category-id>
        <id>24438</id>
        <title>Episode 814 - Renaming Sheets</title>
        <type nil="true"></type>
        <views>14</views>
        <created-at>Thu, 07 Aug 2008 13:36:17 -0700</created-at>
        <rating>1</rating>
        <username>mrexcel</username>
        <description>
          <![CDATA[After all of these episodes about using the macro recorder, Jonathan
tried to record a macro to rename worksheets. The code fails sometimes
and works other times. We will take a look at that code and understand
how to generalize it to have it always work in &lt;a href="ht]]>
        </description>
        <embed>
          <![CDATA[<object width="425" height="352" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" id="howcastplayer"><param name="movie" value="http://www.howcast.com/flash/howcast_player.swf?file=24438"></param><param name="allowFullScreen" value="true"></param><param name="allowScriptAccess" value="always"></param><embed src="http://www.howcast.com/flash/howcast_player.swf?file=24438" type="application/x-shockwave-flash" width="425" height="352" allowFullScreen="true" allowScriptAccess="always" ></embed></object>]]>
        </embed>
        <duration>190</duration>
        <filename>http://media.howcast.com/system/videos/1/38/44/02/24438.flv</filename>
        <tags>Excel, business, accounting, spreadsheets, technology, MrExcel, VBA, tutorial</tags>
        <category-hierarchy>
          <category id="1470">Technology</category>
          <category parent_id="1470" id="1494">Computer Software</category>
          <category parent_id="1494" id="1499">Spreadsheets</category>
        </category-hierarchy>
        <comment-count>0</comment-count>
        <thumbnail-url>http://img.howcast.com/system/thumbnails/24438/95_xxlarge_maintained_aspect.jpg</thumbnail-url>
        <permalink>http://www.howcast.com/videos/24438-Episode-814-Renaming-Sheets</permalink>
      </video>
      <video>
        <category-id>1499</category-id>
        <id>24439</id>
        <title>Episode 812 - Recording AutoSum Don't!</title>
        <type nil="true"></type>
        <views>29</views>
        <created-at>Thu, 07 Aug 2008 13:40:16 -0700</created-at>
        <rating>1</rating>
        <username>mrexcel</username>
        <description>
          <![CDATA[Today, a closer look at the macro from Episode 811. While it LOOKED
like it worked, the recorded macro leaves a lot to be desired. Your
totals will be wrong if you rely on the AutoSum button during macro
recording. &lt;a href="http://mrexcel.libsyn.com/media/mrexcel/podca]]>
        </description>
        <embed>
          <![CDATA[<object width="425" height="352" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" id="howcastplayer"><param name="movie" value="http://www.howcast.com/flash/howcast_player.swf?file=24439"></param><param name="allowFullScreen" value="true"></param><param name="allowScriptAccess" value="always"></param><embed src="http://www.howcast.com/flash/howcast_player.swf?file=24439" type="application/x-shockwave-flash" width="425" height="352" allowFullScreen="true" allowScriptAccess="always" ></embed></object>]]>
        </embed>
        <duration>218</duration>
        <filename>http://media.howcast.com/system/videos/2/39/44/02/24439.flv</filename>
        <tags>Excel, business, accounting, spreadsheets, technology, MrExcel, VBA, tutorial</tags>
        <category-hierarchy>
          <category id="1470">Technology</category>
          <category parent_id="1470" id="1494">Computer Software</category>
          <category parent_id="1494" id="1499">Spreadsheets</category>
        </category-hierarchy>
        <comment-count>0</comment-count>
        <thumbnail-url>http://img.howcast.com/system/thumbnails/24439/105_xxlarge_maintained_aspect.jpg</thumbnail-url>
        <permalink>http://www.howcast.com/videos/24439-Episode-812-Recording-AutoSum-Dont</permalink>
      </video>
      <video>
        <category-id>1499</category-id>
        <id>24441</id>
        <title>Episode 811 - Mixed Recording</title>
        <type nil="true"></type>
        <views>21</views>
        <created-at>Thu, 07 Aug 2008 13:44:38 -0700</created-at>
        <rating>1</rating>
        <username>mrexcel</username>
        <description>
          <![CDATA[Part 1 of 2: Many times, you have to use a clever mix of relative and
absolute recording to get the macro to perform certain tasks. The goal
today is to navigate to the bottom of a data set, add totals, and then
move back to row 1. &lt;a href="http://mrexcel.libsyn.com/me]]>
        </description>
        <embed>
          <![CDATA[<object width="425" height="352" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" id="howcastplayer"><param name="movie" value="http://www.howcast.com/flash/howcast_player.swf?file=24441"></param><param name="allowFullScreen" value="true"></param><param name="allowScriptAccess" value="always"></param><embed src="http://www.howcast.com/flash/howcast_player.swf?file=24441" type="application/x-shockwave-flash" width="425" height="352" allowFullScreen="true" allowScriptAccess="always" ></embed></object>]]>
        </embed>
        <duration>251</duration>
        <filename>http://media.howcast.com/system/videos/4/41/44/02/24441.flv</filename>
        <tags>Excel, business, accounting, spreadsheets, technology, MrExcel, VBA, tutorial</tags>
        <category-hierarchy>
          <category id="1470">Technology</category>
          <category parent_id="1470" id="1494">Computer Software</category>
          <category parent_id="1494" id="1499">Spreadsheets</category>
        </category-hierarchy>
        <comment-count>0</comment-count>
        <thumbnail-url>http://img.howcast.com/system/thumbnails/24441/125_xxlarge_maintained_aspect.jpg</thumbnail-url>
        <permalink>http://www.howcast.com/videos/24441-Episode-811-Mixed-Recording</permalink>
      </video>
      <video>
        <category-id>1499</category-id>
        <id>24442</id>
        <title>Episode 809 - Format Macro</title>
        <type nil="true"></type>
        <views>62</views>
        <created-at>Thu, 07 Aug 2008 13:48:07 -0700</created-at>
        <rating>1</rating>
        <username>mrexcel</username>
        <description>
          <![CDATA[Record a simple macro in Excel 2007. In &lt;a href="http://mrexcel.libsyn.com/media/mrexcel/podcast809.mp4"&gt;Episode 809&lt;/a&gt;,
we take a look at a simple macro that the macro recorder can reliably
record. The trick is that you never move the cell pointer during the]]>
        </description>
        <embed>
          <![CDATA[<object width="425" height="352" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" id="howcastplayer"><param name="movie" value="http://www.howcast.com/flash/howcast_player.swf?file=24442"></param><param name="allowFullScreen" value="true"></param><param name="allowScriptAccess" value="always"></param><embed src="http://www.howcast.com/flash/howcast_player.swf?file=24442" type="application/x-shockwave-flash" width="425" height="352" allowFullScreen="true" allowScriptAccess="always" ></embed></object>]]>
        </embed>
        <duration>197</duration>
        <filename>http://media.howcast.com/system/videos/5/42/44/02/24442.flv</filename>
        <tags>Excel, business, accounting, spreadsheets, technology, MrExcel, VBA, tutorial</tags>
        <category-hierarchy>
          <category id="1470">Technology</category>
          <category parent_id="1470" id="1494">Computer Software</category>
          <category parent_id="1494" id="1499">Spreadsheets</category>
        </category-hierarchy>
        <comment-count>0</comment-count>
        <thumbnail-url>http://img.howcast.com/system/thumbnails/24442/95_xxlarge_maintained_aspect.jpg</thumbnail-url>
        <permalink>http://www.howcast.com/videos/24442-Episode-809-Format-Macro</permalink>
      </video>
      <video>
        <category-id>1499</category-id>
        <id>24443</id>
        <title>Episode 808 - Where Are Macros?</title>
        <type nil="true"></type>
        <views>50</views>
        <created-at>Thu, 07 Aug 2008 13:51:25 -0700</created-at>
        <rating>2</rating>
        <username>mrexcel</username>
        <description>
          <![CDATA[In our second Where is it Wednesday episode, we take a look at how to unlock all of the macro functionality in Excel 2007. &lt;a href="http://mrexcel.libsyn.com/media/mrexcel/podcast808.mp4"&gt;Episode 808&lt;/a&gt; shows you how.&lt;br/&gt;&lt;br/&gt;This blog is the video ]]>
        </description>
        <embed>
          <![CDATA[<object width="425" height="352" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" id="howcastplayer"><param name="movie" value="http://www.howcast.com/flash/howcast_player.swf?file=24443"></param><param name="allowFullScreen" value="true"></param><param name="allowScriptAccess" value="always"></param><embed src="http://www.howcast.com/flash/howcast_player.swf?file=24443" type="application/x-shockwave-flash" width="425" height="352" allowFullScreen="true" allowScriptAccess="always" ></embed></object>]]>
        </embed>
        <duration>205</duration>
        <filename>http://media.howcast.com/system/videos/6/43/44/02/24443.flv</filename>
        <tags>Excel, business, accounting, spreadsheets, technology, MrExcel, VBA, tutorial, interface</tags>
        <category-hierarchy>
          <category id="1470">Technology</category>
          <category parent_id="1470" id="1494">Computer Software</category>
          <category parent_id="1494" id="1499">Spreadsheets</category>
        </category-hierarchy>
        <comment-count>0</comment-count>
        <thumbnail-url>http://img.howcast.com/system/thumbnails/24443/100_xxlarge_maintained_aspect.jpg</thumbnail-url>
        <permalink>http://www.howcast.com/videos/24443-Episode-808-Where-Are-Macros</permalink>
      </video>
    </related-videos>
    <comments count="0"/>
  </video>
</howcast>
