Saturday, March 20, 2010

Excel Project

This week I worked on the Excel Project. To be honest, I thought that this project was going to be a lot more difficult and time-consuming than it actually was. Of course, there were several times when my frustration got the better of me, but I think this project was extremely useful. Not only did it require the manipulation of a "normal" table of data, (that which was featured in the "Raw Data" sheet), it also required the creation of not just one, but two(!) pivot tables. 
For me, the pivot tables were probably the most challenging since you had to place certain categories in either the row or the column, and then having to change from the defaulted sum to the average, or the count of the numbers. As I read through the discussion boards, I came upon the same problem as several other students where the percentages featured in the "Average Increase" pivot table (featured above) were in the thousands. After playing with the decimal places and the number formats for several minutes, I realized that I was using "sum" instead of "average." After switching, my numbers fixed themselves and I simply changed the percentages to one decimal place. I also decided to add a little color to the pivot table by using the "Pivot Style Dark 9" option under design. I thought this made the table a little more appealing and user friendly instead of being all white like the "raw data" table.
One reason that this project didn't seem that difficult was because a large portion of it was adding and manipulating a basic excel table. I actually found this part kind of fun because it included the usage of formulas. The formulas function of excel made calculating the data so much simpler, especially considering that there were about 500 rows of data! Also, the fact that this project was displayed as a real-life situation with the gym owner made me realize how useful Excel really is for a multitude of reasons. 

No comments:

Post a Comment