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 →Format numbers and dates inside formulas with TEXT: Indian lakh/crore commas, day names, month names, leading zeros, percentages and joining numbers into sentences.
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…
Read article →Machine learning starts with a straight line. Fit a regression in Excel with SLOPE, INTERCEPT, RSQ, LINEST and FORECAST.LINEAR, and learn how to read…
Read article →SWITCH compares one value with a list and returns the matching result — cleaner than nested IFs for exact matches.
Read article →Why Excel stops at 1,048,576 rows and column XFD, why old Excel had 65,536 rows, why numbers lose digits after 15, why FAT32 files…
Read article →How to set up Busy for GST billing: company creation, masters, sale vouchers with CGST/SGST/IGST, and the reports small businesses use every month.
Read article →MINIFS returns the minimum of values where all conditions are true.
Read article →MAXIFS returns the maximum of values where all conditions are met; MINIFS returns the minimum.
Read article →TEXTJOIN joins a range of text with a delimiter and can ignore empty cells.
Read article →A 25-line Python script that moves files into Year/Month folders based on their modified date, with a dry-run mode so you can check before…
Read article →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 →
