Excel Videos

Rob from Cambridge needs to divide nine cells by nine other cells and sum them up. In Episode 1141, we look at an array formula to solve this problem. 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!

http://go.tagjag.com/screencast - http://twitter.com/chrispirillo - I recently asked all of you to submit your screencasts to me for review. The best of the best will be chosen to be featured here, in my various channels and outlets. This provides content of a different perspective for our community, and gives you new exposure for your work! Jack has submitted another excellent screencast, this time showing us a nice comparison between different versions of Microsoft Office. http://www.youtube.com/user/HaywardJack - http://chris.pirillo.com

A cool way to streamline a VBA loop using SpecialCells. Episode 1140 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!

A viewer from Portugal sends in a question about finding which row contains the match. Episode 1139 shows you a few ways to go! 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!

Nick asks how to do a pretty lengthy bonus calculation. It might be too complex for the Excel 2003 nested IF limit, so I decided to use the range version of VLOOKUP. But...as a twist, I embed the table right in the formula. Episode 1135 shows you how.