Research Guides: ENGR101: Intermediate EXCEL Skill Videos

Intermediate Excel Skills

Creating and Using Count Functions in Excel
A video explaing how to create and use Count Functions in Excel
Absolute Referencing
A video explaing how to use Absolute Referencing in Excel
Absolute Referencing only Part of a Formula
A video explaing how to use Absolute Referencing for only part of a cell in Excel
IF Logical Tests
A video explaining how to create and use IF Logical Tests in Excel
Nested IF Statements
A video explaining how to nest IF statements in Excel
AND, OR & NOT Statements
A video explaining how to use AND, OR & NOT statements in Excel
COUNTIF, SUMIF & AVERAGTEIF Functions
A video explaining how to use COUNTIF, SUMIF & AVERAGEIF statements in Excel
Mean, Median & Mode
A video explaing how to find and use Mean, Median & Mode in Excel