Login or Join

Excel Videos

newest 100 excel videos / excel widget | Video feed for excel

Videos 1 to 20

Divide Range by Range - 1141 - Learn Excel from MrExcel Podcast

Divide Range by Range - 1141 - Learn Excel from MrExcel Podcast

from Learn Excel from MrExcel Video Podcast on November 10, 2009
Duration: 0
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!
also in:                            


Microsoft Office 2010 Comparison Screencast

Microsoft Office 2010 Comparison Screencast

from popular posts - blip.tv (beta) on November 09, 2009
Duration: 369
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
also in:                              


Avoid a Loop - 1140 - Learn Excel from MrExcel Podcast

Avoid a Loop - 1140 - Learn Excel from MrExcel Podcast

from Learn Excel from MrExcel Video Podcast on November 09, 2009
Duration: 0
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!
also in:                            


Duel: Portugal - 1139 - Learn Excel from MrExcel Podcast

Duel: Portugal - 1139 - Learn Excel from MrExcel Podcast

from MrExcel on November 06, 2009
Duration: 369
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!
also in:                      


How to Embed Lookup in Excel

How to Embed Lookup in Excel

from MrExcel on November 02, 2009
Duration: 199
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.
also in: