Dashboards are a great feature in Excel to make your spreadsheets come to life. Recently I have teamed up with a fellow Excel Enthusiast, Mynda Treacy on Excel Dashboards. While I specialize in Functions and Formulas, Mynda is an expert in Pivot tables. While I do have a few dashboard tutorials out there (Excel Dashboard Post, Mynda’s expertise takes it to the next level and I wanted to share this video with you.
She discusses Dynamic labels in dashboards, using GETPIVOTDATA and TEXT functions. It is very well done and will teach you something if you create dashboards frequently. Here is the video:
Mynda also has a Dashboard course which is incredible. There are over 10 hours of videos with tons of handouts, homework and spreadsheets to follow. This course is closed now but will open in Tuesday July 14th. When it opens I will send out a link to everyone that will give them 10% off.
If you want to read up more on her course now, it is at: http://www.mothresource.com/212-19-3-21.html