As an Excel beginner, I took the time to watch and take notes on the lecture videos as well as watch tutorial and how-to videos on the Web. I referenced Excel's help option when I was confused about a step, and was able to work through it using the program's own tools. The task to organize a spreadsheet of data concerning a 20 minute workout interval for 500 people was lengthy but worthy. The information was arranged by subject gender, age, heart rate, target hear rate, highest heart rate and time outputs for each minute.
I learned how to create, replicate and work with formulas by creating new columns of data interpretation. Simple formulas like summations and finding maximums were easy to apply, while the logic test formulas were a bit more challenging, but even more useful. In working directly with formulas, I was able to realize their relevance as an effective tool.
Pivot tables were used to separate and further delve into specific portions of the raw data. They were difficult to understand at first, and I had a hard time figuring out how to tell it where I wanted the information to be derived from, but once I did, everything came together. They organized my information neatly and could calculate practically anything imaginable. Though Excel isn't the simplest program to learn over night, it is definitely crucial in the business world to keep data neat, organized and to save time and money.
Below is a screen capture of one of the pivot tables I created to show the average increase in heart rate among females and males, displayed in ages grouped by decade.
No comments:
Post a Comment