Excel articles
Blog
Stories, insights, and updates - written from real Excel engagements.
Latest articles
Practical guides and insights on Excel, automation, dashboards and Power Query.
Showing 1–9 of 66 articles
NewExcel IMPORTCSV and IMPORTTEXT: Load a File With One Formula
IMPORTCSV and IMPORTTEXT load a CSV or text file into a dynamic array with one formula - syntax, examples and why they are not ready for shared reports yet.
Excel GROUPBY and PIVOTBY: Pivot Tables as Formulas
GROUPBY and PIVOTBY build a summary table with one formula that recalculates on its own - syntax, five finance examples and what to check before replacing a PivotTable.
Excel TRIMRANGE and Trim References (A:.A) Explained
TRIMRANGE and the trim-reference operators cut blank rows off range edges - syntax, examples and the mismatched-size trap.
Excel REGEX Functions: REGEXTEST, REGEXEXTRACT, REGEXREPLACE
Excel's three regex functions with worked examples - validate a GSTIN, extract emails, strip phone numbers - and the compatibility check before sharing.
Excel COPILOT Function Removed: Fix the #NAME? Errors
Microsoft removed the COPILOT worksheet function on 14 September 2026. How to find affected cells, keep the cached results and move to the Copilot pane.
Excel Error Handling with IFERROR
Excel error handling with IFERROR and IFNA - the modern pattern that turns #N/A #VALUE! #REF! and #DIV/0! into clean messages.
Excel Protect Sheet
Excel Protect Sheet and Protect Workbook - the patterns for locking formulas allowing user input and securing the workbook structure.
Excel VBA vs Power Query
Excel VBA vs Power Query - when to use each the limits of VBA and the modern pattern that combines both. The senior-built automation stack.
Excel Templates vs Workbooks
Excel templates vs workbooks - when to use each the .xltx file format the .xlsx runtime and the patterns for shippable Excel deliverables.
Related guides
Reference pages worth bookmarking
Excel Glossary A–Z
Plain-English definitions for every modern Excel function.
Read the guidePower Query vs VBA
Decision matrix for which tool to use - and when to combine them.
Read the guideHow to Choose a Consultant
12-question checklist with red flags and green flags.
Read the guideFree Excel Templates
8 self-serve browser tools + downloadable PDFs. No sign-up.
Read the guideNeed a hand with your workbook?
Skip the article. Just send us the workbook.
Fixed-scope, fixed-price, senior-led Excel engagements. Reply within one working day. NDA before any file is exchanged.
Reading on your phone?
Direct channels
Have this
built for you.
- Patterns live
- 25+
- Price in writing
- Fixed
- Typical build
- 2-3w
- 1Send the pain
- 2We diagnose
- 3Ship the fix