MrExcel Excel Videos

The first entries in the NCAA office pool are starting to come in and the commissioner of the NCAA pool will have to key your entries from the faxed USA Today bracket into the spreadsheet. In the MrExcel spreadsheet, concatenation formulas help to make sure that the teams keyed for each player are correct. Episode 463 shows you how to use FIND, ISERR, and IF functions to check to make sure your data entries are in a list of valid values. 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!

March Madness has begun and commissioners in offices throughout the US are using the office copier this morning to distribute copies of the NCAA bracket found in the USA Today. While you are invited to join the free MrExcel.com/ncaa.html contest, todays Episode 462 takes a look at the life of the NCAA commissioner using formulas to pre-enter your bracket selections in Excel. 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!

You are invited on Monday to download MrExcels NCAA bracket and enter his free NCAA pool. The winner will get their choice of books from the MrExcel store. In todays Episode 461, we will take a look at the Data Validation commands used to make the NCAA bracket selection worksheet work. 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!

Dan has an unusually wide spreadsheet where the page breaks suddenly disappear. This is a decade old problem and as soon as I heard the question, I remembered beating my head against my desk when this started happening to me back in the mid-90s. Episode 460 will take a look at what causes the problem and how it can be solved. 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!

How to highlight part of a line chart using a second area chart series. This trick works in Excel 2007, but not 2003. Episode 1016 shows you how. This video is the 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!

In today's dueling podcast, how to turn a range upside down. Episode #1015 shows you how. This video is the 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!

In our second look at Formula Recalc, a 750x improvement in formula recalc times by using some helper cells. Episode 1014 shows you how. This video is the 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!

Andre provides a set of formulas to chart the last rolling six months of data. Episode 1013 shows you how. This video is the 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!

Vaibhav asks how to group a pivot table up to fiscal quarters. While this is easy if your fiscal years ends on December 31, it is not so easy for other year-ending dates. Episode 1012 shows you how. This video is the 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!