Share Your Wi-Fi Password With a QR Code (No Typing)
Let guests join your Wi-Fi by scanning a QR code: share from Android settings, share between iPhones, print a QR code for the office…
Read article →NORM.S.INV Function in Excel: Z-Score for a Probability
NORM.S.INV Function in Excel: Z-Score for a Probability
NORM.S.INV returns the z-score for a cumulative probability — where the famous 1.96 comes from.
Read article →ISTEXT Function in Excel: Is It Text?
ISTEXT Function in Excel: Is It Text?
ISTEXT returns TRUE for text — the quickest way to find numbers or dates that were imported as text.
Read article →MODE Function in Excel: Most Frequent Value (Older Name)
MODE Function in Excel: Most Frequent Value (Older Name)
MODE returns the most frequent number. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but…
Read article →RANDARRAY Function in Excel: A Whole Grid of Random Numbers
RANDARRAY Function in Excel: A Whole Grid of Random Numbers
RANDARRAY returns an array of random numbers, optionally whole numbers between limits — instant test data.
Read article →VALUE Function in Excel: Convert Text to a Number
VALUE Function in Excel: Convert Text to a Number
VALUE turns text that looks like a number into a real number, so SUM and lookups work.
Read article →CONFIDENCE.NORM Function in Excel: Margin of Error
CONFIDENCE.NORM Function in Excel: Margin of Error
CONFIDENCE.NORM gives the ± margin around a sample mean for a chosen confidence level.
Read article →Extract Numbers From Text in Excel (Invoice Numbers, Amounts, Phone Numbers)
Extract Numbers From Text in Excel (Invoice Numbers, Amounts, Phone Numbers)
Pull the numbers out of messy text like "INV-2026-0045", "Paid Rs 12,500 via UPI" or "Call 98765 43210" with TEXTJOIN+MID+SEQUENCE, REGEXEXTRACT, TEXTAFTER and Flash…
Read article →MODE.MULT Function in Excel: All the Most Common Values
MODE.MULT Function in Excel: All the Most Common Values
MODE.MULT returns every value tied for most frequent, where MODE.SNGL returns only the first.
Read article →Power Automate: A Daily Email Summary of New SharePoint List Items
Power Automate: A Daily Email Summary of New SharePoint List Items
Build a scheduled flow that collects yesterday's new SharePoint list items, formats them as a table and emails one tidy summary each morning —…
Read article →NORM.INV Function in Excel: Value for a Given Probability
NORM.INV Function in Excel: Value for a Given Probability
NORM.INV is the reverse of NORM.DIST: give it a probability and it returns the value. Great for safety stock, and for simulations with RAND().
Read article →MODE.SNGL Function in Excel: The Most Frequent Number
MODE.SNGL Function in Excel: The Most Frequent Number
StatisticalLevel: IntermediateAvailable in: Excel 2010+MODE.SNGL returns the value that appears most often in a set of numbers.Syntax=MODE.SNGL(number1.
Read article →