Excel is one of those things you can spend a lifetime trying to master everything it can possibly do. Luckily you don’t need to know everything Excel can do to get a lot out of it.

I work with a partner now who is known to make the claim that Excel is the world’s largest Enterprise Resource Planning (ERP) system.

Also, I can tell you when I started in business school at Kellogg, we used two fancy macro workbooks to run sophisticated statistical analysis until they shifted to having everyone use STATA.

STATA was/is infinitely better than Excel, but you’d be amazed at what you can do in Excel, with a little bit of coding know-how.

This post is about the Excel formulas, though – the little statements you type into a cell to make magical things happen.

Read on to dive into the ten Excel formulas you need to know and love to…excel as a consultant. [Read more…]