Excel Project

The excel projects intention was mainly to apply the skills we learned during the Excel Scavenger Hunt. So the use of basic excels formatting and functions as well as Pivot tables.

In the first task we had to work on the given data and create new useful cells with the help of excel functions.  I made the first two rows bold and centered the gender column. In addition I froze the first two rows, as it makes it more convenient to scroll through the data.

After that I created several new cells that provide new data information.

·         Maximum Heart Rate (Max HR)

·         Target Heart Rate (Tgt HR)

·         Highest Heart Rate Achieved ( Highest HR)

·         Target Achieved (Tgt Achieved)

·         Heart Rate Increase (PctIncreaseHR)



Excel Sheet

With these new data it is now possible to give more informative information about the effectiveness of the new workout in the fitness center. To print these data, the printing layout had to be adjusted to make it fit to one page. In addition headings and footers where included for a professional look.

Pivot table

After that I created two Pivot tables which allow making analysis of different relations between data. As you can see in the table below, I separated the data into three age groups and then in male and female. The table clearly shows that the group 20-29 years and female has the highest “Heart Rate Increase” and the group 40-49 female the lowest. 

Overall this exercise should prepare us for the daily business in a company, where you often work with Excel. Especially the Pivot table function can save you a lot of time as you can quickly create new tables.