Completed
2. Create Gradebook with Dynamic Spilled Arrays Formulas and the XLOOKUP function.
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel 365 for Teaching: Dynamic Arrays, XLOOKUP, Power Query and PivotTables
Automatically move to the next video in the Classroom when playback concludes
- 1 1. Introduction
- 2 2. Create Gradebook with Dynamic Spilled Arrays Formulas and the XLOOKUP function.
- 3 3. Don’t be Tricked by Number Formatting
- 4 4. BYROW and BYCOL functions to spill aggregate totals and averages
- 5 5. Dynamic Spilled Arrays Formulas to Create Budget
- 6 6. Power Query to Import Student Grade Data from Canvas
- 7 7. PivotTables to Create Summary Reports from Student Survey Data
- 8 8. Cross Tabulated PivotTable is like Three Reports in One!
- 9 9. Summary
- 10 10. Closing and Video Links
