Why Do We Have Leap Years? (And Why 1900 Was Not One)
A year is about 365.2422 days, not 365. How leap years fix the drift, why century years are usually skipped, and how this affects…
Read article →Office Scripts Lesson 2: TypeScript Basics for Excel Users
Office Scripts Lesson 2: TypeScript Basics for Excel Users
The TypeScript you need for Office Scripts: let and const, types, if, for loops, arrays from getValues(), functions and console.log for debugging.
Read article →Office Scripts Lesson 1: What Office Scripts Are and the Action Recorder
Office Scripts Lesson 1: What Office Scripts Are and the Action Recorder
Meet Office Scripts: where the Automate tab is, licences, recording actions, reading the generated TypeScript, and how Office Scripts differ from VBA.
Read article →AVERAGEIF Function in Excel: Average With One Condition
AVERAGEIF Function in Excel: Average With One Condition
StatisticalLevel: IntermediateAvailable in: Excel 2007+AVERAGEIF averages values that meet one condition — often used to ignore.
Read article →VBA: Loop Through Every File in a Folder (and Combine Them)
VBA: Loop Through Every File in a Folder (and Combine Them)
Process every file in a folder with VBA: Dir loops, picking a folder with FileDialog, opening workbooks quietly, copying data into a master sheet…
Read article →QUARTILE.EXC Function in Excel: Quartiles Excluding the Ends
QUARTILE.EXC Function in Excel: Quartiles Excluding the Ends
QUARTILE.EXC matches the method many statistics textbooks and tools use; results differ slightly from QUARTILE.INC on small data.
Read article →MAKEARRAY Function in Excel: Generate a Grid From Row and Column Numbers
MAKEARRAY Function in Excel: Generate a Grid From Row and Column Numbers
MAKEARRAY builds an array of a given size, computing each cell from its row and column number.
Read article →BYCOL Function in Excel: Apply a Calculation to Each Column
BYCOL Function in Excel: Apply a Calculation to Each Column
LogicalLevel: ExpertAvailable in: Excel 365 / 2021+BYCOL is BYROW turned sideways: one result per column.Syntax=BYCOL(array, LAMBDA(col.
Read article →Windows 11 Clipboard History and Snipping Tool: 9 Tricks That Save Time
Windows 11 Clipboard History and Snipping Tool: 9 Tricks That Save Time
Win+V clipboard history, pinned snippets, text extraction from screenshots, delayed snips and screen recording — nine built-in Windows 11 tricks most people never use.
Read article →PERCENTRANK.EXC Function in Excel: Percentile Position, Excluding Ends
PERCENTRANK.EXC Function in Excel: Percentile Position, Excluding Ends
PERCENTRANK.EXC works like PERCENTRANK.INC, but never returns exactly 0 or 1 — matching the EXC family of percentile functions.
Read article →FREQUENCY Function in Excel: Count Values Into Bins
FREQUENCY Function in Excel: Count Values Into Bins
FREQUENCY counts how many values fall into each bin — the data behind a histogram.
Read article →RANK.EQ Function in Excel: Rank a Number in a List
RANK.EQ Function in Excel: Rank a Number in a List
StatisticalLevel: IntermediateAvailable in: Excel 2010+RANK.EQ returns the position of a number in a list. Ties share the same rank.Syntax=RANK.EQ(number.
Read article →