We can use Excel to keep track of multiple projects and get their status. Use this dashboard to create professional looking project status reports, project portfolio status reports with ease. Read more to learn how to.
Another powerful feature of Excel VBA is to interact with Other Applications - Examples to deal with MS Word, PowerPoint, Access, Internet Explorer,etc.
I believe, one should ever use LOOKUP functions is you might not know how to use INDEX-MATCH or you might be working with beginners or freshers who sort of understand VLOOKUP but who know nothing about INDEX-MATCH. If that’s the problem, I hope this post will help.