Our very own MP Community Member, Glenn Wood from Seacoast, is back to teach MS Excel techniques on an Intermediate to Advanced skill level. We'll unpack the new XLOOKUP and other functions, Absolute and Relative cell references, working with dates, and show the power of Pivot Tables to better analyze your data.
A downloadable handout and a sample Excel file are linked below.
02:15 - Introductions
05:00 - Fill Handles
07:40 - Cell References
10:35 - XLOOKUP
19:55 - SUMIF and SUMIFS
23:00 - Subtotal and SUM
25:00 - Unique List
27:30 - Tables
29:19 - Pivot Tables
35:15 - Non-Office 365 Tips
38:10 - Q & A (aka Stump the Excel Guy
