This is a template that I used today in working through a statistics problem. In the video we will cover -finding the greatest and smallest values in a range with MAX and MIN-a simple IF statement-conditional formatting across a selection of cells (advanced! few analysts know how to do this).
Checking for data accuracy is tricky in Excel. In this blog, I have been presenting some of my tips. This is a great one for more visually-oriented users. We have a simple inventory model below. Even in this simple model, there are many formulas, dependent cells, and inputs. How is the shrink calculated? Did someone hard-code the […]
Conditional formatting is a great tool in Excel. It sounds fancy, but if you’ve ever color-coded anything before, you know how conditional formatting works. Given the rules you provide Excel, it will format things accordingly. Many conditional formatting features have been added to recent editions of Excel. My favorite is the Color Scale. This feature allows you to look […]