Excel (MSE) practice & example workbooks

1. Intro to Formulas/Functions lecture, demo, and practice workbook

2. Practice workbook: manual formulas, nestled functions, VLOOKUP (+ an IF!) (below)

3. Follow-along demo: Reproduce a worksheet including IF, MAX, AVERAGE, SUM

4. Example workbook: sports score formulas/functions (below)

5. 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