FREQUENCY Function in Excel: Count Values Into Bins
FREQUENCY counts how many values fall into each bin — the data behind a histogram.
Read article →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
RANK.EQ Function in Excel: Rank a Number in a List
RANK.EQ Function in Excel: Rank a Number in a List
StatisticalLevel: IntermediateAvailable in: Excel 2010+RANK.EQ returns the position of a number in a list. Ties share the same rank.Syntax=RANK.EQ(number.
Read article →Charts Lesson 5: Dynamic Charts With Drop-Downs
Charts Lesson 5: Dynamic Charts With Drop-Downs
Make one chart that changes with a drop-down: data validation list, INDEX/XLOOKUP helper range, chart on the helper, and dynamic titles linked to a…
Read article →CUBEKPIMEMBER Function in Excel: KPI Value From a Data Model
CUBEKPIMEMBER Function in Excel: KPI Value From a Data Model
CUBEKPIMEMBER returns a KPI property (value, goal, status, trend) from an OLAP cube or Power Pivot model. Cube functions read from a Power Pivot…
Read article →VBA Collections and Dictionaries: Unique Lists, Counts and Fast Lookups
VBA Collections and Dictionaries: Unique Lists, Counts and Fast Lookups
Excel VBA course lesson 14: when to use a Collection or a Scripting.Dictionary, build unique lists, count and total by key, look up values…
Read article →VBA UserForms for Beginners: Build a Data-Entry Form Step by Step
VBA UserForms for Beginners: Build a Data-Entry Form Step by Step
Excel VBA course lesson 13: design a UserForm, fill combo boxes from a sheet, validate inputs, write a new row to a table, and…
Read article →AVERAGEIFS Function in Excel: Average With Multiple Conditions
AVERAGEIFS Function in Excel: Average With Multiple Conditions
StatisticalLevel: IntermediateAvailable in: Excel 2007+AVERAGEIFS averages values where all conditions are true.Syntax=AVERAGEIFS(average_range.
Read article →REDUCE Function in Excel: Boil an Array Down to One Result
REDUCE Function in Excel: Boil an Array Down to One Result
REDUCE is SCAN that returns only the final result — useful for repeated clean-up steps.
Read article →VBA Events: Macros That Run by Themselves (Worksheet_Change and More)
VBA Events: Macros That Run by Themselves (Worksheet_Change and More)
Excel VBA course lesson 12: Workbook_Open, Worksheet_Change, SelectionChange and BeforeSave events — timestamps when a cell is edited, auto-uppercase codes, validation, and how to…
Read article →Excel Lesson 9: Your First Charts
Excel Lesson 9: Your First Charts
Pick the right chart for the job, build column, line, pie and combo charts in seconds, add titles and data labels, change the chart…
Read article →VBA Worksheets and Workbooks: Add, Copy, Loop, Save Safely
VBA Worksheets and Workbooks: Add, Copy, Loop, Save Safely
Excel VBA course lesson 11: refer to workbooks and sheets without ActiveSheet bugs, loop through every sheet, add and rename sheets, copy sheets to…
Read article →DELTA Function in Excel: Are Two Numbers Equal?
DELTA Function in Excel: Are Two Numbers Equal?
DELTA returns 1 if two numbers are equal and 0 otherwise — easy to SUM for a count of matches.
Read article →