However, a discerning reader might note a limitation. Because the guide is distributed as a static PDF, many of the examples reference older versions of Excel (2013, 2016, or 2019). While the core treasures—PivotTables, VLOOKUP (and its superior successor XLOOKUP ), and IFERROR —remain relevant, the PDF does not cover Microsoft’s newer dynamic array formulas (like FILTER or SORT ) found in Excel 365. The "hidden treasures" of today are increasingly found in Power Query and LAMBDA functions, which are absent from earlier editions of this guide.
Perhaps the most valuable "treasure" Ringstrom explores is the humble (created via Ctrl + T ). To the untrained eye, a Table looks like a normal range with a few colored bands. However, Ringstrom reveals that Tables are magical: they automatically expand formulas to new rows, allow for structured references that are readable (e.g., =SUM(Table1[Sales]) instead of =SUM(C2:C100) ), and generate dynamic charts that update when new data is added. He positions Tables not as a feature, but as a foundational best practice for anyone building a lasting spreadsheet. However, a discerning reader might note a limitation
One of the key treasures Ringstrom highlights is the feature. While most users know Ctrl+F for finding values, Ringstrom demonstrates how F5 > Special allows you to select every cell with comments, constants, formulas, blanks, or even cells that are directly precedent to the active cell. He argues that mastering this tool eliminates hours of manual scrolling and clicking, especially when cleaning data sets riddled with blank rows or inconsistent formulas. The "hidden treasures" of today are increasingly found