Helper Cells - 1014 - Learn Excel from MrExcel Podcast

In our second look at Formula Recalc, a 750x improvement in formula recalc times by using some helper cells. Episode 1014 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!

Recalc Speed - 1011 - Learn Excel from MrExcel Podcast

Mike Girven pointed me to an excellent whitepaper by Charles Williams about calculation speed. In Episode 1011, an example contrasting different ways of entering running totals. One calculates 100 times faster than the other!

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!

Episode 557 - Manual Recalc

Do you have a spreadsheet where the calculation time is so long that you routinely use Manual Calculation mode? If so, John sends in a great tip for how to calculate only cells in a selected range. Episode 557 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!