Dashboard 101 – Essential MS Excel Formulas

Essential formulas for dashboarding

Formulas play a very important role in dashboards—they are the processing engines for various tasks; and often the only processing engines in case of only formula based dashboards. MS Excel has a robust collection of formulas, varying from mathematical to financial to statistical to string manipulation. While all of these are not relevant for all the dashboards, the following four types of formulas are used extensively in developing almost every MS Excel dashboard:

Reference Formulas

mathematical and statistical formulas

string manipulation

We have explained the basics of these formulas in the sections above—this  should be good enough to get you started on your first dashboard. Plus each section has a sample workbook with examples for formulas that you can download to get a better understanding about applying them.

As always, please feel free to contact us at query@crabsheet.com for any queries that you may have on formulas and we would be more than happy to help you.


Have a question? just leave a comment and we will answer A.S.A.P