Build more efficient spreadsheets by using the dollar sign to lock specific rows, columns, or permanent addresses...
Tony Phillips
Copilot is a sophisticated stopgap for a design system that has finally run out of room to...
Instantly jump between sheets and datasets using secret menus, name boxes, custom dashboards, and powerful double-vision hacks.
Use dynamic arrays and tables for fast, scalable cascading drop-down lists in modern Excel.
Prevent broken formulas using tables, validation rules, separate worksheets, named variables, and the power of LAMBDA.
From Word 2000's clean interface to today's AI-powered Copilot, the famous writing software has grown increasingly cluttered.
Turn misleading averages into actionable insights using standard deviation, volatility ratios, and median-based calculations.
Master non-destructive edits, troubleshoot errors, and document your logic to build resilient, automated Power Query workflows.
Create a self-sorting bar chart with dual labels to replace confusing and unreadable Excel pie charts.