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
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
MrExcel Excel Videos
Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
**** 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!
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!
