xlsdocs blog

Writing about Excel,
data, and the web.

Deep dives, tutorials, and practical guides from the team building xlsdocs — covering Excel functions, Power BI, web performance, and developer tools.

48 Articles

12 Topics

2026 Est.

2026 7 articles

Deep Dive June 24, 2026

The State of Web Performance in 2026

Core Web Vitals evolved. HTTP/3 became the baseline. And yet, most sites are slower than ever. Here's what actually matters this year — INP, streaming SSR, and the tools worth integrating into your workflow.

Featured — June 2026

Python Jul 04

Python in Excel: The Future Is Here

Microsoft’s most powerful Excel feature ever. Run real Python code directly in your spreadsheets — no external tools, no exports, no hassle.

10 min read

Excel Jul 04

Mastering XLOOKUP in Excel

The function that finally killed VLOOKUP. Faster, more flexible, and now the default lookup tool in modern Excel. Here's everything you need to know.

9 min read

Power BI Jun 12

Building a Workforce Hours Report with Dayforce Data

Star schema design, DAX measures for absence tracking, and preventing double-counting with addon pay codes.

11 min read

Web Dev Jun 5

Single-File HTML: The Underrated Deployment Strategy

Why self-contained HTML files are a surprisingly powerful pattern for docs, tools, and internal dashboards.

5 min read

Tutorial May 29

Power Query M: The Parts Nobody Teaches

Custom functions, error handling, and the query folding tricks that make real-world ETL pipelines maintainable.

9 min read

Excel May 20

LAMBDA Deep Dive: Recursive Functions Without VBA

How to use LAMBDA to build recursive, self-referencing formulas — and where the 1024-call limit actually bites you.

7 min read

Performance May 14

GitHub Actions for FTP Deployment: The Reliable Setup

A production-ready workflow for deploying static sites to shared hosting via FTP — with secrets, caching, and rollback.

4 min read

Performance Apr 30

Lighthouse CI: Fail the Build on Regressions

A production-ready GitHub Actions workflow that diffs performance scores against your production baseline on every PR.

5 min read

Excel Apr 14

Dynamic Arrays Changed Everything — Here's the Proof

SORT, UNIQUE, FILTER, SEQUENCE: why the dynamic array engine is the most important Excel shift in a decade.

6 min read

2027 6 articles

Featured — Jan 2027

Excel January 8, 2027

Python in Excel: One Year Later

Microsoft shipped Python in Excel to general availability in late 2026. We tested it against Power Query for real-world data workflows. Here's the honest verdict on when to use which, and when to use neither.

Writing about Excel,data, and the web.

The State of Web Performance in 2026

Python in Excel: One Year Later

Writing about Excel,
data, and the web.