SECOND Function in Excel: Second From a Time
SECOND returns 0–59. Mostly used to strip seconds from machine timestamps.
Read article →MINUTE Function in Excel: Minute From a Time
HOUR Function in Excel: Hour From a Time
HOUR Function in Excel: Hour From a Time
HOUR returns 0–23 from a time or date-time. The quickest way to group call-centre or sales data by hour of day.
Read article →Google Sheets IMPORTRANGE: Pull Data From Another Sheet (and Filter It)
Google Sheets IMPORTRANGE: Pull Data From Another Sheet (and Filter It)
Link Google Sheets files with IMPORTRANGE, grant access once, and combine it with QUERY to pull only the rows and columns you need.
Read article →DOLLAR Function in Excel: Number as Currency Text
DOLLAR Function in Excel: Number as Currency Text
DOLLAR formats a number as currency text using your computer’s currency symbol. The name is historic — on an Indian-locale PC it shows ₹.
Read article →FIXED Function in Excel: Round and Format as Text
FIXED Function in Excel: Round and Format as Text
FIXED rounds a number and returns it as text with or without thousands separators — good for sentences built from numbers.
Read article →Google Sheets QUERY Function for Excel Users
Google Sheets QUERY Function for Excel Users
Google Sheets’ QUERY function lets you filter, group and sort with SQL-like syntax in one formula. Learn it with examples mapped to Excel features…
Read article →DMIN Function in Excel: Smallest Value With a Criteria Table
DMIN Function in Excel: Smallest Value With a Criteria Table
DMIN is DMAX’s twin: the smallest value among matching rows.
Read article →DMAX Function in Excel: Largest Value With a Criteria Table
DMAX Function in Excel: Largest Value With a Criteria Table
DMAX returns the largest value in a column among matching rows. It worked in every Excel version long before MAXIFS existed.
Read article →Unpivot Monthly Columns into a Clean Table with Power Query
Unpivot Monthly Columns into a Clean Table with Power Query
Turn a wide report with Jan–Dec columns into a tidy Month/Value table using Power Query’s Unpivot — so pivot tables, charts and SUMIFS finally…
Read article →SQL Window Functions: Running Totals, Rankings and Month-on-Month in One Query
SQL Window Functions: Running Totals, Rankings and Month-on-Month in One Query
A practical guide to SQL window functions: OVER and PARTITION BY, ROW_NUMBER, RANK and DENSE_RANK, running totals, moving averages, LAG/LEAD for month-on-month change, and…
Read article →DAY Function in Excel: Day of the Month
DAY Function in Excel: Day of the Month
DAY returns 1–31 from a date. Pair it with YEAR and MONTH to rebuild or test dates.
Read article →