Top 10 Formulas for Aspiring Analysts by Purna “Chandoo” Duggirala.
From the post:
Few weeks ago, someone asked me “What are the top 10 formulas?” That got me thinking.
While each of us have our own list of favorite, most frequently used formulas, there is no standard list of top 10 formulas for everyone. So, today let me attempt that.
If you want to become a data or business analyst then you must develop good understanding of Excel formulas & become fluent in them.
A good analyst should be familiar with below 10 formulas to begin with.
A reminder that not all data analysis starts with the most complex chain of transformations you can imagine.
Sometimes you need to explore and then roll out the heavy weapons.