More Excel Outside the Box

July 2015

More Excel Outside the Box

More Awesome Excel Techniques from Bob Umlas!

Bob Umlas is the Excel MVP who knows everything about Excel. I think that every time Bob discovers a new technique that is surprising even to him, it shows up in this book!

Bill Jelen, MrExcel

category: Spreadsheets
covers: Microsoft 365, Excel 2010 - 2016

Product Details
  • 112 Pages
  • Publisher: Holy Macro! Books
  • ISBN: 978-1-61547-036-5
  • PDF ISBN: 978-1-61547-222-2

A follow-up to Excel Outside the Box, More Excel Outside the Box is designed with the Excel guru in mind, introducing advanced, creative solutions and hacks for the software’s most challenging problems. Through a series of more than 30 techniques, tables, formulas, and charts, this guide details processes that may be used in any Excel application and across all disciplines. Creative approaches for building formulas within formulas, pivot tables, conditional formatting, and mastering array formulas are just some of the numerous challenges explained. Other higher-level solutions discussed include using VBA macro code to override cell calculations, solve for sums from a text string, and trimming and cleaning all cells on a worksheet. This is the all-encompassing resource for advanced users of Excel wanting to learn more techniques to broaden and empower their knowledge of the program.

  • Introduction
  • User Interface Topics
  • Using a Conditional Formatting On/Off Switch
  • Using Data Validation to Prohibit Entry of Digits
  • Making a Change in One Column Based on Criteria in Another (Without VBA)
  • Changing Row Height When a Key Field Changes
  • Using a Nontrivial Conditional Formatting Formula
  • Rearranging Data (Revisiting a Technique from Excel Outside the Box)
  • Truncating Text and Showing an Ellipsis (...) After 47 Characters
  • Copying Cells Without the Blank Rows
  • Alternating Conditional Formatting
  • Using Relative Names
  • Merging Across
  • Using Wildcards in Replace Formula
  • Array Formula Topics
  • Finding Prime Numbers
  • Easily Clearing an Array-Entered Block of Cells
  • Determining Whether a Cell Contains a Word from a List of Words
  • Using Variable Ranges for Unique Counts
  • Extracting Numbers from Text
  • VBA Topics
  • Partially Matching Words with a User-Defined Function
  • Setting Up Many Check Boxes on a Worksheet
  • Narrowing Down What Caused a Crash
  • Filling a List Box with Months
  • Filtering by Data in a Text Box
  • Creating a Summary Chart with a Single Click
  • Copying Modules or User Forms from One Project to Another
  • Using the Locals Window in VBA
  • Miscellaneous Topics
  • Creating a Gantt Chart from Many Sources (on Steroids!)
  • Protecting Tables of Data
  • Did You Know…? (a potpourri of miscellaneous ideas)
  • Index

Where to Buy

MrExcel Bookstore

eBook from MrExcel.

MrExcel Bookstore

Print book from MrExcel.


Print book from Amazon.

Other Editions

Excel Outside the Box

April 2012

Think that you know everything that there is to know about Microsoft Excel? Guess again. If you're ready for the next level of Excel, then "Excel Outside the Box" is for you! 'Outside the Box' is an in-depth look at 54 amazing techniques from Excel MVP Bob Umlas.

Related Products

Excel Gurus Gone Wild

April 2009

Do the IMPOSSIBLE with Microsoft Excel! Do not try any tricks in this book without first consulting a physician... Most tricks will make your head spin!