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.
We all know the drill. You open Microsoft Excel, type your data into a neat grid, hit SUM at the bottom, maybe slap on a filter, and call it a day. For 80% of users, that is Excel. It works. It’s fine. Stop taking clunky screenshots of your data that
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. For 80% of users, that is Excel
But "fine" leaves money on the table. It wastes hours of repetitive clicking. For 80% of users
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.
Here is what Ringstrom argues (and proves): The Treasure Map: What’s Inside the PDF You won’t find a list of "Top 10 Keyboard Shortcuts" here (though those are included). Instead, Ringstrom digs into the psychological barriers that keep us from using better tools. Here are three "hidden treasures" from the book that I have already implemented: