All articles with 'condtional formatting' Tag
This is part two of our three part series on how to analyze half a million customer complaints. Read part 1 here.
Analyzing Regional Trends
As introduced in part 1, our complaints dataset has geographical information too. We know the state & zip code for each complaint. Please note that zip codes are partial or missing for a 10% of the data.
In this article, let’s explore three ways to analyze regional trends.
- Regional trends by state, product & issue
- Complaints per million by state
- Complaints by zip code
Jennie, a sweet and ambitious lady set out to do 101 things in the next 1001 days. She took the inspiration from Day Zero Project. Not stopping there, she prepared a cute little excel sheet to keep track of all these new year resolutions and sent it to me.
I think this is a swell excel template if you want to keep track of your goals or new year resolutions or just manage a list.Continue »
Here is tricky scenario, faced by Basil, our forum member, “I want to have Excel display a wing ding check mark when a user types “y” in a cell. I have been trying to do a substitute formula but putting the symbol in an unused portion of the spreadsheet and calling it to the selected cell but I can’t get it to work. Any thoughts?”
We can use either cell formatting or conditional formatting to achieve this.Continue »