Sunday, February 13, 2011

Excel Project

      In this excel project you had to analyze an excel spreadsheet with data, from a fitness center owner, that measured 500 subjects starting heart rate and there heart rate each minute through a 15 minute workout, then each minute during a 5 minute cool down. The data contained there age, sex, and 21 heart rate measurements.
     The skills you had to use to analyze this data included properly adjusting the headings and data, adding new columns and label them correctly, inserting formulas accurately to apply to the correct columns of data, format the worksheet to the right specifications for printing, and insert pivot tables into new worksheets.              The main skills I learned during this project were inserting the formulas and pivot tables. I now fully understand how to format the formulas so they apply to the correct data. I also learned how to use pivot tables and how they can help you to more easily read and organize a whole lot data. Overall I am a lot more knowledgeable about the "in's and out's" of excel.





     

No comments:

Post a Comment