MUNIT Function in Excel: Identity Matrix
MUNIT returns an identity matrix — 1s on the diagonal, 0s elsewhere. Handy for checking MINVERSE results.
Read article →ATAN Function in Excel: Angle From a Slope
ATAN Function in Excel: Angle From a Slope
ATAN turns a slope (rise/run) into an angle. ATAN2 handles all four quadrants.
Read article →ACOS Function in Excel: Angle From a Cosine
ACOS Function in Excel: Angle From a Cosine
ACOS is the inverse of COS. It appears in the formula for distance between two places on Earth.
Read article →ASIN Function in Excel: Angle From a Sine
ASIN Function in Excel: Angle From a Sine
ASIN returns the angle (in radians) whose sine is the given number.
Read article →Office Scripts in Excel for the Web: Your First Script, Explained Like VBA
Office Scripts in Excel for the Web: Your First Script, Explained Like VBA
What Office Scripts are, how they differ from VBA, how to record and edit a script, a real clean-up example in TypeScript, and how…
Read article →TAN Function in Excel: Tangent of an Angle
TAN Function in Excel: Tangent of an Angle
TAN links an angle to a slope. Radians again — wrap degrees in RADIANS().
Read article →LOG10 Function in Excel: Base-10 Logarithm
LOG10 Function in Excel: Base-10 Logarithm
LOG10 tells you the order of magnitude. Charts of values ranging from hundreds to crores are easier to read on a log scale.
Read article →ISO.CEILING Function in Excel: Round Up, Ignoring the Sign
ISO.CEILING Function in Excel: Round Up, Ignoring the Sign
ISO.CEILING always rounds towards positive infinity, whatever the sign of the multiple — useful when data mixes positive and negative adjustments.
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 →FLOOR Function in Excel: Round Down to a Multiple (Classic)
FLOOR Function in Excel: Round Down to a Multiple (Classic)
FLOOR rounds down to a multiple — full boxes you can ship, 15-minute billing blocks.
Read article →Linear Regression in Excel with LINEST, SLOPE and FORECAST — No Add-ins
Linear Regression in Excel with LINEST, SLOPE and FORECAST — No Add-ins
Machine learning starts with a straight line. Fit a regression in Excel with SLOPE, INTERCEPT, RSQ, LINEST and FORECAST.LINEAR, and learn how to read…
Read article →CEILING Function in Excel: Round Up to a Multiple (Classic)
CEILING Function in Excel: Round Up to a Multiple (Classic)
CEILING rounds up to the nearest multiple — prices ending in 5 or 9, pack sizes. CEILING.MATH is the newer version that handles negatives…
Read article →