Excel 365 to Make Your Teaching Job Easy: Dynamic Spilled Arrays, XLOOKUP, Power Query & PivotTables

Highline College Professional Development Day 2024 presentation by Mike “excelisfun” Girvin Download Excel file: https://people.highline.edu/mgirvin/M365Excel-HighlineProDevDay.xlsx Download csv files: https://people.highline.edu/mgirvin/Busn430CanvasScores.csv https://people.highline.edu/mgirvin/Busn430CanvasScores01.csv https://people.highline.edu/mgirvin/Busn430CanvasScores02.csv Pdf file with video notes: https://excelisfun.net/files/M365Excel-HighlineProDevDay.pdf In this video learn how to: Create Gradebook with Dynamic Spilled Arrays Formulas and the XLOOKUP function, Use Dynamic Spilled Arrays Formulas to Create Budget, Use Power Query to Import Student Grade Data from Canvas, Use PivotTables to Create Summary Reports from Student Survey Data. Topics: 1. (00:00) Introduction 2. (01:25) Create Gradebook with Dynamic Spilled Arrays Formulas and the XLOOKUP function. 3. (12:05) Don’t be Tricked by Number Formatting 4. (16:05) BYROW and BYCOL functions to spill aggregate totals and averages 5. (19:50) Dynamic Spilled Arrays Formulas to Create Budget 6. (25:17) Power Query to Import Student Grade Data from Canvas 7. (39:49) PivotTables to Create Summary Reports from Student Survey Data 8. (44:52) Cross Tabulated PivotTable is like Three Reports in One! 9. (51:16) Summary 10. (51:48) Closing and Video Links