Turn misleading averages into actionable insights using standard deviation, volatility ratios, and median-based calculations.
Tony Phillips
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.
Skip tables when you need spilled results, presentation-ready layouts, one-off modeling logic, or stable protected data-entry templates.
Avoid Excel friction and save time by customizing the interface, shortcuts, highlights, and formula editing.
Replace legacy formulas with MAP, BYROW, BYCOL, SCAN, and REDUCE to build secure, scalable, and automated spreadsheets.
Build resilient, scalable workbooks by separating raw data, complex logic, and professional presentation into three distinct layers.
Excel's Total Row uses smart SUBTOTAL logic to ignore hidden data, adapt to filters, flag text errors,...
You can finally stop uploading every single spreadsheet to OneDrive just to use modern features.