Filtering to Extract Matching Values
An Excel file that teaches how to perform Filtering to Extract Matching Values operation.
Using a FILTER to Remove Columns
An Excel file that teaches how to perform Using FILTER to Remove Columns operation.
Filtering Duplicate Values
An Excel file that teaches how to perform Filtering Repeated Values operation.
Filtering Values Within Tolerance
An Excel file that teaches how to perform Filtering Values Within Tolerance operation.
Using a Filter with Complex Multiple Criteria
An Excel file that teaches how to perform Using FILTER with Complex Multiple Criteria operation.
Filtering by Multiple Criteria
An Excel file that teaches how to perform Filtering with Multiple Criteria operation.
Using Multiple OR in FILTER Function
An Excel file that teaches how to perform Using Multiple OR in the FILTER Function operation.
Using a Partial Match in a FILTER Function
An Excel file that teaches how to perform Using Partial Matching in the FILTER Function operation.
Generating Random Text Strings
An Excel file that teaches how to perform Generating Random Text Strings operation.
GROUP BY Monthly Totals Using Criteria
An Excel file that teaches how to perform Using GROUP MEASURE with Monthly Totals operation.
Applying a Simple Chart
An Excel file that teaches how to perform A Simple Graph Application operation.
Highlighting Dates by Month and Year
An Excel file that teaches how to perform Highlighting Dates by Month and Year operation.
Testing Conditional Formatting
An Excel file that teaches how to perform Testing Conditional Formatting operation.
Creating Dependent Drop-Down Lists
An Excel file that teaches how to perform Creating Dependent Dropdown Lists operation.
Learning INDEX and WHAT Functions
There is an Excel file that teaches how to perform the Learning the INDEX and MATCH Functions operation.
Solving Double Negativities in Formulas
An Excel file that teaches how to perform Solving Double Negatives in Formulas operation.
Using Range-Based Conditional Functions
An Excel file that teaches how to perform Using December-Based Conditional Functions operation.
COLLECT. MULTIPLICATION Understanding the Importance of the Function
Excel file teaching how to perform Understanding the Importance of the PRODUCT Function operation.
Comparison of CROSS and VLOOKUP
An Excel file that teaches how to perform Cross-Axis vs. Vertical-Axis Comparison operation.
CROSS to INDEX and RATIO
An Excel file that teaches how to perform CROSS-REFERENCE with INDEX and WHICH COMPARISON operation.
Using Regular Expressions
An Excel file that teaches how to perform Using Regular Expressions operation.
Solving Problems in Penny Differences
An Excel file that teaches how to perform Resolving Issues with Cent Differences operation.
Finding the Average of the 3 Highest Scores
An Excel file that teaches how to perform Finding the Average of the Highest 3 Scores operation.