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 →Author Archives: Atul Vij
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 →Decision Trees in Python: A Model You Can Actually Read
Decision Trees in Python: A Model You Can Actually Read
Train a decision tree classifier with scikit-learn, print its rules as plain if/else text, measure accuracy honestly with a test split, and avoid overfitting…
Read article →Which Automation Tool Should You Learn? VBA vs Python vs Power Automate vs SAP Scripting
Which Automation Tool Should You Learn? VBA vs Python vs Power Automate vs SAP Scripting
A practical guide to choosing between Excel VBA, Python, Power Automate and SAP GUI scripting for automating office work — based on the task,…
Read article →Outlook Rules and Quick Steps That Actually Clean Your Inbox
Outlook Rules and Quick Steps That Actually Clean Your Inbox
Set up Outlook rules, Quick Steps, search folders and a few smart habits so your inbox sorts itself — with real examples for reports,…
Read article →Google Sheets QUERY Function for Excel Users
Google Sheets QUERY Function for Excel Users
Google Sheets’ QUERY function lets you filter, group and sort with SQL-like syntax in one formula. Learn it with examples mapped to Excel features…
Read article →Linear Regression From Scratch in Python: How a Model Actually Learns
Linear Regression From Scratch in Python: How a Model Actually Learns
Code linear regression with gradient descent in plain NumPy, watch the model learn slope and intercept, then check it against NumPy and scikit-learn. The…
Read article →