Thanks to everyone who came out for our meeting! Here is a brief summary:
a) Dulton walked us through some of the finer points of the select tool. Key takeaways were the power of saving and loading field configurations and that the select tool can remove prefixes/suffixes that are part of multiple field names. The options menu has a lot of power!
b) Kenda showed some examples of the multi-row formula tool. She showed how to fill down a field, fill up a field, as well as do a grouped-by recordID. I've attached her workflow.
c) Digan worked through some lesser known functions in the filter tool. You can use the startswith/endswith formulas in lieu of the more verbose left and right functions. I also showed the power of the IN/Not In functions. Then I demonstrated the 3 Boolean operators and their code counterparts. I've attached the workflow.
AND && OR || NOT !
Thanks for the brownies @Kenda