Thursday, September 30, 2010

Excel Project

I just finished the Excel Project and in the end it was great to learn different skills that I had not been familiar with.  One that was extremely helpful was learning how to search for functions.  I simply typed in what I was looking for in the excel search for formulas and then excel helped me through the whole process.  Previously, before knowing about this, I would try to come up with functions and try to remember the parameters myself.  With the search process all you have to do is click on the function button to the left of the formula bar.  Once in the search box, you type in what you are trying to find and then excel comes up with different function possibilities.  Once you choose a function, excel then helps you type in the parameters.  The whole function process is no longer as scary as I had always thought.
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!


No comments:

Post a Comment