Build a Dynamic Excel Chart That Changes with a Dropdown
Create one chart that switches between regions, products or years from a dropdown list — using Data Validation, XLOOKUP or INDEX-MATCH, and a small…
Read article →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
COUNTIFS Function in Excel: Count With Multiple Conditions
COUNTIFS Function in Excel: Count With Multiple Conditions
StatisticalLevel: IntermediateAvailable in: Excel 2007+COUNTIFS counts rows where every condition is true.Syntax=COUNTIFS(criteria_range1, criteria1.
Read article →CUBESET Function in Excel: A Set of Members for Top-N Reports
CUBESET Function in Excel: A Set of Members for Top-N Reports
CUBESET defines a sorted set from the Data Model — combine it with CUBERANKEDMEMBER for top-10 lists that update themselves.
Read article →MAP Function in Excel: Transform Every Value in an Array
MAP Function in Excel: Transform Every Value in an Array
MAP applies a LAMBDA to every item of one or more arrays and returns an array of results.
Read article →REGEXEXTRACT Function in Excel: Pull Text That Matches a Pattern
REGEXEXTRACT Function in Excel: Pull Text That Matches a Pattern
REGEXEXTRACT returns the part of text that matches a pattern — invoice numbers, phone numbers, amounts buried in narration.
Read article →ISFORMULA Function in Excel: Does the Cell Hold a Formula?
ISFORMULA Function in Excel: Does the Cell Hold a Formula?
ISFORMULA returns TRUE when a cell contains a formula. Use it in conditional formatting to catch numbers someone typed over a formula column.
Read article →SEARCH Function in Excel: Position of Text (Any Case, Wildcards)
SEARCH Function in Excel: Position of Text (Any Case, Wildcards)
SEARCH works like FIND but ignores case and accepts wildcards (? and *). With ISNUMBER it becomes a “contains” test.
Read article →TEXTAFTER Function in Excel: Text After a Delimiter
TEXTAFTER Function in Excel: Text After a Delimiter
TEXTAFTER returns the text that follows a delimiter — domains from emails, surnames, file extensions.
Read article →DROP Function in Excel: Remove First or Last Rows
DROP Function in Excel: Remove First or Last Rows
DROP removes rows or columns from the start (positive) or end (negative) of an array — e.g. strip headers or total rows.
Read article →ISREF Function in Excel: Is It a Valid Reference?
ISREF Function in Excel: Is It a Valid Reference?
ISREF returns TRUE when its argument is a reference. With INDIRECT it checks whether a sheet name typed by a user exists.
Read article →SMALL Function in Excel: The k-th Smallest Value
SMALL Function in Excel: The k-th Smallest Value
StatisticalLevel: IntermediateAvailable in: Excel 2007+SMALL returns the k-th smallest number — bottom-N lists and the earliest dates.Syntax=SMALL(array.
Read article →VALUETOTEXT Function in Excel: Any Value as Text
VALUETOTEXT Function in Excel: Any Value as Text
VALUETOTEXT converts any value to text; strict mode adds quotes around text so you can see stray spaces.
Read article →