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.
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: Stop taking clunky screenshots of your data that
Why the "File" tab is the most powerful button you’ve never clicked. Here are three "hidden treasures" from the book
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. the picture updates too.
You will be frustrated that you spent five years using Excel the slow way. You will be frustrated that Microsoft buried the "Fill Justify" feature (a secret text-wrapping wizard) so deep in the menus that no normal person would ever find it.
But "fine" leaves money on the table. It wastes hours of repetitive clicking.
Beyond SUM and AVERAGE: Unlocking David Ringstrom’s Hidden Treasures in Excel