Excel Project

The Excel Project was a great experience. We were asked to assist the owner of a large fitness center. The owner is researching the effectiveness of a particular workout. We organized data from 1,000 participants. We added additional columns with calculations including but not limited to maximum heart rate, target heart rate and highest heart rate.The initial tasks of cleaning up the spreadsheet were easy for me. Improving functionality as well as aesthetics were familiar to me since I have scarcely used Excel in previous jobs and a little more substantially in Managerial Accounting class; which exposed me to formulas and cell formatting. This is about the point in the Excel Project where things got kicked up a notch.

Bam! Pivot Tables. These have got to be the coolest feature I learned about during this project. This is where the data in data collection becomes even more usable. Pivot tables allow the user to make rows and columns of particular data from the master spreadsheet. We were able to find out how many subjects reached their target heart rate particular to their gender and which age demographic gained the most benefit from the exercise regime, grouping the age brackets in tens.

Excel is an obviously useful application for the business environment. One can collect, compare, manage or calculate data. Businesses can also use Excel to find patterns and trends enabling them to make more sound decisions. I am happy to have had the exposure to many of the capabilities of Excel. Here is a link to learn more about Excel and get help with Excel: http://office.microsoft.com/en-us/excel-help/.

Screen Capture of Ave Increase