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.
Tableau vs Excel is a hot discussion topic in the data science community. Indeed, Excel is not a top resume-building skill for aspiring data scientists. But it has been around for ages and you are probably familiar with tons of useful Excel tricks for data cleaning and analysis. Are you curious...
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...
