Intermediate Excel: Lesson 3

Highly Advanced use of VLOOKUP to create a model that speeds up your work

Step by step Automation without VBA/Macros:

  • Using SUMIF, LARGE and VLOOKUP to set up an automatically updating calculation that can be used in reports (Set it and forget it automation)
  • How we can go even deep with automation and crunch 1 to 2 days work within a few seconds