LOGNORM.INV Function in Excel: Value for a Lognormal Probability
StatisticsLevel: ExpertAvailable in: Excel 2010+LOGNORM.INV returns the value at a lognormal probability.Syntax=LOGNORM.INV(probability, mean.
Read article →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
TRIMMEAN Function in Excel: Average That Ignores Extremes
TRIMMEAN Function in Excel: Average That Ignores Extremes
TRIMMEAN drops a share of the highest and lowest values and averages the rest, much like judges scoring gymnastics. One giant order stops distorting…
Read article →Find and Highlight Duplicates in Excel (One Column, Two Columns, Whole Rows)
Find and Highlight Duplicates in Excel (One Column, Two Columns, Whole Rows)
Flag duplicate invoices, repeated customers and duplicate rows with COUNTIF/COUNTIFS, conditional formatting, UNIQUE and the first-occurrence trick — and choose what “duplicate” means before…
Read article →Find the LAST Match in a List: the LOOKUP(2, 1/…) Trick Explained
Find the LAST Match in a List: the LOOKUP(2, 1/…) Trick Explained
Get the latest price, last status or most recent date for an item with the famous LOOKUP(2,1/(range=value)) formula — explained step by step, plus…
Read article →CUMPRINC Function in Excel: Principal Repaid Over a Period
CUMPRINC Function in Excel: Principal Repaid Over a Period
CUMPRINC totals the principal part of loan payments between two periods — how much of the loan you actually cleared this year.
Read article →COVARIANCE.P Function in Excel: Covariance of a Whole Population
COVARIANCE.P Function in Excel: Covariance of a Whole Population
COVARIANCE.P measures how two complete data sets move together, dividing by n (COVARIANCE.S divides by n-1).
Read article →XLOOKUP with Two (or More) Criteria — Plus the INDEX-MATCH Version
XLOOKUP with Two (or More) Criteria — Plus the INDEX-MATCH Version
Look up a value using two conditions — product AND region, or employee AND month — with XLOOKUP, INDEX-MATCH, or a helper column. With…
Read article →PPMT Function in Excel: Principal Part of an EMI
PPMT Function in Excel: Principal Part of an EMI
FinancialLevel: ExpertAvailable in: Excel 2007+PPMT returns the principal repaid by a specific EMI.Syntax=PPMT(rate, per, nper, pv, [fv].
Read article →Power BI Lesson 2: The Data Model — Facts, Dimensions and a Star Schema
Power BI Lesson 2: The Data Model — Facts, Dimensions and a Star Schema
Design a Power BI model that works: fact tables vs dimension tables, why a star schema beats one big flat table, keys, a Calendar…
Read article →Power BI Lesson 6: CALCULATE and Filter Context
Power BI Lesson 6: CALCULATE and Filter Context
Understand filter context, then change it with CALCULATE: sales for one category, ignore a filter with ALL and REMOVEFILTERS, share of total, and the…
Read article →Power BI Data Modelling: Build a Star Schema (and Why Your Report Is Slow Without One)
Power BI Data Modelling: Build a Star Schema (and Why Your Report Is Slow Without One)
Learn the star schema for Power BI: fact and dimension tables, one-to-many relationships, filter direction, a proper date table, and how to turn a…
Read article →DAX CALCULATE Explained: Filter Context Without the Headache
DAX CALCULATE Explained: Filter Context Without the Headache
A deep, practical guide to CALCULATE in Power BI and Power Pivot: filter context, row context, ALL, REMOVEFILTERS, KEEPFILTERS, time intelligence and the patterns…
Read article →