‍Topics: structured formulas, dynamic tables, advanced logic (IF/AND/OR) INDEX-MATCH, XLOOKUP, simple macros, and crash-proofing for the future

Prerequisites: Part 1 (or you will be lost)
What you need to attend: PC or Mac with Zoom
Materials: available for download
‍
Participation: Questions are welcome. We'll also have several hands-on exercises to do during class.
‍
Recording: Will be available after class so you can review the material and exercises.

• Dynamic Tables automatically expand when you add more data
• Structured Formulas make formulas even easier to read
• Troubleshooting complex formulas
• Calculating tricky subtotals with the ANYTHINGIFS functions

• An easy way to approach complex IF THEN scenarios
• Using IF/AND/OR functions together as a team
• Using the IFS function for long logic chains
• Using Conditional Formatting to automatically color certain cells
• Using our new knowledge to solve advanced data problems

Beyond VLOOKUP

• The limitations of VLOOKUP and how to make it more reliable
• The infamous INDEX/MATCH and advanced lookup techniques
• The new amazing XLOOKUP
• How to keep large spreadsheets from getting slow
• How to handle annoying error messages in your formulas

Now we are Advanced

• An introduction to Power Query which can clean an impossible dataset
• Using simple macros to automate repetitive tasks
• Creating calculated fields within our Pivot Tables

• Putting it all together with a fun real-world project
• What to do with all of your new free time now that you're no longer fixing garbage spreadsheets