Thursday, September 30, 2010

Excel Project

The Excel project that I just completed was challenging, yet educational at the same time.  It forced me to learn skills that I otherwise probably wouldn't have taken the time to learn.  To sum up the requirements for this project... we were given a collection of data, and were instructed to make some changes to the existing data, as well as add to the data given.  We created formulas, changed numbers to percentages, and formatted the data to print in a specified manner.  We were also instructed to create two separate pivot tables, which were used to provide a summary of all of the information.  With the aid of the lecture videos, the Excel help discussions, and bit of common sense, I was able to complete all the tasks as required. 

I acquired several skills after the completion of this project.  I learned how to add columns and rows, to show specific data.  I also learned how to create different Excel formulas, in order to display information in various ways.  After I completed all of the requirements for the project, I was then able to format all of the information into a printable version which was easy to read and understand.  I think one of the more useful skills that I gained, however, was the creation of pivot tables.  Pivot tables are a great way to condense all of the information into just a few rows and columns, and sums up all of the important data onto one page.  They are very useful when presented with a very large amount of data. 

I now feel much more comfortable with navigating through Microsoft Excel.  This project was a lot of work, but will certainly be beneficial to me in the long run.  I have no doubt that in the future I will revisit what I have learned from this project, and put my newly acquired skills to practical use.



No comments:

Post a Comment