MrExcel Excel Videos

You can hide several sheets with a single command, but you have to unhide sheets one at a time. Today, using a little VBA, we turn unhiding into a single keystroke. Episode 611 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!

We figure out the thickness of a coat of paint, live from the site of the Worlds Largest Ball of Paint. Episode 610 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!

Mike Girvin wonders why Joe from Episode 977 doesn't just sort the data so that all the filtered records are together? You can do this if you use an Original Sequence column so that you can sort back. Episode 982 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!

Gary sends in a clever solution for Episode 977 which uses the Skip Blanks option of the Paste Special dialog. Watch for how Gary can "reverse" the filtered and hidden rows during the steps shown in Episode 981. 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!

Mike Girvin and Bill Jelen meet up again to offer three solutions to the problem of counting how many records match a wildcard criteria. Episode 980 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!

I want to revisit a topic from podcast 613; using the COLUMN() function in place of putting a 2 as the third argument in a VLOOKUP function. Several questions came in about that technique, and in Episode 629, I will try to clear up the confusion. 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!

Sometimes, you might need to rearrange the headings in a pivot table. You can easily do this with dragging and dropping or simply by typing a new name in a new location. Episode 628 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!

When recording a macro to enter a SUM formula, you might need to write a formula that freezes one half of the reference for the summed range. Episode 627 shows you why. 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!

The macro recorder uses a confusing way to name ranges. There is a much simpler way, as podcast 626 shows. 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!