Averaging with FILTER
An Excel file that teaches how to perform Averaging with FILTER operation.
Calculating the Average of the Last 3 Numerical Values
Excel file teaching how to perform Calculating the Average of the Last 3 Numerical Values operation.
Average Excluding Zero Values
An Excel file that teaches how to perform Average Excluding Zero Values operation.
Finding the Biggest Winners 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.
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.
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.
Includes 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 with Multiple Criteria
An Excel file that teaches how to perform Filtering with Multiple Criteria operation.
Using December-Based Conditional Functions
An Excel file that teaches how to perform Using December-Based Conditional Functions operation.
Understanding the Importance of the PRODUCT 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.
Get the Name of the Image Uploaded to the Form
An Excel file that teaches how to perform Get the Name of the Image Uploaded to the Form operation.
Separating Letters and Numbers in a Cell
An Excel file that teaches how to perform Separating Letters and Numbers in a Cell operation.
Workplace Budget Draft
An Excel file that teaches how to perform Workplace Budget Draft operation.
Cash Flow Analysis for Rental Real Estate
An Excel file that teaches how to perform Cash Flow Analysis for Rental Real Estate operation.
Data Size Unit Conversion Table
An Excel file that teaches how to perform Data Size Unit Conversion Table operation.