Tag: #excel
Writing on GPUs, LLMs, MLOps, Kubernetes — and mindset · 5 posts
Excel Shortcuts That Actually Save Time — Understand the Rule, Don't Memorize the List
Instead of listing 200 Excel shortcuts, this post groups them by the task you're actually doing. Once you understand why the arrow-key family always knows exactly where the data ends, or what order the absolute-reference
2026-08-02 · 16 min read #excel#shortcuts#productivity#office#keyboardMastering Excel Modern Functions in 2026 — From Dynamic Arrays to GROUPBY
A practical guide to the latest Microsoft 365 Excel functions, organized around real-world examples. From dynamic arrays and the spill concept to XLOOKUP, FILTER, LET, LAMBDA, GROUPBY/PIVOTBY, and regular expression func
2026-06-15 · 12 min read #excel#productivity#dynamic-array#lambda#groupbyAutomating Data Cleaning with Power Query — Reports That Refresh in One Click
A step-by-step guide to automating data import and transformation with Power Query. Covers combining folders, merging and appending queries, parameters, a taste of the M language, refresh automation and its limits, plus
2026-06-15 · 9 min read #excel#productivity#power-query#etl#data-cleaningMaster Excel Shortcuts — Leave the Mouse Behind
A category-by-category guide to the shortcuts that determine your Excel speed. With both Windows and Mac keys listed, plus practical workflow combos, mistake-reducing habits, and a practice routine, you can cut your reli
2026-06-15 · 12 min read #excel#productivity#shortcuts#keyboard#officeExcel Shortcuts & Productivity Complete Guide: 50+ Essential Tips for Power Users
Master Excel with 50+ essential shortcuts for Windows and Mac, learn pivot tables, VLOOKUP/XLOOKUP, conditional formatting, and print area setup.
2026-03-17 · 19 min read #excel#productivity#shortcuts#office#tips