MrExcel Excel Videos

After yesterdays podcast about ASTM E29 rounding, I produce a function in VBA that will correctly do the bankers rounding algorithm in Excel. Episode 1047 shows you how. 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!

One of my Greatest Hits a fast way to copy a formula down to all rows. Episode 579 shows you how. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Mike from Kansas City asks if there is a way to take words from many adjacent cells and merge them into a single cell. Episode 578 shows many approaches to this problem. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Using the EOMonth function to find the end of a month N months in the future. Episode 577 shows you how. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

In today's Episode 576, I ask, "How many episodes of the MrExcel Podcast should we include in our RSS feed?" This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

A quick trick showing how you can make a formula point to a new range without typing the range. Episode 575 shows you how. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

If you need to fill a cell with a character, either with or without numbers, there are a couple of interesting alternatives. Episode 574 shows you how. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

All Excel formulas start with an equal sign, right? It turns out that Excel will allow you to create your formulas with a plus sign instead. Episode 573 shows off the arrow key method for creating formulas. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Excel 2007 adds some amazing new features to the Excel 2003 AutoFilter technology. Learn how you can filter to multiple items, by month or by color. Episode 572 shows you how. This blog is the video netcast companion to the new book, Excel 2007 Miracles Made Easy. Download a new two minute video every workday to learn one of the tips from the book!