Excel Project

I found this project to be very difficult and confusing. After watching the lectures I felt that I would be able to easily complete the tasks in the Excel project. However, after starting I realized that the most beneficial tool for me was the scavenger hunt assignment. This is where I was able to find most of the formulas needed to complete the project.

The first columns that we had to make including MaxHR, TgtHR, Highest HR, Tgt Achieved and PctIncreaseHR didn't give me to many problems. I was able to find the correct formulas for these through the Excel scavenger hunt. Out of these columns, I thought the most difficult to fully understand was the logic formulas needed to get the "Yes" or "No" answers for the "Tgt Achieved" column. Now that I have done this project I feel I have a much better understanding of logic function formulas and how they work.

The most difficult part of this project for me was the pivot tables. I think part of my difficulty with the pivot tables came from the fact that I was using a Mac instead of a PC. I think the Windows Powerpoint for PC's is much easier to operate than it is on Macs. I spent a good 30 minutes trying to find how to even make a pivot table. Once I searched "Pivot Table" in the search bar I was able to find the function and figure it out. This project taught me many things including how to use formulas to get useful data, how to use pivot tables and how to properly scale the print page setup so that all of the columns will be on the same page.

Until Next Time,
Zack