Excel Power Moves

Excel has a knack for hiding useful capabilities in plain sight. In Excel Power Moves, Bob Umlas demonstrates clever ways to work with formulas, dynamic arrays, formatting, and VBA—often turning a familiar spreadsheet task into a chance to use Excel more precisely.

The examples are hands-on and specific: account for visible rows in a calculation, add explanatory notes inside a formula, find overlooked worksheet features, and build shortcuts into VBA workflows. Umlas shows the reasoning behind the techniques, so readers can understand what a formula or feature is doing rather than simply copy a result.

Make formulas do more

The formulas section tackles real spreadsheet puzzles, including calculating totals in filtered data, handling subtotals, and using the N function to add a comment within a formula without changing its numeric result. These examples offer useful ways to think through Excel’s behavior when a straightforward approach runs into trouble.

Find the features hiding in plain sight

Formatting and miscellaneous tips explore less-obvious options for managing worksheets, working with print areas, navigating, and handling cell contents. The emphasis is on practical discoveries that can make routine spreadsheet work feel less cumbersome.

Explore dynamic arrays and VBA

Later sections turn to dynamic-array techniques, including generating lists and creating a linked table of contents for workbook sheets. The VBA material covers shortcuts and routines, alongside topics such as selecting from a list, filling ranges, and working with user forms.

For curious Excel users

This book will appeal most to readers who already use Excel and want to go beyond familiar basics. Formula enthusiasts, spreadsheet power users, and people exploring VBA can dip into the examples that match their work—or follow Umlas’s demonstrations to discover approaches they might not have thought to try.