<

Watch Creating an Efficient Dashboard in Excel

Posted on
8,874 Points
1,774 Views
41 Endorsements
Last Modified:
Published
Experience Level: Beginner
9:31
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data.

Rather than update each graph to point to a different set within a static set of data, try creating a dynamic set that will update for you!  This video will show you how.
41
1 Comment

Expert Comment

by:MEGlobal
Because of the size of the spreadsheet in the video, I was unable to see what was being entered, both data and formulas.

Is there a way to make the spreadsheet in the video full screen?
0
This is for people with spreadsheet skill, but not necessarily yet book-keeping skills, which with this “starter template” will give you the lists headings and a few fairly simple calculations you need to get going. 
Provides a one size fits all solution for File Dialog calls for all MS office applications. Module contains function fncGetFilePathTRM() which does all the filter building for you. I've used a similar version of this for over 15 years, 1 module impo…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month