Charts Intermediate Lesson 5: In-Cell Data Visualization — Sparklines, REPT Bars and Heat Maps
Tiny charts inside cells: sparklines for trends, REPT bars, trend arrows and a colour-scale heat map for a region x month table.
Read article →Atul Vij
EXPONDIST Function in Excel: Exponential Distribution (Older Name)
EXPONDIST Function in Excel: Exponential Distribution (Older Name)
EXPONDIST returns the exponential probability. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but Microsoft…
Read article →WEIBULL Function in Excel: Weibull (Older Name)
WEIBULL Function in Excel: Weibull (Older Name)
WEIBULL returns the Weibull probability. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but Microsoft…
Read article →Charts Intermediate Lesson 4: Actual vs Target Charts with Automatic Conditional Colors
Charts Intermediate Lesson 4: Actual vs Target Charts with Automatic Conditional Colors
Colour bars green when on target and red when below using two helper series with NA(), add a target marker line, and keep it…
Read article →Charts Intermediate Lesson 3: Dynamic Charts with a Drop-Down Menu in Excel
Charts Intermediate Lesson 3: Dynamic Charts with a Drop-Down Menu in Excel
One chart, any region: a drop-down cell drives an INDEX/MATCH helper column, the chart reads the helper, and the title updates with a cell…
Read article →Open-Source AI Agents: OpenClaw, OpenHands, Aider, n8n and More — What They Do and How to Install
Open-Source AI Agents: OpenClaw, OpenHands, Aider, n8n and More — What They Do and How to Install
A guide to popular open-source AI agent software — OpenClaw personal assistant, OpenHands coding agent, Aider, Open Interpreter, n8n and CrewAI — with install…
Read article →Charts Intermediate Lesson 2: Waterfall Charts – Explain a Change
Charts Intermediate Lesson 2: Waterfall Charts – Explain a Change
Build a revenue or profit bridge from last year to this year with Excel's waterfall chart: set totals, colour increases and decreases, and order…
Read article →Charts Intermediate Lesson 1: Combo Charts and a Secondary Axis
Charts Intermediate Lesson 1: Combo Charts and a Secondary Axis
Show sales in rupees and margin in % on one chart: a combo chart with columns, a line on the secondary axis, and how…
Read article →GESTEP Function in Excel: Is It at Least the Threshold?
GESTEP Function in Excel: Is It at Least the Threshold?
GESTEP returns 1 if a number is greater than or equal to a step value, otherwise 0 — SUM it to count values over…
Read article →BETAINV Function in Excel: Inverse Beta (Older Name)
BETAINV Function in Excel: Inverse Beta (Older Name)
BETAINV returns the value at a beta probability. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still…
Read article →Meta Llama Models Explained: Llama 1, 2, 3 and 4 — What Changed Each Time
Meta Llama Models Explained: Llama 1, 2, 3 and 4 — What Changed Each Time
A clear history of Meta’s open-weight Llama models: Llama 1 (2023) to Llama 4 Scout and Maverick (2025), with sizes, context length, licences, what…
Read article →ERFC Function in Excel: Complementary Error Function
ERFC Function in Excel: Complementary Error Function
EngineeringLevel: ExpertAvailable in: Excel 2007+ERFC returns 1 - ERF(x): the tail beyond x.Syntax=ERFC(x)ArgumentWhat it meansxValueExamplesExample.
Read article →