SAP as Business Suite
SAP - Business Suite SAP Business Suite is collection of fully integrated applications such as SAP customer relationship management (CRM), SAP Enterprise Resource Planning…
Read article →Author Archives: Atul Vij
SAP – Systems Applications and Products
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 →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 →INDEX Function in Excel: Return the Value at a Row and Column Position
INDEX Function in Excel: Return the Value at a Row and Column Position
INDEX returns the value at a given row (and optional column) of a range. Combined with MATCH it is the most flexible lookup in…
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 →IFS Function in Excel: Several Conditions Without Nested IFs
IFS Function in Excel: Several Conditions Without Nested IFs
IFS checks conditions in order and returns the value for the first TRUE one — cleaner than nesting IF inside IF.
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 →VLOOKUP Function in Excel: Look Up a Value in the First Column of a Table
VLOOKUP Function in Excel: Look Up a Value in the First Column of a Table
VLOOKUP finds a value in the first column of a table and returns a value from another column in the same row.
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 →SORT Function in Excel: Sort Data With a Formula
SORT Function in Excel: Sort Data With a Formula
SORT returns a sorted copy of a range; the original stays untouched and the result re-sorts as data changes.
Read article →