Auto-SUM is pretty straight foward – it resides on the Ribbon of Excel. But what about ‘Auto-Average’? Today, the student enlightens the teacher when Bill finds out that ‘Auto-Average’ will reside on the Ribbon as a one-click function. Follow along with Episode #1557 to find out how to add Auto-Average, Min, Max and others to the Ribbon of Excel for one-click functionality.

[youtube=http://www.youtube.com/watch?v=plGrqMzUneg]

"Don't Fear The Spreadsheet" - Available 1-June-2012!…This episode is the video podcast companion to the book, “Don’t Fear The Spreadsheet” by Tyler Nash, Bill Jelen, Tom Urtis and Kevin Jones. The Soon To Be Released Excel Book, “Don’t Fear The Spreadsheet” [Available 1-June-2012] is for beginners, by a beginner. Nothing is assumed and all of the basics are explained in “Don’t Fear The Spreadsheet”

and

"Learn Excel 2007 through Excel 2010 from MrExcel" by Bill Jelen…the book, 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”

Visit us: MrExcel.com for all of your Microsoft Excel Needs!