Friday, October 1, 2010

Excel Project

     For this weeks assignment, we had to do an excel project. Excel is super tricky but very useful. In the project we were required to complete multiple tasks. First, we had to make some new rows. In these rows we had to use basic formulas, such as addition, subtraction, multiplication and division to get data such as percentage hart rate increase, change in heart rate and others.Next, and the part that got me, was calculating the percent heart rate increase. This was difficult for me because I could not get the division to work. After about fifteen minutes of trying I realize the column is in a percentage format and that's why it wouldn't give me an appropriate answer.
     After that we were required to make some pivot tables. I was fairly familiar with excel functions, but pivot tables are something completely foreign to me. I had to re watch about half of the first lecture on the tables to finally understand how they worked. After that the first table required you to show how many men and women reached their target heart rate. The second table showed the demographics and how well the reacted to the course.
     The skills I learned during this project were mostly attributed to the pivot tables. I'm not really sure how long these have been around, but they are very useful. They can give very important data, summarizing many rows and columns in one cell block. Also, it was nice to get a refresher on the functions. All in all, I thought the project was perfect, just enough to teach you what to know, but nothing overboard and super difficult.


No comments:

Post a Comment