Best Excel Shortcuts Everybody Need to Know

Almost everyone uses Excel in some form or fashion in the modern workforce, but many of us may be wasting a little too much time trying to format those pesky spreadsheets. In order to help you work a little bit faster, or maybe more efficiently, we have assembled 40 of the best Excel shortcuts that you need to know!
Continue reading “Best Excel Shortcuts Everybody Need to Know”

VLOOKUP vs INDEX/MATCH

Once you have mastered VLOOKUP in Excel it’s time to move on to INDEX/MATCH. This formula combination is far superior to¬†VLOOKUP.

The limitation of Vlookup is you can search only for the values on the right to your search word or number. also the result of Vlookup is very sensitive if you decided to insert (or delete) a column in your dataset because the column numbers are hardcoded. Index/Match formula combination seems to solve all the above limitations and offers far more flexibility and possibilities.
Continue reading “VLOOKUP vs INDEX/MATCH”