MrExcel Excel Videos

I realize this is the Learn Excel podcast, but we have a Word tip today from Anne Troy aka Dreamboat, author of Dreamboat On Word. Have you ever changed a character in Word and had the format of the entire paragraph change? Our guest podcast host, Anne Troy will show you why that happens in Episode 468.

Todays podcast is the first in a series featuring guest podcasters. Bob Umlas, Excel MVP and author This Isnt Excel, Its Magic shares one of the tips from his book. This is one of my favorite Bob Umlas tips how to add a blank row between every row in your dataset. Episode 467 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!

Episode 466 shows how to get rid of leading spaces while leaving the interior spaces intact. Plus news on Microsoft MVP Summit from Seattle and preview of Excel guest appearances on the MrExcel podcasts. 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!

As the NCAA games start today, the commissioner needs to track how many games youve won, but also to see in the future to see how many games you are guaranteed to lose in future rounds. Nothing is worse (for you) than having a Cinderella team knock out your winner in the whole tournament. The Excel-based NCAA bracket takes a look at not just what games you have won, but also what games where your winning team has already been knocked out of the bracket. Episode 465 shows 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 offices throughout the US, people are starting to turn in their NCAA bracket sheets to the office commissioner. Whether you are asking accountants to fill out an NCAA bracket or sales reps to fill out a sales forecast, it makes sense to collect the data in an Excel workbook. In Episode 464, we take a look at a macro that can be used to gather entries from the individual worksheets and combine them into a master worksheet.

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!