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 totals never double-count.
Read article →SUBTOTAL calculates a sum, count, average and more while ignoring rows hidden by a filter. It also ignores other SUBTOTALs in the range, so totals never double-count.
Read article →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 top-N per group.
Read article →SUMPRODUCT multiplies ranges row by row and adds the products. Because it handles arrays natively, it doubles as a flexible conditional sum and counter in every version.
Read article →DAY returns 1–31 from a date. Pair it with YEAR and MONTH to rebuild or test dates.
Read article →SUMIFS adds values where all conditions are true — the backbone of formula-based reports.
Read article →InformationLevel: IntermediateAvailable in: Excel 2013+SHEET returns the position number of a sheet.Syntax=SHEET([value])ArgumentWhat it meansvalueA.
Read article →ISOWEEKNUM returns the ISO 8601 week (weeks start on Monday; week 1 holds the first Thursday). Use it when European teams or SAP reports say “week 1”, because WEEKNUM can disagree around New Year.
Read article →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 →What containers are, why “works on my machine” disappears, and your first Docker commands — run a database, a Jupyter notebook and your own Python script in a container.
Read article →DEC2HEX converts numbers to hex — the notation behind web colours and memory addresses.
Read article →EngineeringLevel: IntermediateAvailable in: Excel 2007+BIN2DEC reads binary text (up to 10 digits) and returns the.
Read article →DEC2BIN converts a number to binary text. Good for teaching, flags and subnet masks, but it only handles −512 to 511.
Read article →