Taylor has to find Averages within Ranges of the Data Set. Bill ‘MrExcel’ Jelen immediately sets up a Pivot Table – Mike ‘ExcelisFun’ Girvin chooses to go with a different method using =AVERAGEIF and more. Mike and Bill also encourage us to check out the New SpeedTools Add-in featuring the work of Charles Williams -‘The Master of Fast’- with dozens of functions including Fast, Efficient VLOOKUPs. Follow along with Episode #1657 to solve the Average question and to learn more about the New Add-in from Charles Williams.

[youtube=http://youtube.com/watch?v=3mc6f3ShFCU]

Dueling Excel Podcasts…This episode is the video podcast companion to the book, “Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel Fun“, by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and as a DVD Bundle]

and

“Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!