Beyond SUM and AVERAGE: Unlocking David Ringstrom’s Hidden Treasures in Excel

Stop taking clunky screenshots of your data that become outdated the second you change a number. Ringstrom reveals how to use the Camera Tool to take a "live photograph" of a range. Paste that picture anywhere—even on a Dashboard tab—and when you update the original cells, the picture updates too. Magic.

But "fine" leaves money on the table. It wastes hours of repetitive clicking.

Download the PDF. Skip the chapters on Charts (we all know how to make a bar graph). Go straight to the "Data" and "Review" tab chapters. That is where the real gold is buried. Have you read Ringstrom’s guide? What is the one "hidden treasure" you use every day? Let me know in the comments below.

Most people have it empty. Ringstrom argues you should cram it with 15+ commands. The hidden treasure isn't a single feature—it’s the customization of your workspace. Spend 10 minutes setting up your QAT exactly as he maps out in Chapter 3, and you will save 10 minutes every single day going forward. Yes. But only if you are ready to be frustrated.

David Ringstrom’s Exploring Microsoft Excel’s Hidden Treasures is not for beginners. It is for the "intermediate user" who knows just enough to be dangerous but wants to become the office Excel wizard.