Excel Project

For this project, we used the Excel program and acted as if we worked for a large fitness center. The owner gave us an Excel spreadsheet containing data that was collected from 500 subjects that included their heart rate measurements before and after the 15 minute workout and during the 5 minute cool down period. The sheet had raw data that included age, sex and 21 heart rate measurements from 0:00 to 20:00 minutes. Some of the tasks I performed included manipulating and formatting the raw data, creating formulas, analyzing data and making pivot tables.

Doing this project was very interesting and very helpful in building my excel skills. Previous to the Excel Scavenger Hunt, I had no experience with the program. The scavenger hunt gave me basic knowledge and understanding of how to use the program, but the project gave me an opportunity to actually put my skills to the test and I honestly enjoyed it. For example, my notes on the pivot table did help but in actually creating it correctly with formatting the numbers, rows and columns, it was more thought that needed to be put into it. Also, we had to come up with formulas, so I not only had to remember the rules for inserting the formulas, but I had to focus on the information for the correct formula. In all, the excel project was a success for me and I now have another program to continue to use and add to my resume!

Week: 9 Clear, Excel

This week's lectures were all about Excel. This is something that I have always wanted to perfect but it has still been a work in process for me. I learned a little along the way. However, the information that I learned this week was the most valuable information about the program that I have had in a while.

Excel is a spreadsheet that can be used to track data, create inventory lists or perform mathematical functions. The main aspects that I will concentrate on are the function capabilities that can be used at home or at work. Every function in Excel must begin with the equal sign. The link shows a list of the worksheet functions by category and a short description of each. This tells Excel that a function will be performed. After the equal sign, you can either add, subtract, multiply or divide. These are the basic mathematical functions that can be performed with Excel. Addition can be useful when needing to calculate dates and things along those lines. Some other very interesting piece of information I learned throughout this week's lectures was how to use pivot tables. This tool can make life so much easier because you can move quickly and easily through your work without any hard labor. A new pivot table can be created in just minutes unlike having to manually build a report by entering formulas and arranging columns from a sheet of data. It gives you the ability to create many different pivot tables and reports from the same sheet of data.

Learning to use Excel can be very beneficial in any type of business related career because it allows you to do anything that you need to do. You can use it for dates, calculations, scheduling, planning budgets and so forth. I really plan on learning more and more about the program because I'm sure going to need it.

Enjoy Spring Break fellow bloggers.