Excel Tutorials

A collection of step-by-step tutorials that will help you master Excel from the ground up. Start with the basic operations, learn how to navigate excel spreadsheets with ease, and build up your practical knowledge with advanced Excel functions, such as INDEX and MATCH; VLOOKUP and MATCH; INDIRECT, VLOOKUP and INDIRECT.

Useful Articles

INDIRECT Excel Function: how to apply it and combine it with VLOOKUP

INDIRECT Excel Function: how to apply it and combine it with VLOOKUP Feel free to download our Exercise file and practice along with the video. And don't worry, there is also a Solution file with all the formulas. We have more explainers on advanced Excel functions you might be interested in...