Excel Project

This week has been particularly demanding with the excel project. I considered myself to have been of moderate abilities with excel and now my skills have been tested to the highest degree. I have developed a much greater understanding of the us of pivot tables and how they are useful for the presentation of data in a much more user friendly format. I used to argue with my sister that has an MBA about the usefulness of Pivot tables, but I really see how they make the presentation of findings that much stronger.

The "IF" function is something that I never used before this class and I feel that it also greatly enhances that power of the findings in a data set. The ability to categorize data quickly into a "Pass/Fail" or any other group using the "IF" function makes the data set much easier to navigate and efficient at presenting information to a user.

The final hitch in this project was getting the page layout set to take up the entire landscape legal size page. I had to revert back to my excel scavenger hunt assignment to figure that one out. I tried to fit the document another way, and managed to get it to work, but I knew it wasn't how the teacher had suggested. I adjusted it to take 1page wide and 2pages long and it fixed the document.