MrExcel Excel Videos

As a follow-up to Episode #1252, "Once you've used the HLOOKUP to return the last value in the row, can you find the date associated with that entry?" Yes, you can! Today, in Episode #1254, Bill shows us how to locate the last value in a row of data and return that value to our designated cell using the INDEX and MATCH Functions. ...This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

A 3-D Reference (also known as a 'Spearing Formula') is when you need to shoot through a series of worksheets to add up the same cell on many worksheets. Episode #1253 shows you how to create these references in just a few clicks! ...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel. For all of your Microsoft Excel needs visit MrExcel.com - Your One Stop for Excel Tips and Solutions.

A question from my seminar at the NAESA conference in New Orleans (September 2010): "How can I return the last value entered in a particular row?" Episode #1252 will show you how. "Learn Excel 97 - 2007 from MrExcel"

Podcast #1251 introduces my newest book, "Rev Up to Excel 2010 - Upgraders Guide to Excel 2010". In Chapter 1, Today I take a look at how to get the elusive mini toolbar to appear. "Rev Up To Excel 2010: Upgraders Guide to Excel 2010" Bill Jelen

Create SmartArt Business Diagrams in Excel 2010 where the text for the shapes is calculated by a formula. Smart Art will add dimension to your presentations. Follow along with Episode #1250 to enhance the visual presentation of your data.

The Picture Background Removal Tool has returned with more flexibility and a better quality image when your editing is completed. In Episode #1249, Bill shows you how to use the Background Removal feature in Excel 2010 to achieve the result you want!

Based on the examples in Professor Tufte's book, Excel can show min and max axis values in sparklines and can vary from chart to chart. Two simple changes will dramatically improve your sparklines in Excel! Episode #1248 shows you how!

Don't recreate your data field to update your chart in Excel 2010! In Episode #1247, Bill shows (3) methods of adding that new data to an existing chart by simply extending the data field. ..."Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel

The Border Drawing Tools are back in Excel 2010! Use the border drawing tools to quickly add borders to a cell or range of cells. Learn how to find and use them in Episode #1246, with "MrExcel" "Excel 2010 In Depth", by Bill Jelen