EXCEL PROJECT

For this project we were told to organize data for our “boss” the owner of a fitness center. The owner wanted information on the customer's heart rates, target heart rates, maximum heart rate and whether or not the heart rate was achieved. The owner also wanted a few Pivot Tables to analyze the data and to use as a quick guide. Below is a screen shot I took of one of the Pivot Tables I created so that the owner could see the average percent increase in the subjects heart rates divided by age group and gender.

To complete this project I had to learn a few new techniques from Excel. Three of the techniques that I learned and felt to be the most useful were...

1) Using the Freeze Panes

2) Learning how to use the Pivot Table

3) Learning how to create an Absolute Value in Excel formulas

I couldn't believe how easy it is to organize data using Pivot Tables. Also, how professional and organized a chart can look by using something as simple as Freeze Panes. The absolute value in Excel formulas was a great new tool to learn about too. Before, trying to type out 30 different formulas was a real problem, now I just type it in once with the absolute value and then copy and paste! This project opened my eyes to the crazy amount of things you can do with Excel...I really think that these techniques will be valuable tools I can use in the future.