MrExcel Excel Videos

Laura, Erik, and Howard all sent in similar workarounds to podcast 713. Today in Episode 718, we will take a look at how to offer a validation dropdown that will allow keyboard afficianados to enter values quickly. 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!

Matthew from Washington wants to take an event database and create a visual calendar that shows availability. While this sounds simple, it requires several steps. The end result is fairly cool. Episode 717 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, in Episode 716 we take a look at the entries for the MapPoint contest, and also a chance to enter the MrExcel NCAA basketball game. 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!

March 14 (3-14) is Pi day and we will take a look at some calculations with the PI and SQRTPI functions in Episode 715. 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!

In yesterday's podcast, we were frustrated that the Validation dropdown would not allow us to type a few letters of the entry. In Episode 714, we will take a look at a tiny userform and macro to replace the validation dropdown. 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!

In Episode 713, a link to http:/www.mrexcel.com/excel_video_training.html, another link to http://www.mrexcel.com/video2003.html. Then, how to set up a dropdown list in Excel, but some frustration that the dropdown list won't let you type the first few letters of the value. 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!

**** sends in a cool question today. First, he figured an amazing way to grab the first value from a subtotaled group. But, Episode 712 shows three lines of VBA code to finish the process. 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!

Do you ever need to produce a report for every customer? This is a snap with pivot tables in Excel 2007. In Episode 711, we take a look at how to use Show Report Filter Pages to replicate a report for every customer. 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!

Learn how to filter a pivot table to only items from this week, last quarter, or next month. Episode 710 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!