Excel Project

The project that i completed was a great example of how excel s a vital tool in a real life business. The scenario for my project was that an owner of a large fitness center is researching 1000 members who's heart rates were measure over a 20 minute period. She wanted to run a study on them to see if they hit peak heart rate targets or not and what demographics performed better. Because of excels structure we were able to come up with numerous statistics for the population of our study and analyze much information using our results from all the calculations excel was able to compute in seconds whereas doing something like this by hand could have taken weeks to complete!

As a result of completing this project i feel i have become reaquanted with Microsoft excel and can use it to perform various tasks in real world scenarios. Some skills i learned that i was not familiar with before were pivot tables and the if function. Using these 2 tools within excel opens up many factors and circumstances that can be accounted for within your spreadsheet. This project has helped me see the beauty of keeping data tracked in a spreadsheet for the opportunities to analyze the data with excel alone are amazing. As a result i am now going to take the use of excel in to very strong consideration when constructing my business.

Below is a screencapture of one pivot table i constructed along with a link to a good site for tips on excel.

http://www.exceltip.com/category.html