The Excel project was a very interesting and fun way to apply all that I've learned about Excel. We were given step-by-step instructions to edit and analyze data from a fitness center research experiment. I was able to learn different functions and commands that I hadn't been previously aware of, simply by clicking around and using the Help application. I had never used Freeze Panes before, and although the concept was quickly understood, I needed to refer to the Excel Help discussion board to figure out how to freeze the top two rows as opposed to just the first row or the first 14 rows. This function can come in handy often with large amounts of information, so you can see the labels that you have allocated each column without scrolling up every time you get confused or forget.
I had been taught all about Pivot Tables in the Excel lectures for the scavenger hunt, however I had never before actually applied the concept. It is a very useful and convenient way to summarize and analyze data of any amounts. You can quickly change one aspect, such as sum to average, to look at your data in a completely different way. It is a very customizable table, with the option to show or not show various labels and/or totals. Through the process of completing this project, I also came across information that will help me in everday life. A person's maximum heart rate = 220 - their age. Therefore, my maximum heart rate is 199. All in all, this project was extremely useful and fun to complete, and made me further appreciate and want to use Excel whenever I am dealing with data, or charts of any kind.
No comments:
Post a Comment