MrExcel Excel Videos

Mike Girven pointed me to an excellent whitepaper by Charles Williams about calculation speed. In Episode 1011, an example contrasting different ways of entering running totals. One calculates 100 times faster than the other! 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!

A dueling podcast: how to unwind a rectangular selection to a single column. Mike & Bill weigh in with differing methods in Episode 1010. 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!

3 fast tips from my recent seminar in Louisville Kentucky: Different way to select current region; different way to Undo; How to overline and underline subtotals. Episode 1009 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!

Marcelo asks how to replicate all of the formatting on an existing chart. In Excel 2003, this was Chart, Custom Types, User Defined, Add. In Episode 1008, we take a look at the equivalent method in Excel 2007. 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!

William asks how to base his conditional formats on a start date in column A and a duration in column B. This calls for the Formula version of conditional formatting. Episode 1007 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!

Ileane asks how to get only the .edu e-mail addresses from a database of 20,000 e-mails. Episode 1006 shows you how to use advanced filter with a criteria range to solve this problem. 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!

Another Dueling podcast: How to filter to the top 5 golf scores for one golfer? The AutoFilter won't let you do it. But Mike and Bill show you how in Episode 1005. 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!

Viewer George sends in a column of dates that refuses to be sorted. George says that he already tried converting the text dates to dates using the text to columns trick. In Episode 489, well take a look at two methods to tell if your dates are really dates and how to convert them to real dates. 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!

Bill Gates asked the question: The ribbon is fine, but there will be a classic mode, right?. The Office interface team convinced Bill that this was not the way to go. And, unfortunately, learning the new ribbon is the #1 complaint about Office 2007. Well, the folks at www.addintools.com did for you what Microsoft would not do, they brought the classic Excel 2003 menu bar, plus the standard and formatting toolbars back to Excel 2007. The add-in is perfect for someone who is trying to learn Excel 2007 in a pain-free manner and is now available at www.mrexcel.com. If you need a new feature, you can use the new ribbon tabs. But, if you need to use an item off the old menu, just stay right on the new Menu tab and find the menu exactly where...