MrExcel Excel Videos

In our continuing look at importing text files, todays netcast discussed how to import fixed width files into Excel. Watch to learn why choosing the text column type will cause your formulas to never work. Episode 458 provides the details. 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 import a text file into Excel, you will need to use the text to columns wizard. Before you start importing text, you need to figure out if your dataset is fixed width or delimited. Episode 457 will explain the difference. 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 from Akron notes that when he inserts new columns in Excel, Excel is automatically extending the size of any charts that happen to span the new column. With most objects, you can right-click and indicate that you dont want to move or size with cells. However, charts dont seem to have the ability to change the resizing options. Episode 456 will show you the bizarre solution. 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!

Joe writes in with a question of how to subtract the most second most recent price in the row from the most recent price. The solution involves the relatively obscure OFFSET function. Episode 455 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!

Scott from Australia sent in what should have been a simple lotto question. However, I chose to solve the problem using an array formula. Now, as far as I know, no one has ever tried to explain an array formula in a 2 minute podcast. Episode 454 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!

After Scotts question for tomorrows podcast, I thought it would be cool to see how a pivot table could analyze the most popular lottery numbers. The MegaMillions jackpot in several US states is up to $216 million and today's podcast will select the most popular numbers. Episode 453 shows you how. UPDATE: the Mega Millions download site has changed. For a lengthy 2014 video showing more complete steps, watch: 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!

Rupal asks how to return the worksheet name as the result of a formula. Episode 452 shows the obscure function which can be adapted to solve 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!

Heidi asks a question that is a new twist on an old problem how to fill in the blank cells in a range with an outline numbering system. Episode 451 shows how to adapt the technique discussed in Learn Excel to solve 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!

As a follow-up to yesterdays netcast, Episode 450 shows you how to unhide column A and a cool trick left over from Lotus 1-2-3 where you can see what is in the hidden columns without unhiding them. 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!