Intro to Formulas/Functions lecture, demo, and practice workbook
Practice workbook: manual formulas, nestled functions, VLOOKUP (+ an IF!) (below)
Follow-along demo: Reproduce a worksheet including IF, MAX, AVERAGE, SUM
Example workbook: sports score formulas/functions (below)
Practice workbook: Chapter 4 (tables, structured references) (below)
VLOOKUP practice workbook
.xlsx
Download XLSX • 12KB
sports scores example formulas
.xlsx
Download XLSX • 13KB
chapter 4 demo
.xlsx
Download XLSX • 22KB