For Fall 2024 matriculating students at Highline College in Seattle, Washington. This is the introduction to the Busn 210 Excel Statistical Analysis class. For non-matriculating students, the class is free here at YouTube: https://www.youtube.com/playlist?list=PLrRPvpgDmw0m3oqpp1XcPuaxyM4Bpi0dN
Month: October 2024
Highline College Busn 218 Advanced Excel Fall, 2024 Introduction
For Fall 2024 matriculating students at Highline College in Seattle, Washington: this is the introduction to the class. For non-matriculating students, the class is free here at YouTube: https://www.youtube.com/playlist?list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW
Lookup Manager Name in Column Headers to Create Report: Excel Magic Trick 1866
Download Excel File: https://excelisfun.net/files/EMT1866.xlsx
Buy M Code Book at Mr Excel site: https://www.mrexcel.com/products/the-… or Amazon: https://www.amazon.com/Transformative… Mike “excelisfun” Girvin’s 4th book: The Transformative Magic of Power Query M Code in Power BI & Excel. Book about Power Query M Code to help data analysts transform and shape data into useful, actionable information for decision makers.
Topics in Video:
1) (00:00) Introduction
2) (00:55) Worksheet function to create column of employee names from a table using TOCOL and UNIQUE functions.
3) (01:30) Worksheet function to lookup manager names and join with a comma between each name using Continue reading “Lookup Manager Name in Column Headers to Create Report: Excel Magic Trick 1866”
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
Pdf file with video notes: https://people.highline.edu/mgirvin/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 Continue reading “Excel 365 to Make Your Teaching Job Easy: Dynamic Spilled Arrays, XLOOKUP, Power Query & PivotTables”