Mastering Excel with Data Hikers Pub Online Meetup

Mastering Excel Spreadsheets - Data Hikers Pub
This Meetup brings the spreadsheet community together to encourage mastery of Excel while exploring fundamental and intermediate concepts. All skill levels are welcome as we work together to help others build their skills so they can grow into advanced users.

We'll discuss workflows commonly stuck in manual spreadsheets, which impede productivity and crowd out more meaningful work. Python, SQL, AI, and related technologies will be introduced to provide a full landscape of options for business professionals determined to leverage IT best practices for solving business problems. The audience can send in questions for special use cases and problems to solve as a group.

3rd Tuesday, except for Dec. We are starting a time change to 12pm PST starting December.

Agenda Schedule:
Jan - Year Topic Review and Sharing Spreadsheet War Stories
Feb - Automation Stages with Excel - Visualizing the strategy behind our spreadsheet tactics.
Mar - What Everybody Should Know About Excel - Basics in a Nutshell
Apr - Key functions: V/H/Xlookup, Sumifs, Index/Match and their various use cases - Spreadsheet like it was a database!
May - Macros, VBA to Javascript to Python
Jun - To Be Decided by May
July- Data Centric Spreadsheets/Emerging Spreadsheet Technologies
Aug - Using Sumifs() for Data Centric Spreadsheeting
Sep - UX Design - Making Art Through Constraints
Oct - Let’s Make Excel Better (Community Addin Project)
Nov - Show and Tell, Spreadsheet Successes to Inspire
Dec (2nd wk) - Review of Newly Released Features

AGENDA:
12:00 PM: Sign-on, catch up, and network (virtually)
12:15 PM Topic: Main topic per above schedule
12:50 PM: Q&A and Social, sign-off
1:00 PM: Meeting end