Format Cells with VBA: Fonts, Colours, Borders and Number Formats
Format Excel cells from VBA: fonts, fill colours, borders, number and date formats, alignment and conditional formatting — with copy-paste examples.
Read article →Author Archives: Atul Vij
Working with Ranges in Excel VBA: Cells, Offset, Resize and More
Working with Ranges in Excel VBA: Cells, Offset, Resize and More
Everything you need to read and write cells in Excel VBA: Range vs Cells, Offset, Resize, CurrentRegion, rows and columns — with practical examples.
Read article →Excel VBA Variables and Data Types: A Practical Guide
Excel VBA Variables and Data Types: A Practical Guide
Learn how to declare variables in Excel VBA, choose the right data type, use Option Explicit, and avoid the mistakes that cause type mismatch…
Read article →Conditional Formatting with Formulas: 10 Rules Worth Knowing
Conditional Formatting with Formulas: 10 Rules Worth Knowing
Ten formula-based conditional formatting rules for real reports: highlight whole rows, overdue dates, duplicates, top N, weekends, missing values and differences between lists.
Read article →Why Learn Rust? Your First Rust Program, Explained for Beginners
Why Learn Rust? Your First Rust Program, Explained for Beginners
What makes Rust different — speed without crashes — and a gentle walk through your first program: variables, ownership, and a tiny CSV-style summary.
Read article →SUMPRODUCT: The Excel Formula That Does (Almost) Everything
SUMPRODUCT: The Excel Formula That Does (Almost) Everything
SUMPRODUCT multiplies arrays and adds the result — which makes it a multi-condition counter, a weighted average, a case-sensitive lookup and more, in every…
Read article →SAP ERP Modules
SAP ERP Modules
SAP ERP Modules SAP Modules can be categorized into Functional ModulesTechnical Modules Below is a list of key SAP Modules. SAP FI Module - FI…
Read article →SAP as Business Suite
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 →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 →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 →