All articles with 'condtional formatting' Tag

Analyzing half a million customer complaints – Regional Trends [Part 2 of 3]

Analyzing half a million customer complaints – Regional Trends [Part 2 of 3]

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.

  1. Regional trends by state, product & issue
  2. Complaints per million by state
  3. Complaints by zip code
Continue »

A New Year Resolutions Template that Kicks Ass

Published on Jan 7, 2010 in Charts and Graphs, excel apps
A New Year Resolutions Template that Kicks Ass

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 »

How to get tick marks in Excel? [custom cell formatting]

Published on Sep 15, 2009 in Excel Howtos, Learn Excel
How to get tick marks in Excel? [custom cell formatting]

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 »