Trinity Days Workshops - Register Now!

I will be hosting three workshops over Trinity Days:

• Workshop#1: Excel (Monday, October 12, 10 - 12)
• Workshop#2: SPSS (Monday, October 12, 2 - 4)
• Workshop#3: Atlas.ti (Tuesday, October 13, 10 - 12)

We’ll be working in the best computer lab on campus (Seabury 205), eating some food, and working through some “real world” situations that require technical, software skills. There is no better time to start picking up these skills than while you are in college, where you can do this for free in a low-stress environment!

These workshops are for students from all skill levels (from those who would rather avoid learning new software to those who know a lot about the software at hand but want to learn how to apply software skills to real, problem-solving activities).

Please visit the SSC events page to read the flier and register!

What to do?

Trying to figure out what kind of chart to make? First, you have to figure out what you are trying to show (in other words, as one of my advisers used to say, "what kind of story do you want to tell?"). Try Juice Analytics' chart chooser. It gives you suggested as to what kind of chart you want and then provides you Excel templates in order to pull it off!

Excel hack

Like a lot of people, I think, I don't particular like the chart functions in Excel. But this Excel hack is so cool, and quite easy to do. My first attempt at doing this took about five minutes (see image to the right).

What is additional cool is that you can use the "conditional formatting" tool in Excel if you would want to make bars of a certain length different colors. I tried to color code the bars in my table by whether they were above or below the mean. Couldn't quite get it to work, but I'm still trying...