MrExcel Excel Videos

Play ball! In honor of baseballs opening day, learn how to display a number in fractions, such as the Innings Pitched column in Cy Youngs lifetime stats. Episode 477 shows you how. This blog is the video netcast companion to the upcoming book, Excel 2007 Miracles Made Easy. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the book!

Bills favorite Excel-related April Fools day trick will freak out your manager. Take a look at how this old trick plays out in the old Excel, the new Excel, and in Vista. Episode 476 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 MVP from Brazil Robert Martim shows how to set up a 2-level data validation. Episode 475 shows you how. Download the file used in this podcast from http://www.mrexcel.com/RM2.zip

**** Kusleika is our guest podcaster today. **** is the host of the Daily Dose of Excel. He shows how to troubleshoot formulas by evaluating parts of a formula right in the formula bar. Episode 474 shows you how.

Sure it is easy to add up a column of numbers in Excel, but did you know that you can do this in Microsoft Word as well? Our guest host today is Word MVP Tony Jollans. In Episode 473, Tony shows you how to add up a column of numbers in Word.

Do you need to turn data on its side in Excel 2007? PowerPoint MVP Kathy Jacobs shares her favorite new feature in Excel 2007. Episode 472 show you how.

Todays guest podcaster is Curt Frye, author of the Step by Step series for Excel. Curt shows off some cool fill handle tricks. Episode 471 shows you how.

Todays guest podcaster is MVP Zack Barresse. Zack shows how to apply a greenbar formatting using a cool conditional formatting formula. Episode 470 shows you how.

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!