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 →Atul Vij
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 →REGEXEXTRACT Function in Excel: Pull Text That Matches a Pattern
REGEXEXTRACT Function in Excel: Pull Text That Matches a Pattern
REGEXEXTRACT returns the part of text that matches a pattern — invoice numbers, phone numbers, amounts buried in narration.
Read article →ISFORMULA Function in Excel: Does the Cell Hold a Formula?
ISFORMULA Function in Excel: Does the Cell Hold a Formula?
ISFORMULA returns TRUE when a cell contains a formula. Use it in conditional formatting to catch numbers someone typed over a formula column.
Read article →SEARCH Function in Excel: Position of Text (Any Case, Wildcards)
SEARCH Function in Excel: Position of Text (Any Case, Wildcards)
SEARCH works like FIND but ignores case and accepts wildcards (? and *). With ISNUMBER it becomes a “contains” test.
Read article →TEXTAFTER Function in Excel: Text After a Delimiter
TEXTAFTER Function in Excel: Text After a Delimiter
TEXTAFTER returns the text that follows a delimiter — domains from emails, surnames, file extensions.
Read article →