Part 2: Advanced

Total Class Time: 6 Hours
Next Session: March 20&21 (2-5pm EST)
Live on Zoom

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

Part 1 (or you will be lost)
What you need to attend: PC or Mac with Zoom
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.

Day 1 (3 hours)
Tables Make Life Easier
  • 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
Excel Makes Decisions
  • 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
Day 2 (3 hours)
  • 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
And save 20% off ticket price.
*Early Bird ends November 20th
Buy this Template