Excel Outside the Box

Excel problems do not always yield to the obvious formula or familiar menu command. In Excel Outside the Box, Bob Umlas gathers more than 50 inventive techniques for readers who already know their way around a spreadsheet and want fresh ways to handle the stubborn cases.

The examples move across formulas, array formulas, pivot tables, charts, Excel features, and VBA. Rather than stopping at general advice, the book works through specific challenges—from reshaping or extracting data to making charts respond dynamically—so experienced users can study the approach and adapt it to their own worksheets.

Practical answers to tricky spreadsheet problems

Chapters explore techniques such as building a formula with a formula, combining values, working with non-contiguous ranges, finding multiple answers with VLOOKUP, and extracting useful information from text. The examples give readers a chance to see how Excel’s functions can be combined to address situations that ordinary, one-step solutions may not handle well.

Go further with array formulas and charts

Array formulas receive substantial attention, alongside dynamic range names, charting, and ways to show a chart only when its data is complete. These sections are especially relevant to users who want to make complex calculations or presentation behavior work more intelligently within a worksheet.

VBA ideas for hands-on Excel users

The VBA chapter covers applied tasks including inserting totals, working with worksheet tabs, cleaning cells, and using a user-defined function. The book also visits data validation, conditional formatting, pivot tables, and other features that can help solve real spreadsheet snags.

For readers who have outgrown the basics

This is aimed at intermediate-to-advanced Excel users, developers, and spreadsheet practitioners who enjoy understanding how a solution works—not just copying a result. If you regularly face unusual formula, data, or automation problems, Umlas’s collection offers a useful set of alternative approaches to consider.