SAP – Systems Applications and Products
What is SAP ERP? SAP stands for Systems Applications and Products in Data Processing. It is ERP (Enterprise Resource Planning) software as well as the…
Read article →Author Archives: Atul Vij
Group Customers Automatically with K-Means in Python (From an Excel File)
Group Customers Automatically with K-Means in Python (From an Excel File)
Use k-means clustering to split customers into segments by orders, spend and recency — reading from and writing back to Excel with pandas and…
Read article →XLOOKUP with Two (or More) Criteria — Plus the INDEX-MATCH Version
XLOOKUP with Two (or More) Criteria — Plus the INDEX-MATCH Version
Look up a value using two conditions — product AND region, or employee AND month — with XLOOKUP, INDEX-MATCH, or a helper column. With…
Read article →Build a Dynamic Excel Chart That Changes with a Dropdown
Build a Dynamic Excel Chart That Changes with a Dropdown
Create one chart that switches between regions, products or years from a dropdown list — using Data Validation, XLOOKUP or INDEX-MATCH, and a small…
Read article →SQL from Zero: A Complete Beginner’s Guide (with Practice)
SQL from Zero: A Complete Beginner’s Guide (with Practice)
Learn SQL from the very beginning: tables, SELECT, WHERE, ORDER BY, aggregates, GROUP BY, JOINs, NULLs, subqueries, CTEs, window functions and changing data —…
Read article →Protect Excel Sheets and Workbooks the Right Way
Protect Excel Sheets and Workbooks the Right Way
Lock formulas while letting people type in input cells, protect the workbook structure, and understand what Excel protection does — and does not —…
Read article →Run-time Error 1004 in Excel VBA: 7 Common Causes and How to Fix Them
Run-time Error 1004 in Excel VBA: 7 Common Causes and How to Fix Them
Run-time error 1004 is Excel VBA’s catch-all error. Here are the 7 causes I see most often — with the exact fix for each.
Read article →XLOOKUP vs VLOOKUP vs INDEX-MATCH: Which One Should You Use?
XLOOKUP vs VLOOKUP vs INDEX-MATCH: Which One Should You Use?
A practical comparison of VLOOKUP, XLOOKUP and INDEX-MATCH in Excel — when each one works, when it breaks, and which to use in 2025.
Read article →JavaScript for Excel Users: Arrays, map, filter and reduce Explained
JavaScript for Excel Users: Arrays, map, filter and reduce Explained
Learn JavaScript’s most useful array tools — map, filter, reduce, sort — by comparing each one with an Excel formula you already know. Run…
Read article →SQL for Excel Users: 10 Queries That Replace Everyday Excel Work
SQL for Excel Users: 10 Queries That Replace Everyday Excel Work
Learn SQL through tasks you already do in Excel — filters, sorting, pivot tables, VLOOKUP and remove duplicates — with 10 queries you can…
Read article →Return ALL Matches in One Cell: TEXTJOIN + FILTER (the VLOOKUP Upgrade)
Return ALL Matches in One Cell: TEXTJOIN + FILTER (the VLOOKUP Upgrade)
VLOOKUP returns only the first match. Combine TEXTJOIN, UNIQUE and FILTER to list every matching value in one cell — plus a version for…
Read article →Python for Excel Users: Read, Clean and Summarise a Spreadsheet with pandas
Python for Excel Users: Read, Clean and Summarise a Spreadsheet with pandas
A gentle first step from Excel to Python: load a spreadsheet with pandas, clean it, build a pivot table and save the result —…
Read article →