Excel Project

           This week in ISM3004 we had an Excel Project due.  We were supposed to help an owner research the effectiveness of a particular workout by analyzing heart rates.   I just completed the project and learned many new things and tricks about excel.  It started off very basic.  Changing the title of the worksheet and changing the font were the first few steps of the project.  As the steps went on it got a little more difficult.  We had to "freeze" the first two rows which makes it a lot easier to analyze the data and see what each number is for without scrolling all the way up to see the column labels. "Freezing" is when the rows you select continue to stay on top of the page so when you scroll down you dont get confused with what each number is representing.

                      http://premiercoachingonline.com/2010/03/heart-rate-training/

            Next we found the Target and Maximum heart rate.  The Maximum Heart rate is found by subtracting the age from 220 and using the same formula for all of the cells in that column.  The Target heart rate was alittle more difficult to find.  We had to make a formula so the target heart rate was 80 percent of he maximum heart rate.

  Next we determined if each person had achieved their target heart rate by looking at their highest heart rate and seeing if it was greater than or less than the target heart rate.  We also determined how many males and females who achieved or did not achieve their target heart rate.   

Attached is a "screen capture" of the "AvgIncrease" Pivot Table I derived from my project.

Finally we determined by how much their highest heart rate increased compared to the orginaly heart rate taken at time zero

Completing this excel project is a fantastic way to get used to and understand the basics as well as some of the more complex projects you can create within excel