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 →Unpivot Monthly Columns into a Clean Table with Power Query
Unpivot Monthly Columns into a Clean Table with Power Query
Turn a wide report with Jan–Dec columns into a tidy Month/Value table using Power Query’s Unpivot — so pivot tables, charts and SUMIFS finally…
Read article →Outlook Calendar Tricks for Busy Weeks
Outlook Calendar Tricks for Busy Weeks
Practical Outlook calendar features: Scheduling Assistant, shorter meetings by default, a second time zone, focus blocks, propose new time, sharing and quick keyboard shortcuts.
Read article →Excel TEXT Function: 20 Format Codes You Will Actually Use
Excel TEXT Function: 20 Format Codes You Will Actually Use
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 →Docker for Beginners: Run Any App Without Installing It
Docker for Beginners: Run Any App Without Installing It
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 →Linear Regression in Excel with LINEST, SLOPE and FORECAST — No Add-ins
Linear Regression in Excel with LINEST, SLOPE and FORECAST — No Add-ins
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 →