Power BI Lesson 5: Your First DAX — SUM, COUNTROWS, DIVIDE
Write the core measures every report needs: total sales with SUMX, cost and margin, order counts with COUNTROWS, distinct counts, averages, and safe ratios…
Read article →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
Power BI Lesson 4: Measures vs Calculated Columns
Power BI Lesson 4: Measures vs Calculated Columns
Understand the difference that confuses every beginner: calculated columns compute per row and are stored; measures compute on the fly in filter context. When…
Read article →Power BI Lesson 3: Relationships and Filter Direction
Power BI Lesson 3: Relationships and Filter Direction
Connect tables in the Model view: one-to-many relationships, cardinality, single vs both cross-filter direction, active and inactive relationships, and fixing the blank row and…
Read article →Build a Data Entry Form in Excel VBA (UserForm Step by Step)
Build a Data Entry Form in Excel VBA (UserForm Step by Step)
Create a VBA UserForm for clean data entry: design the form, fill drop-downs from a table, validate inputs, add rows to an Excel Table,…
Read article →STDEV Function in Excel: Sample Standard Deviation (Older Name)
STDEV Function in Excel: Sample Standard Deviation (Older Name)
STDEV estimates the standard deviation from a sample. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still…
Read article →DB Function in Excel: Declining-Balance Depreciation
DB Function in Excel: Declining-Balance Depreciation
DB calculates depreciation using a fixed-rate declining balance derived from cost, salvage and life, with an optional first-year month count.
Read article →SLN Function in Excel: Straight-Line Depreciation
SLN Function in Excel: Straight-Line Depreciation
FinancialLevel: IntermediateAvailable in: Excel 2007+SLN returns equal depreciation for each period of an asset's life.Syntax=SLN(cost, salvage.
Read article →CUMIPMT Function in Excel: Total Interest Over a Range of EMIs
CUMIPMT Function in Excel: Total Interest Over a Range of EMIs
CUMIPMT totals the interest paid between two payment numbers — e.g. for one financial year. CUMPRINC does the same for principal.
Read article →IPMT Function in Excel: Interest Part of an EMI
IPMT Function in Excel: Interest Part of an EMI
IPMT returns how much of a given EMI is interest; PPMT returns the principal part. Together they always equal PMT.
Read article →SQRT Function in Excel: Square Root
SQRT Function in Excel: Square Root
MathLevel: BeginnerAvailable in: Excel 2007+SQRT returns the positive square root.Syntax=SQRT(number)ArgumentWhat it meansnumberZero or.
Read article →SIGN Function in Excel: Positive, Negative or Zero?
SIGN Function in Excel: Positive, Negative or Zero?
SIGN returns 1 for positive, −1 for negative and 0 for zero — neat for direction arrows and counting gains vs losses.
Read article →ISEVEN Function in Excel: Is the Number Even?
ISEVEN Function in Excel: Is the Number Even?
ISEVEN returns TRUE for even numbers; ISODD for odd ones. Decimals are truncated first.
Read article →