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:
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 firstname.lastname@example.org for any queries that you may have on formulas and we would be more than happy to help you.