PERCENTRANK Function in Excel: Percentile Rank (Older Name)
PERCENTRANK returns the rank of a value as a percentage of the data. It is a compatibility function: Excel keeps it so workbooks from…
Read article →Atul Vij
Why Does Excel Have Exactly 1,048,576 Rows? The Logic Behind Software Limits
Why Does Excel Have Exactly 1,048,576 Rows? The Logic Behind Software Limits
Why Excel stops at 1,048,576 rows and column XFD, why old Excel had 65,536 rows, why numbers lose digits after 15, why FAT32 files…
Read article →Why Does Your Phone Battery Die Faster in the Cold?
Why Does Your Phone Battery Die Faster in the Cold?
Lithium-ion batteries slow down in the cold: the chemistry inside gets sluggish, voltage drops and the phone shuts down early. Why it happens and…
Read article →Take a Scrolling (Full-Page) Screenshot on Windows and Android
Take a Scrolling (Full-Page) Screenshot on Windows and Android
Capture a whole web page or long chat in one image: Edge web capture and browser developer tools on Windows, and "Capture more" on…
Read article →Office Scripts Lesson 5: Run Scripts From Power Automate
Office Scripts Lesson 5: Run Scripts From Power Automate
Schedule Office Scripts with Power Automate: Run script action, passing parameters in and returning results, daily refresh of a report file, and emailing the…
Read article →Office Scripts Advanced: Tables, Charts and Automation
Office Scripts Advanced: Tables, Charts and Automation
Clean exports with Office Scripts: trim and case text, convert text numbers, remove blank rows, number formats, conditional formatting and freeze panes.
Read article →PERCENTRANK.INC Function in Excel: Where a Value Stands, as a %
PERCENTRANK.INC Function in Excel: Where a Value Stands, as a %
PERCENTRANK.INC tells you what share of the data is below a value — “this store beats 82% of stores”.
Read article →Office Scripts Basics: Automate Excel in the Browser
Office Scripts Basics: Automate Excel in the Browser
Find the used range, add tables, read and add table rows, sort and filter tables, and total columns — the core of most Office…
Read article →Why Do We Have Leap Years? (And Why 1900 Was Not One)
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 →