AVERAGING with FILTER
An Excel file that teaches how to perform Averaging with FILTER operation.
Averaging the Last 3 Numeric Values
Excel file teaching how to perform Calculating the Average of the Last 3 Numerical Values operation.
Average ignoring numbers with zero
An Excel file that teaches how to perform Average Excluding Zero Values operation.
Finding Top Gainers and Losers
An Excel file that teaches how to perform Finding the Biggest Winners and Losers operation.
Combining Data from Multiple Worksheets
An Excel file that teaches how to perform Combining Data from Multiple Worksheets operation.
Learning to Count Unique Values
An Excel file that teaches how to perform Learning to Count Unique Values operation.
Counting unique values based on criteria
An Excel file that teaches how to perform Counting Unique Values Based on Criteria operation.
Dynamic Two-Way Average
An Excel file that teaches how to perform Dynamic Two-Way Average operation.
Filtering and Excluding Columns
An Excel file that teaches how to perform Filtering and Excluding Columns operation.
Filter data between dates
An Excel file that teaches how to perform Filtering Data Between Dates operation.
Filter Every X Next Rows
An Excel file that teaches how to perform Filtering Every Xth Row operation.
Filtering Horizontal Data
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.
Contains Filtering
An Excel file that teaches how to perform Includes Filtering operation.
Filtering Values Within Tolerance
An Excel file that teaches how to perform Filtering Values Within Tolerance operation.
Filtering by Multiple Criteria
An Excel file that teaches how to perform Filtering with Multiple Criteria 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.
Using Regular Expressions
An Excel file that teaches how to perform Using Regular Expressions operation.
Charting Daily Blood Sugar Data
There is an Excel file that teaches how to perform the Charting Daily Blood Sugar Data operation.
Moving Average Analysis in Financial Data
There is an Excel file that teaches how to perform the Moving Average Analysis in Financial Data operation.
Measuring Effectiveness and Efficiency of Data
There is an Excel file that teaches how to perform the Measuring Effectiveness and Efficiency of Data operation.
Performing Statistical Analysis of Pandemic Data
There is an Excel file that teaches how to perform the Performing Statistical Analysis of Pandemic Data operation.
Monitoring Health Data on a Graph
There is an Excel file that teaches how to perform the Monitoring Health Data on a Graph operation.