Introduction
What is the most used tool in the data industry? You may have guessed it from the title of the article: is excel. It is, with much, the most used tool for several reasons. User interface / simple user experience so anyone can get started, great features for easy statistical and exploratory analysis and near universal availability make it a must-have in your repository.
But nevertheless, not many people realize the power of Excel. Sometimes, it is surprising to see people using R / Python for simple business and financial analysis, simply because they are not comfortable with Excel. They don't realize the power that pivot tables can deliver, conditional formatting and simple formulas. Check out this article for some of these tricks: Simple but powerful tricks for analyzing data.
With that in mind, we thought we would share a cheat sheet for Excel formulas and shortcuts. Cheat sheets are shown below!!
Here is the cheat sheet for all the shortcuts (in Windows):