Note: This will be the first in a series of downloadable tutorials. Each tutorial runs in a self-contained browser with all files and software embedded [where legal]. If you would like a specific topic covered, please leave a message here.
Download: Mirror#1
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.
Included:
-Example Excel File
-Full tutorial
0 Responses to “Excel Tutorial: Using Conditional Formats for Traffic Lighting”
Leave a Reply