Formatting the worksheet to be ready for printing also was a breeze with the helpful steps outlined in the project. I had always spent much more time than needed when getting ready to print out an excel worksheet. With the tools we learned in the lectures it was easy to go into page setup, set the page to landscape, and then decide on the number of pages wide for the worksheet to fit onto. Adding a header and footer was a simple process as well. I think being better acquainted with the ribbon bar across the top of excel is helpful, it was easy to utilize the page layout ribbon and choose how the worksheet should be printed. Now knowing about the “print titles” tool on the page layout ribbon is a life saver as well.
While working through this project I would have to say the area I really did start from scratch in and learn the most was the pivot tables section. I was a little intimidated at first, but after watching the lecture on pivot tables, I was able to navigate through step two without a problem. Using a pivot table is a skill that will definitely come in handy. Being able to analyze the data in such an organized fashion and quickly is great. One small key to the pivot table which I found to be a bit hidden is how to summarize the data. When I was coming up with the average increase in heart rate for the subjects, excel automatically summarized the data as a sum. After a bit of searching and recalling the summarize data default discussed in class I was easily able to right click on the highlighted data and change the data to be summarized by average. Hopefully I will be able to use this skill and all the others learned throughout the project in the near future!