ISLOGICAL Function in Excel: Is It TRUE or FALSE?
ISLOGICAL checks whether a value is a real TRUE/FALSE. Imports often bring the text "TRUE", which looks identical but is not.
Read article →FALSE Function in Excel: The Logical Value FALSE
FALSE Function in Excel: The Logical Value FALSE
FALSE() returns the logical value FALSE, most often seen as the exact-match argument in VLOOKUP.
Read article →PY Function in Excel: Run Python Inside Excel
PY Function in Excel: Run Python Inside Excel
PY (Python in Excel, 2023) runs Python code (pandas, matplotlib and more) in Microsoft's cloud and returns the result to a cell. You don't…
Read article →CUBESETCOUNT Function in Excel: Number of Items in a Set
CUBESETCOUNT Function in Excel: Number of Items in a Set
CUBESETCOUNT counts the items in a set made with CUBESET. Cube functions read from a Power Pivot Data Model (connection "ThisWorkbookDataModel") or an Analysis…
Read article →PERCENTRANK Function in Excel: Percentile Rank (Older Name)
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 →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 →