Excel Project

This was the first Project i had to do for my ISM3004 Class. After watching several lectures introducing me to Excel and some of its advanced features i had to get my feet wet and experience a practical project. This project was about a Gymnasium that had measured and gathered information about its clients, specifically their age, gender and their heart rate. The owner of this Fitness Center hired us for helping her analyze the data mentioned.
The first part of this project was purely visual and very simple, we had to organize the data , bold some texts, center them and reshape them.
Later on we had to start using certain in built functions of Excel to do the task we were told to do. For example we were asked to search for the Highest Heart Rate of every customer. To do so, we used a very simple but powerful function named LARGE.
Moreover, we also had to use conditional statements in this project, the same that you use in programming. We had to use them for Printing out Yes or No in a cell depending if the client had accomplished the Target Heart Rate.
Furthermore, we could experience with relative and absolut addresing and mixing them both. We used this when we had to calculate the target Heart Rate using a constant percentage value of the Maximum Heart Rate.

Finally after gathering all that information we had to use the famous pivot tables to help us analize the data and count it all up. We had to do two pivot tables one which counted all the people by gender who could accomplish the target heart rate and the ones who did not. The other pivot table had to calculate the average heart rate increase from the beginning of the workout and when it finishes.


Here is a screen capture of my "AvgIncrease" Pivot Table:

GO GATORS!!