TRIM Function in Excel: Remove Extra Spaces
TRIM removes leading and trailing spaces and reduces multiple spaces between words to one. Essential after copying data from websites and ERPs.
Read article →Author Archives: Atul Vij
HLOOKUP Function in Excel: Look Up Across the Top Row of a Table
HLOOKUP Function in Excel: Look Up Across the Top Row of a Table
HLOOKUP is VLOOKUP turned sideways: it searches the top row and returns a value from a row below.
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 →XLOOKUP Function in Excel: The Modern Lookup That Replaces VLOOKUP
XLOOKUP Function in Excel: The Modern Lookup That Replaces VLOOKUP
XLOOKUP finds a value in one range and returns the matching item from another. It looks in any direction, defaults to exact match, and…
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 →VBA Project: Generate PDF Invoices From Excel and Email Them Automatically
VBA Project: Generate PDF Invoices From Excel and Email Them Automatically
A complete VBA project: fill an invoice template from a data sheet, export each invoice to PDF with a proper file name, and email…
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 →SQL Window Functions: Running Totals, Rankings and Month-on-Month in One Query
SQL Window Functions: Running Totals, Rankings and Month-on-Month in One Query
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 →