DATEDIF Function in Excel: Age and Tenure in Years, Months, Days
DATEDIF is a hidden function (not in the autocomplete list) that returns the difference between two dates in completed years, months or days.
Read article →FACT Function in Excel: Factorial
FACT Function in Excel: Factorial
FACT returns n! (1 × 2 × … × n). It grows absurdly fast: FACT(20) is already about 2.4 quintillion.
Read article →JSON Explained Simply (for Excel People)
JSON Explained Simply (for Excel People)
What JSON is, how to read it, how it maps to rows and columns, and how to load JSON into Excel with Power Query…
Read article →TIME Function in Excel: Build a Time From Hours, Minutes, Seconds
TIME Function in Excel: Build a Time From Hours, Minutes, Seconds
TIME creates a time value. Excel stores time as a fraction of a day: 12:00 is 0.5, 6:00 is 0.25.
Read article →PERMUT Function in Excel: Arrangements Where Order Matters
PERMUT Function in Excel: Arrangements Where Order Matters
PERMUT counts ordered arrangements — podium positions, codes without repeated digits.
Read article →EDATE Function in Excel: Add or Subtract Months From a Date
EDATE Function in Excel: Add or Subtract Months From a Date
EDATE returns the same day a number of months before or after a date — ideal for due dates, renewals and EMIs.
Read article →EOMONTH Function in Excel: Last Day of a Month
EOMONTH Function in Excel: Last Day of a Month
EOMONTH returns the last day of the month, a number of months away from a date.
Read article →YEAR Function in Excel: Year From a Date
YEAR Function in Excel: Year From a Date
YEAR returns the four-digit year of a date. MONTH and DAY work the same way for the month (1–12) and day (1–31).
Read article →NOW Function in Excel: Current Date and Time
NOW Function in Excel: Current Date and Time
NOW returns the current date and time and updates every time the sheet recalculates. For a timestamp that stays fixed, press Ctrl+; then Space…
Read article →PowerPoint Slide Master: Fix Every Slide in One Place
PowerPoint Slide Master: Fix Every Slide in One Place
Stop formatting slides one by one. Use PowerPoint’s Slide Master to control fonts, colours, logos and layouts for the whole deck — and rescue…
Read article →COMBIN Function in Excel: How Many Groups Are Possible
COMBIN Function in Excel: How Many Groups Are Possible
COMBIN counts the ways to choose items when order doesn’t matter — teams from a class, lottery tickets, product bundles.
Read article →MONTH Function in Excel: Month Number From a Date
MONTH Function in Excel: Month Number From a Date
MONTH returns 1 for January through 12 for December — the building block for monthly reports and fiscal-period logic.
Read article →