Counting Unique Values Based on Criteria
An Excel file that teaches how to perform Counting Unique Values Based on Criteria operation.
Using the Detailed LET Formula
An Excel file that teaches how to perform Using the Detailed LET Formula operation.
Finding Distinct Values
An Excel file that teaches how to perform Finding Distinct Values operation.
Dynamic Summary Counting
An Excel file that teaches how to perform Dynamic Summary Counting operation.
Dynamic Two-Way Average
An Excel file that teaches how to perform Dynamic Two-Way Average operation.
Dynamic Two-Way Counting
An Excel file that teaches how to perform Dynamic Two-Way Counting operation.
Filtering and Excluding Columns
An Excel file that teaches how to perform Filtering and Excluding Columns operation.
Dynamic Two-Way Aggregation
An Excel file that teaches how to perform Dynamic Two-Way Aggregation operation.
Extracting Common Values from Text Strings
An Excel file that teaches how to perform Extracting Common Values from Text Strings operation.
Extracting Common Values from Two Lists
An Excel file that teaches how to perform Extracting Common Values from Two Lists operation.
Removing Numbers from Text
An Excel file that teaches how to perform Removing Numbers from Text operation.
Error-Free Filtering and Sorting
An Excel file that teaches how to perform Error-Free Filtering and Sorting operation.
Converting Horizontal Data to Vertical Using FILTER
Excel file teaching how to perform Converting Horizontal Data to Vertical Using FILTER operation.
Filtering by Column and Sorting by Row
An Excel file that teaches how to perform Filtering by Column and Sorting by Row operation.
Case-Sensitive Filtering
An Excel file that teaches how to perform Case-Sensitive Filtering operation.
Includes One of Many Filters
An Excel file that teaches how to perform Includes One of Many Filters operation.
Learn About Labor Costs in 2026
An Excel file that teaches how to perform Learn About Labor Costs in 2026 operation.
Filtering Data Between Dates
An Excel file that teaches how to perform Filtering Data Between Dates operation.
Filtering Every Xth Row
An Excel file that teaches how to perform Filtering Every Xth Row operation.
Filtering Excluding Empty Values
An Excel file that teaches how to perform Filtering Excluding Empty Values operation.
Horizontal Data Filtering
An Excel file that teaches how to perform Horizontal Data Filtering operation.
Filtering the Last Valid Entry
An Excel file that teaches how to perform Filtering the Last Valid Entry operation.
First or Last X Value Filtering
An Excel file that teaches how to perform First or Last X Value Filtering operation.