{"id":10,"date":"2018-10-07T17:56:18","date_gmt":"2018-10-07T22:56:18","guid":{"rendered":"https:\/\/my.dev.vanderbilt.edu\/scheibzr\/?p=10"},"modified":"2018-11-23T15:40:59","modified_gmt":"2018-11-23T20:40:59","slug":"excel-like-a-champ-pt-1","status":"publish","type":"post","link":"https:\/\/my.dev.vanderbilt.edu\/scheibzr\/2018\/10\/excel-like-a-champ-pt-1\/","title":{"rendered":"Excel Like a Champ pt. 1: Introduction to Excel"},"content":{"rendered":"

Hello all, and welcome to my first blog page ever!<\/u> Really exciting stuff going on here. If you found my blog, I assume this is because you also want to excel like a consumer research pro. Let me give you some background on myself and what I want to do here.<\/p>\n

 <\/p>\n

I am currently a consumer research intern at Country Music Association (CMA), a job that heavily relies on excel to do, you know, the actual research part of the job. Before I got this job, I had extremely basic excel skills, and I took this job so I could become much more efficient at using excel. I figured that I would take you guys along with me for the journey, and teach you ways to also be an excel pro as I become one myself. The main goal here is for us together to become proficient in excel in terms of being able utilize shortcuts and other functions, be able to input large amounts of data in a short amount of time, and to be able to easily do inferential statistics like median, averages, percent changes, etc. Additionally, we will also explore how to use these tools to essentially analyze the data. <\/u><\/p>\n

 <\/p>\n

I know this doesn\u2019t sound like the most exciting topic in the world, but it is extremely useful for young professionals to understand these tools, and we are going to make this FUN!<\/u><\/p>\n

\"giphy\"<\/p>\n

I am going to do multiple blog posts, each trying to explain new excel skills that will be useful for you guys. For this first post, I really just want to set up what we are doing, and allow you guys to get comfortable with excel. Each of these posts is going to build off of each other. If you have any questions, or need additional explanations, feel free to leave a comment in the comment section, and I will respond and try to help explain things you don\u2019t understand as best as I can. Phew, now that all of that background information is out of the way, LET\u2019S BEGIN THE FUN!<\/p>\n

 <\/p>\n

I want everyone to go ahead and open a blank excel sheet. We are going to pretend you are working on a project where you are tracking several artists\u2019 song sales over the course of the past 5 days (bear with me- we are going to use this situation to the actual functions make more sense and give them some context!)<\/p>\n

 <\/p>\n

To set this up, starting at cell A2 going down the column to cell A4, input \u201cArtist 1,\u201d \u201cArtist 2,\u201d and \u201cArtist 3.\u201d Then, starting at cell B1 going across the top row to F1, label it \u201cDay 1,\u201d \u201cDay 2,\u201d \u201cDay 3,\u201d etc. (Pro tip:<\/u> you can click on the cell and look in the top left corner and it will tell you the name of the cell if you still need to get use to this. Just remember that the letter on the top of the row comes before the number on the column). For row G1, put the label \u201ctotal,\u201d so we can keep track of what all the data is. Now that all of our labels are set up, I would select all those cells and bold it, so we can easily separate the labels from the actual data.<\/p>\n

 <\/p>\n

Now we need some actual data to play with. For the purpose of this tutorial, we are going to use fake, but simple data, to manipulate. Please enter the following data into your excel sheet:<\/p>\n

 <\/p>\n\n\n\n\n\n\n
<\/td>\nDay 1<\/strong><\/td>\nDay 2<\/strong><\/td>\nDay 3<\/strong><\/td>\nDay 4<\/strong><\/td>\nDay 5<\/strong><\/td>\nTotal<\/strong><\/td>\n<\/tr>\n
Artist 1<\/strong><\/td>\n10<\/td>\n15<\/td>\n8<\/td>\n9<\/td>\n20<\/td>\n<\/td>\n<\/tr>\n
Artist 2<\/strong><\/td>\n21<\/td>\n10<\/td>\n8<\/td>\n8<\/td>\n7<\/td>\n<\/td>\n<\/tr>\n
Artist 3<\/strong><\/td>\n12<\/td>\n11<\/td>\n5<\/td>\n4<\/td>\n8<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

You can leave the total columns blank for now. If you were like me even three weeks ago, I would have pulled out a calculator to add up all of those numbers to then manually input it. But that is why you are here. We are going to learn how to do these things by utilizing the actual functions on excel, which will make your life so much easier (especially if you are dealing with 100s of cells of data).<\/p>\n

 <\/p>\n

This may seem like a lot and be very overwhelming for right now. So I want to give you guys the chance to just play around on excel. Weirdly enough, just having free time to mess around on excel made me a lot more comfortable with it. So I am going to give you homework (don\u2019t hate me for this!): before you read the next blog post, spend at least 30 minutes on your own playing with excel, using the different tools and functions. It is TOTALLY FINE if you aren\u2019t doing it correctly or don\u2019t even know what you are doing. I really just want you to feel comfortable being on excel, or to even look at an excel page and not be overwhelmed, something that happened to me a lot.<\/p>\n

 <\/p>\n

Complete this homework whenever you have time, and then check back in for an update with another blog post, and together, we are going to learn to be excel pros.<\/p>\n

 <\/p>\n

Love you guys as always,<\/p>\n

 <\/p>\n

Your favorite excel teacher, Zoe<\/p>\n

\"giphy\"<\/p>\n","protected":false},"excerpt":{"rendered":"

Hello all, and welcome to my first blog page ever! Really exciting stuff going on here. If you found my blog, I assume this is because you also want to excel like a consumer research pro. Let me give you some background on myself and what I want to do here.   I am currently…<\/p>\n","protected":false},"author":7897,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-10","post","type-post","status-publish","format-standard","hentry","category-news"],"_links":{"self":[{"href":"https:\/\/my.dev.vanderbilt.edu\/scheibzr\/wp-json\/wp\/v2\/posts\/10","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/my.dev.vanderbilt.edu\/scheibzr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/my.dev.vanderbilt.edu\/scheibzr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/my.dev.vanderbilt.edu\/scheibzr\/wp-json\/wp\/v2\/users\/7897"}],"replies":[{"embeddable":true,"href":"https:\/\/my.dev.vanderbilt.edu\/scheibzr\/wp-json\/wp\/v2\/comments?post=10"}],"version-history":[{"count":7,"href":"https:\/\/my.dev.vanderbilt.edu\/scheibzr\/wp-json\/wp\/v2\/posts\/10\/revisions"}],"predecessor-version":[{"id":45,"href":"https:\/\/my.dev.vanderbilt.edu\/scheibzr\/wp-json\/wp\/v2\/posts\/10\/revisions\/45"}],"wp:attachment":[{"href":"https:\/\/my.dev.vanderbilt.edu\/scheibzr\/wp-json\/wp\/v2\/media?parent=10"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/my.dev.vanderbilt.edu\/scheibzr\/wp-json\/wp\/v2\/categories?post=10"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/my.dev.vanderbilt.edu\/scheibzr\/wp-json\/wp\/v2\/tags?post=10"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}