Sometimes you need to pull together something that is both satisfying and of good quality, in little time, and with what is on hand. This is certainly true in cooking. You may know how to use every ingredient out there and each implement in your kitchen, but you need to balance the immediate objective with your resources and constraints (e.g. time, what you have to work with, preferences and expectations of those who will be consuming what you prepare). This is also true in other endeavors, too. Take what you do for a living, for instance. Continue reading XLQtip: OFFSET with List, Combo, and Check Boxes
Tag: eQUEST
XLQtip: Treemaps for Hierarchical Facility Information
Treemaps have been around for some time and became available as a chart template beginning with Excel 2016. A Treemap is a diagram that uses proportionately-sized, nested rectangles to represent hierarchical data. To me, at first, they did not resemble either trees or maps and my interest faded. The anatomy of a Treemap is explained quickly at datavizcatalogue.com.
Below are a few examples of Treemapping for use in this thing of ours. Continue reading XLQtip: Treemaps for Hierarchical Facility Information
XLQtip: Find External Links
You ever get a feeling like your spreadsheets are stepping out on you? You know what I’m talking about. Seems like your workbook may be hanging on to some old links; connections that may have onetime been meaningful. But now, certainly not important to what you’re trying to build together.
A little suspicion is good, whether you are a dutiful workbook auditor, committed peer reviewer, or just QC’g your own work. You need to know with whom your spreadsheet is socializing. Continue reading XLQtip: Find External Links