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 advanced concepts in automating. We'll discuss complex workflows commonly stuck in manual spreadsheets, impeding productivity and crowding 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. Audience can send in questions for special use cases and problems to solve as a group.

3rd Tuesday, 10am to 11am PST

Agenda Schedule:

Feb - Automation Stages with Excel - Visualizing the strategy behind our spreadsheets 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 - Meeting cancelled
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) - The One with all the Favorite Tips and Tricks

AGENDA:
10:00 AM: Sign-on, catch up, and network (virtually)
10:15 AM Topic: Continued SQL Approaches
10:50 AM: Q&A and Social, sign-off