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 →Atul Vij
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 →ISNUMBER Function in Excel: Is It a Real Number?
ISNUMBER Function in Excel: Is It a Real Number?
ISNUMBER returns TRUE for numbers (and dates). Combined with SEARCH or MATCH, it turns “found / not found” into TRUE/FALSE.
Read article →Python Intermediate Lesson 7: Formatted Excel Reports With openpyxl
Python Intermediate Lesson 7: Formatted Excel Reports With openpyxl
Write Excel files people like to open: several sheets, live formulas, header styles, number formats, frozen panes and a chart, all from Python with…
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 →Python Intermediate Lesson 6: Regular Expressions for UPI, GSTIN and PAN
Python Intermediate Lesson 6: Regular Expressions for UPI, GSTIN and PAN
Use Python regex with named groups to parse UPI bank narrations and validate GSTIN, PAN and phone numbers, with patterns explained piece by piece.
Read article →