Many of us have to use Microsoft Excel on a daily basis, and there are some excellent techniques one can pick up with a lot of Excel experience. As a numbers guy and data analysis guru, I think Excel is a very powerful program, and have decided to list some of the features I use on a daily basis in this blog. Maybe it can help some people.

1) The VLOOKUP function is one of the most useful formulas when working with multiple data sets. It allows you to introduce data points from...