This final content-related post is dedicated the monster called statistics.  Although I took the required statistical analysis class here at Vanderbilt a couple of years ago, this topic continues to intimidate me as well as many others.  Today, I am aiming to learn and transfer the basic statistical functions as well as teach myself how…

Hi readers!  Ever wondered why people use Excel for non-numerical data?  Me too.  That is why this post exists.  Organizations around the world use Excel for the capabilities that it includes for qualitative data, but I have always been unsure how this is supposed to work for entries that are not amounts.  Thankfully, the internet…

Hello again!  Today we are going to tackle one of the most useful and one of the most powerful features of Excel, the pivot table.  In my experience, employers and companies most often use this tool to determine the importance of a large set of data.  In my summer internship, my supervisor actually requested that…

Good Monday morning!  I’m back more quickly than anticipated because, as promised, this spreadsheet journey is just as much a struggle as it is a success.  While I hoped to give a brief overview of Excel and then jump into a few helpful tools, I actually skipped over an important topic that I hoped would…

Hope you are having a great Friday afternoon!  I took some time out my day to learn a little more about lookup and reference functions because I actually encounter plenty of tasks at my internship in which these tools could expedite the processes. Vlookup I’ll start with the most relevant function called “Vlookup.”  Vlookup is…

Happy Election Day! Today, I am excited to share my first post with content.  This post is entitled “The Basics” because I hope to explore the tools from a high level and give a few tips of the trade that one must know before diving into more complicated techniques.  I will define the general terms…

Hello readers! Before I begin the blog, I think that it is important to discuss why it exists.  Here is my goal that I hope to learn through this blog: To better understand how to move data into graphics that improve organizational communication, I want to learn how to efficiently analyze complex data in Microsoft…