May 132013
 

Photo on 3-13-13 at 8.45 PM #4This is so exciting, I almost put a cuss word in the subject line! This deserves a cigar so, please join me.

For the past few months I’ve explored possibilities with Excel and the internet. I even took a PHP/MySQL course and what I discovered is that being in the almighty cloud isn’t easy unless you’re a developer. This morning … WOAH! I learned more about ExcelWebApp and that slicers and pivot charts can be used. This has been possible for at least 3 years.

Below are 2 pivot charts and some slicers for you to play with. YES! It’s interactive. Now, don’t you feel so excited that you want to cuss?

The charts are driven from hypothetical customer service reps who’d been graded in January, February and March. The data can be sliced and diced along the Months, Issues, and Average Scores. If you dig in, you can

  • Compare Rick, Elise and Rodney in February and March
  • Isolate the people who are averaging less than 3.00
  • See who’s handling Tech calls the best among Dan, Elise and Sarah
  • See if Rick’s overall averages are trending up, down or remaining flat?

Don’t be afraid. Scroll around, click on stuff and see what happens.

 

 

Please comment. Do you see this as useful for yourself? If so, how? What do you see as weaknesses?

 

 

Share Button

Oz du Soleil

I am Oz du Soleil. Data Mercenary and Excel Trainer. My courses have been described as informative, fun and they get people to relax about using Excel. I'm based in Chicago, a veteran of the U.S. Navy, and have a passion for custom-made hats, good bourbon, and spicy food.
 Monday 13-May-13  Posted by at 12:40 pm PST Excel Geekdom Tagged with: , , ,  Add comments
2 comments
AndyNathan
AndyNathan like.author.displayName 1 Like

That is really cool!

OzData
OzData moderator

@AndyNathan Thanks! Are you ready to jump in and start making dashboards? Hmmm ... ?


Trackbacks

Follow

Get every new post delivered to your Inbox

Join other followers: