YoVDO

Excel 365 for Teaching: Dynamic Arrays, XLOOKUP, Power Query and PivotTables

Offered By: ExcelIsFun via YouTube

Tags

Microsoft Excel Courses Data Analysis Courses Budgeting Courses Power Query Courses PivotTables Courses XLOOKUP Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Discover powerful Excel 365 features to streamline your teaching tasks in this comprehensive 52-minute presentation from Highline College's Professional Development Day 2024. Learn to create dynamic gradebooks using spilled arrays and XLOOKUP, develop budgets with advanced formulas, import Canvas grade data via Power Query, and generate insightful reports from student surveys using PivotTables. Master essential skills like number formatting, aggregate calculations with BYROW and BYCOL functions, and cross-tabulated PivotTables for efficient data analysis. Download accompanying resources to follow along and enhance your Excel proficiency for educational applications.

Syllabus

1. Introduction
2. Create Gradebook with Dynamic Spilled Arrays Formulas and the XLOOKUP function.
3. Don’t be Tricked by Number Formatting
4. BYROW and BYCOL functions to spill aggregate totals and averages
5. Dynamic Spilled Arrays Formulas to Create Budget
6. Power Query to Import Student Grade Data from Canvas
7. PivotTables to Create Summary Reports from Student Survey Data
8. Cross Tabulated PivotTable is like Three Reports in One!
9. Summary
10. Closing and Video Links


Taught by

ExcelIsFun

Related Courses

Using Covid-19 Data to Make Supply Chain Logistics Decisions in Spreadsheets
Coursera Project Network via Coursera
Microsoft Excel - Excel from Beginner to Advanced
Udemy
Excel Shortcuts, Excel Tips, Excel Tricks - Excel Skills!
Udemy
Learn Excel 2016 Intermediate Level - Beyond the Basics
Udemy
Microsoft Excel Mastery: From Beginner to Pro
Udemy