SUMSQ Function in Excel: Sum of Squares
SUMSQ squares each value and adds them up — the building block of error measures such as RMSE.
Read article →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
AGGREGATE Function in Excel: SUBTOTAL That Can Ignore Errors
AGGREGATE Function in Excel: SUBTOTAL That Can Ignore Errors
AGGREGATE is like SUBTOTAL with 19 functions and extra options — most usefully, ignoring error values such as #N/A in the range.
Read article →SUBTOTAL Function in Excel: Totals That Respect Filters
SUBTOTAL Function in Excel: Totals That Respect Filters
SUBTOTAL calculates a sum, count, average and more while ignoring rows hidden by a filter. It also ignores other SUBTOTALs in the range, so…
Read article →SUMPRODUCT Function in Excel: Multiply Arrays and Add the Results
SUMPRODUCT Function in Excel: Multiply Arrays and Add the Results
SUMPRODUCT multiplies ranges row by row and adds the products. Because it handles arrays natively, it doubles as a flexible conditional sum and counter…
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 →SUMIFS Function in Excel: Sum With Multiple Conditions
SUMIFS Function in Excel: Sum With Multiple Conditions
SUMIFS adds values where all conditions are true — the backbone of formula-based reports.
Read article →SHEET Function in Excel: Which Sheet Number?
SHEET Function in Excel: Which Sheet Number?
InformationLevel: IntermediateAvailable in: Excel 2013+SHEET returns the position number of a sheet.Syntax=SHEET([value])ArgumentWhat it meansvalueA.
Read article →ISOWEEKNUM Function in Excel: ISO Week Number
ISOWEEKNUM Function in Excel: ISO Week Number
ISOWEEKNUM returns the ISO 8601 week (weeks start on Monday; week 1 holds the first Thursday). Use it when European teams or SAP reports…
Read article →CELL Function in Excel: Information About a Cell
CELL Function in Excel: Information About a Cell
CELL reports details such as address, column width, number format or file path. Its best-known use is getting the current sheet name.
Read article →DEC2HEX Function in Excel: Decimal to Hexadecimal
DEC2HEX Function in Excel: Decimal to Hexadecimal
DEC2HEX converts numbers to hex — the notation behind web colours and memory addresses.
Read article →BIN2DEC Function in Excel: Binary to Decimal
BIN2DEC Function in Excel: Binary to Decimal
EngineeringLevel: IntermediateAvailable in: Excel 2007+BIN2DEC reads binary text (up to 10 digits) and returns the.
Read article →DEC2BIN Function in Excel: Decimal to Binary
DEC2BIN Function in Excel: Decimal to Binary
DEC2BIN converts a number to binary text. Good for teaching, flags and subnet masks, but it only handles −512 to 511.
Read article →