Bubble Pies: Multi-Dimensional Data in One Chart
Overlay mini pie charts on a bubble chart to show market positioning, scale, and sector composition.
Building a Marimekko Chart in Excel
Variable-width stacked bar chart for market share and product mix analysis. 7 combined chart objects create a consulting-grade Mekko visualisation.
Column Chart with Percentage Change Arrows
Year-over-year variance indicators with colour-coded arrows and percentage labels. Uses invisible series and error bars for the bridge connectors.
Simple and Stacked Waffle Charts in Excel
10×10 grid percentage visualisation using SEQUENCE and conditional formatting. Includes single-value and multi-category stacked variants.
Horizontal RainCloud Charts in Excel
Distribution visualisation combining density curves, box plots, and scatter plots. 34 chart objects create 1-cloud and 3-cloud comparison layouts.
Vertical RainCloud Charts in Excel
Vertical orientation with 27 chart objects. 1-cloud and 3-cloud layouts with density, box plot, and jittered scatter layers.
Point & Figure Chart with Bollinger Bands
Classic technical analysis chart built from MSFT stock data with Bollinger Band overlays. X/O columns with formula-driven bin width and switch detection.
Christmas Tree Light Generator in Excel
A festive creation with randomised Unicode ornaments, conditional formatting lights, and seasonal greetings. Press F9 to regenerate the decorations!
Matrix Manipulation: 8 Formula Approaches to 2D Aggregation
Compare MMULT, SUMIFS, GROUPBY, and LAMBDA variants for aggregating categorised data into a summary matrix. Interactive demo lets you switch between all 8 methods.
Solving the Subset Sum Problem with Excel Formulas
Find all combinations of numbers that sum to a target using SEQUENCE, BASE, MMULT, and FILTER. Three approaches from step-by-step to a single formula.
Dynamic Hyperlinks That Never Break
Formula-driven hyperlinks using HYPERLINK(), INDIRECT(), and CELL() that auto-update when sheets are renamed.
fn_Sum_by_Color: Sum Cells by Fill Color
Sum cells whose background color matches a reference cell. Ideal for color-coded financial models.
fn_Range_Has_Notes: Detect Cell Comments
Returns a TRUE/FALSE array indicating which cells have legacy comments (Notes) attached.
fn_Extract_Comments_Thread: Export Threaded Comments
Extract all threaded comments and replies into a structured table with Cell, Author, Date, and Text columns.
fn_NMATCH: Find the Nth Occurrence
Like MATCH but finds the Nth occurrence of a value. Supports array inputs for lookup value and instance number.
fn_ROTATE: Rotate a 2D Range 90 Degrees
Rotate any 2D range clockwise with an optional count for 180 or 270 degree rotations.
fn_Does_File_Path_Exist: Check File Paths
Returns TRUE/FALSE for each cell, checking whether the file path actually exists on disk.
fn_Is_Hyperlink: Detect Hyperlinks in Cells
Returns TRUE/FALSE indicating whether each cell contains a hyperlink.
Audit & Formula Tracing Tools
Enhanced Trace Dependents/Precedents with safety checks for large networks, plus a quick Toggle R1C1 reference style switch.
Clipboard Power Tools
Copy cell addresses, formulas as text, and select ranges from clipboard text using the Windows API.
Workbook Error Scanner
Scan every sheet for #REF!, #VALUE!, #N/A and all other errors. Produces a clickable hyperlinked report.
Data Validation Inspector
List all data validation rules across a workbook, and find cells that violate their own validation constraints.
Workbook Documentation Suite
Document named ranges, embedded objects, unique formulas (R1C1), and chart series across the entire workbook.
Power Query Manager
Extract, export, import, and remove Power Query definitions with VBA for version control and migration.
Text Case Transformations
Six in-place text case macros: UPPER, lower, Proper, Title Case (with article rules), tOGGLE, and Sentence case.
Auto-Grouping Rows by Title Hierarchy
Automatically create outline groups from 2 to 8 levels based on which column contains the row title. Plus Collapse/Expand All.
Dynamic Array Spill Resolver
Detect and fix #SPILL! errors across the workbook by automatically inserting rows and columns for dynamic arrays.
Workbook Statistics Report
Generate a comprehensive stats report: used ranges, formula density, dynamic array metrics, unique formulae, and sheet dependencies.
Auto Save & Version Control
Timed auto-save and automatic version numbering with initials prefix. Lightweight version control for Excel.
VBA Code Inspector
List every Sub, Function, and Property across all open workbooks. Plus a UDF to retrieve source code from a cell formula.
Mass Naming & Hyperlink Tools
Bulk-create numbered named ranges, convert cell references to names, and add hyperlinks to formula cells.
Smart Fill in All Four Directions
Fill blank cells from the nearest value in any direction: down, up, right, or left. Perfect for cleaning imported data.
Formula Calculation Timer
Measure single-cell recalculation time or full workbook rebuild time to four decimal places for performance tuning.
Fill Blank Cells to the Left with VBA
A simple VBA macro to fill all blank cells in selected rows with the value from the nearest non-blank cell to the right.
Automating Sheet Setup in Excel
Reset all visible, hidden, and very hidden sheets to cell A1 with 100% zoom for a clean workbook presentation.
Removing Same-Sheet References
Clean up redundant same-sheet references in your formulas automatically. Handles both quoted and unquoted sheet names.