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 878 – Pivot Formula Functions

Can you use a function in an Excel calculated field? Well, Bryony from the U.K. says yes you can, and sure enough…it works. Episode 878 shows an example of using a function to create a new field in a pivot cache. Fairly cool.

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!