Format Cells with VBA: Fonts, Colours, Borders and Number Formats
Excel VBA course lesson 3: format reports with VBA — fonts, fill colours with RGB, borders, alignment, number formats for Indian rupees and dates,…
Read article →BYROW Function in Excel: Apply a Calculation to Each Row
BYROW Function in Excel: Apply a Calculation to Each Row
BYROW runs a LAMBDA on each row of an array and returns one result per row — row totals, row maximums, row checks.
Read article →Working with Ranges in Excel VBA: Cells, Offset, Resize and More
Working with Ranges in Excel VBA: Cells, Offset, Resize and More
Excel VBA course lesson 2: refer to cells with Range and Cells, find the last row and column, move with Offset, grow selections with…
Read article →Excel VBA Variables and Data Types: A Practical Guide
Excel VBA Variables and Data Types: A Practical Guide
Excel VBA course lesson 1: open the VBA editor, write your first macro, declare variables with Dim, choose the right data type (Long, Double,…
Read article →ARRAYTOTEXT Function in Excel: A Whole Range as One Text
ARRAYTOTEXT Function in Excel: A Whole Range as One Text
ARRAYTOTEXT turns a range into a single text string. Strict mode gives array-constant syntax you can paste into another formula.
Read article →RANK.AVG Function in Excel: Rank That Shares Ties Fairly
RANK.AVG Function in Excel: Rank That Shares Ties Fairly
RANK.AVG works like RANK.EQ, but tied values get the average rank (2.5 and 2.5 instead of 2 and 2). Useful for statistics; confusing on…
Read article →Python Intermediate Lesson 10: Project – A Monthly Report Pipeline
Python Intermediate Lesson 10: Project – A Monthly Report Pipeline
Final project: read every monthly CSV in a folder, combine, enrich with products and customers, compute KPIs and write a multi-sheet Excel report with…
Read article →CUBEMEMBERPROPERTY Function in Excel: Property of a Cube Member
CUBEMEMBERPROPERTY Function in Excel: Property of a Cube Member
CUBEMEMBERPROPERTY returns a property of a member, such as a product's category or a customer's city, from the model. Cube functions read from a…
Read article →EXACT Function in Excel: Case-Sensitive Comparison
EXACT Function in Excel: Case-Sensitive Comparison
EXACT compares two texts including upper/lower case. A normal =A2=B2 ignores case.
Read article →Python Intermediate Lesson 9: Command-Line Tools With argparse
Python Intermediate Lesson 9: Command-Line Tools With argparse
Turn a script into a reusable tool with options and help text using argparse, and run it from a batch file or Windows Task…
Read article →COPILOT Function in Excel: Ask AI Inside a Formula
COPILOT Function in Excel: Ask AI Inside a Formula
COPILOT (2025) sends a prompt plus the cells you reference to Microsoft's AI and returns the answer into the grid, e.g. classify feedback, summarise…
Read article →Python Intermediate Lesson 8: JSON and APIs
Python Intermediate Lesson 8: JSON and APIs
Read and write JSON, call a REST API with requests, check status codes and handle errors, and convert rupees to other currencies from an…
Read article →