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 →COUNTIFS Function in Excel: Count With Multiple Conditions
COUNTIFS Function in Excel: Count With Multiple Conditions
StatisticalLevel: IntermediateAvailable in: Excel 2007+COUNTIFS counts rows where every condition is true.Syntax=COUNTIFS(criteria_range1, criteria1.
Read article →Python Intermediate Lesson 5: pandas in Depth – Merge, GroupBy and Pivot Tables
Python Intermediate Lesson 5: pandas in Depth – Merge, GroupBy and Pivot Tables
Clean types with to_datetime and to_numeric, merge three tables, use named aggregations in groupby and build pivot tables, avoiding the duplicate-column trap.
Read article →CUBESET Function in Excel: A Set of Members for Top-N Reports
CUBESET Function in Excel: A Set of Members for Top-N Reports
CUBESET defines a sorted set from the Data Model — combine it with CUBERANKEDMEMBER for top-10 lists that update themselves.
Read article →Python Intermediate Lesson 4: Dates, Formats and the Indian Financial Year
Python Intermediate Lesson 4: Dates, Formats and the Indian Financial Year
Parse and format dates with strptime and strftime, compute FY labels and quarters, add working days with holidays and find month ends with datetime.
Read article →Python Intermediate Lesson 3: Errors, try/except and Logging
Python Intermediate Lesson 3: Errors, try/except and Logging
Process files with bad rows without crashing: catch specific exceptions, log what was skipped and why, and use finally for clean-up.
Read article →Python Intermediate Lesson 2: Comprehensions, Generators and Sorting
Python Intermediate Lesson 2: Comprehensions, Generators and Sorting
Write shorter, faster Python: list, dict and set comprehensions, generator expressions, enumerate, zip and sorted with a key function, on real invoice data.
Read article →MAP Function in Excel: Transform Every Value in an Array
MAP Function in Excel: Transform Every Value in an Array
MAP applies a LAMBDA to every item of one or more arrays and returns an array of results.
Read article →Python Intermediate Lesson 1: Project Folders, pathlib and Virtual Environments
Python Intermediate Lesson 1: Project Folders, pathlib and Virtual Environments
Set up Python projects properly: one folder per project, a virtual environment, requirements.txt and pathlib paths that work wherever the script runs.
Read article →