The Excel Project was a great learning experience. We received a file containing raw data pertaining to an exercise study. We were directed to reformat the data so it would be more aesthetically pleasing, comprehendible, and show a comprehensive analysis of the data. Due to the reformatting the data will be able to be printed out in an effective and comprehendible manner.
I utilized many different skills during the reformatting and analysis of the Excel Project. During the reformatting portion of the project I learned, used and practiced naming and renaming sheets, formatting fonts, centering, adjusting adding and removing rows and columns, applying freeze panes, applying and using the formula tab while creating different formulas, adding and subtracting decimal points (formatting numbers), and preparing the document to print.
In the second portion of the Excel Project I worked with pivot tables. I was directed to create to different pivot table analysis charts. One chart was on the “Target Heart Rate Being Achieved” and the other chart was on “The Average Heart Rate Increase” both had variations of male and female. During the creation of these pivot tables I learned how to select and insert the proper column and row headings within the table, as well as insert the proper data within the table. I also learned how to add and subtract decimal places within the pivot table (number formatting), as well as group different categories within the pivot table.
My Average Percent Increase pivot table
All in all this project was a great learning experience with a bit of real world work force application which was very helpful.
No comments:
Post a Comment