Decisions in VBA: If…Then, And/Or and Select Case
Excel VBA course lesson 4: make macros decide with If…Then…Else, ElseIf, And, Or and Not, check empty and error cells, and replace long If…
Read article →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
DPRODUCT Function in Excel: Multiply Values Matching Criteria
DPRODUCT Function in Excel: Multiply Values Matching Criteria
DPRODUCT multiplies the values of a field for matching records (rarely needed; e.g. compounding growth factors). Like all D-functions it uses a database range…
Read article →Format Cells with VBA: Fonts, Colours, Borders and Number Formats
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 →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 →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 →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 →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 →