March 10, 2022
So I've been tasked with creating a dashboard. I\'m pretty decent in Excel not great or masterbal. Anyway I need to do this I have 35 metrics that I need to put on there. The metrics are all okay. Could be formally driven or just an letter grade. I\'m trying to take as many online classes as impossible but I am freaking out. Advice? I have one month to get this done. I work for a plasma donation center. So there is no revenue, just volume
July 16, 2010
Welcome to our forum! That's a big task ahead of you, but not impossible
35 metrics is a lot to fit in a one page dashboard. Maybe Sparklines could be of use. Also Conditional Formatting is handy for in-cell graphics. You could convert your letter grades to numeric equivalents so they're more easily plotted in charts e.g. A = 5, B = 4 and so on.
If you think you have time to take a course, please consider my Excel Dashboard course.
Hope that gives you some ideas.