Working on this Excel project truly was a pleasurable experience. I have always enjoyed working with Excel but have never learned to work with pivot tables. I think that having this skill in my bag of tricks will help me out immensely in the long run.
The project required me to manipulate and analyze data from a study of men and woman's heart rates while exercising. I added rows, created formulas, edited fonts and sizes, and created two pivot tables. As I mentioned before, I am new to pivot tables so I spent the grand majority of my time understanding the utilities of this tool and finessing the results shown in my tables.
Screen capture of a pivot table
This past summer, I did a lot of work in Excel with data of a research study conducted. I spent hours crafting complex functions to get specific results out of the information. If I had know pivot tables existed, I would have saved myself hours of racking my brain! With pivot tables, nevermore will I struggle with data analysis!
No comments:
Post a Comment