This blog post came about as the result of my own incompetence. I made a rookie error – FORGOT TO PRESS RECORD….So this is an example of an exercise I would use in class. You can download the completed file here.. and if you are feeling full of enthusiasm – you can download the uncompleted file here
- Meet Aggregate – the function that helps you wrangle hidden rows and subtotals in your formulas..
- How to identify total of top three scores
- Creating a KPI Dashboard – Part Five – Putting it all together in our dashboard
- Creating a KPI Dashboard – Part Four – Putting together our annual stats
- Creating a KPI Dashboard – Part Three – Preparing our monthly stats