MrExcel Excel Videos

Going back to Podcast 453, I talked about taking data from the Mega-Millions website and parsing this data in Excel. Dave wrote in to say that the text to columns process was not working out well. In Episode 566, I show how using Text to Columns sometimes requires a few extra steps. 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!

Back in Episode 548, I talked about the frustrating size of the scrollbar slider when you accidentally activate a cell that is outside of the normal range. Derek from the UK sends in a great solution in todays podcast. Episode 565 shows the completely unintuitive way 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!

Have you ever had an Excel calculation show up with a tiny fraction like .0000000002 at the end of the number? This prevents Excel from seeing if two numbers are equal or not. Episode 564 will show you two methods for dealing with 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!

Turn a list of customer locations into a map right in Excel using Microsoft MapPoint. In Episode 563, I show you how to use MapPoint to render a map in Excel, but then also how to make the map more suitable for viewing. 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!

Ryan from Schaumberg sends in a tip for improving Excels presentation of scientific notation. Episode 562 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!

Excel does not deal well with negative times. What if you are tracking vacation time and some employees go into a negative balance? Excel cant display negative times. However, with the trick in Episode 561, you can coerce Excel into displaying negative times. 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 can you figure out a date that is a certain number or workdays BEFORE a date? On the last episode of The Lab with Leo Laporte, I showed how to calculate a date 45 workdays after a certain date. Todays question is how to calculate the date 5 days before the end of the month. Episode 560 shows you how to calculate this value. 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!

Jeffrey wonders why the top row of his data won’t sort. He has a blank row between the data and the headers, which looks great, but is fooling the Intellisense. Episode 1051 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!

Today's dueling Excel podcast question is how to count all cells with times greater than five minutes. Episode 1050 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!