Overview of Spreadsheet Functions Resource This resource provides a structured learning path through essential spreadsheet functions and features. Each lesson focuses on specific skills, building a comprehensive understanding of spreadsheet capabilities. Formatting Defining Cells/Ranges, Formulas, and Functions Creating Graphs Absolute Cell Referencing Count Functions SUMIF AVERAGEIF IF Statements Nested IF Statements Extract Function VLOOKUP HLOOKUP LOOKUP XLOOKUP Extract Functions and VLOOKUP Extract Functions and IF/Nested Statements IF and VLOOKUP NOT IF