Excel Project

This week, we were assigned a project in Excel working on a spreadsheet for a large fitness company. The owner collected data from 500 subjects, measuring their heart rate every minute for 20 minutes.
From this data given, I was able to format the spreadsheet making it more organized and easier to analyze. I created formulas to calculate the Maximum Heart Rate based on each subjects age, the Target Heart Rate for maximum cardiovascular benefit for each subject, and show the Highest Heart Rate Achieved. This new data is able to tell the owner whether or not the subject achieved their target and if the exercise program was sufficient.

I have taken a computer class prior to this course, making me somewhat familiar with Excel and was able to navigate around. This course has taught me a tremendous amount of new tools like the IF, Max MIN formulas. I absolutely love how you can enter in one formula and apply it to all of your data instead of entering it in individually. I’ve learned that you can use Excel to store, manipulate, and graph data with different tables like the pivot table. Most importantly, I’ve learned that you can incorporate Excel in just about any project to organize data and make fast calculations. Excel makes life a whole lot easier in the business world! =)

This is my screen capture of the “AvgIncrease” Pivot Table.