Excel Tutorial: Using Conditional Formats for Traffic Lighting
April 12th, 2008
Simplicity is key when presenting statistics to management or customers. Data analysts are often tempted to put as many details as possible on the standard “one sheet” template; however, too many numbers on a page can cause confusion about where to initially focus. When reducing the number of statistics on a page is not an option and summary stats are not appropriate, traffic-lighting is a quick and effective method to highlight trends or draw attention to information that need to be addressed.
Continue »
Popularity: 13% [?]
Topics: Tutorials | 1 Comment »