I found this Excel project to be extremely helpful. Excel will undoubtedly be an important asset when we enter the business environment. In fact, it has proved to be extremely helpful even now with school projects and various internships I have participated in. This particular project didn't necessarily demand a wealth of knowledge concerning Excel and its attributes, but it covered many of the basic tools and shortcuts that virtually everyone needs when completing tasks in Excel. The project started off simple enough, requiring me to rename certain worksheets and center some information. Quickly however it required us to utilize some of the other functions in Excel, such as the "Help" function. Of course, we could have just as easily googled how to "Freeze Panes" but that would have been just as helpful, requiring that we put to use our searching skills previously learned in this course.
What I liked about this project is that it did require us to put into practice everything that we've learned. Last week we watched several tutorial videos on how to properly and efficiently use Excel, but it's one thing to learn, and another thing to practice. For example, it's quite helpful to have a visual of someone utilizing absolute and relative cell addressing, but it takes it to an entirely different level when you are asked to create formulas that can involve both times of addressing, like this project demanded. It really helps you understand the concepts behind the formulas. This project asked that we do MAX functions and IF logical tests. The concepts seemed easy enough when I was listening to them being explained in the comfort of my room, but the knowledge really stuck when I had to make these formulas on my own.
At my last internship over the summer, I used Excel almost on a daily basis. Any knowledge or skills I had came from my middle and high school memories of learning the system. I was no master by any means, and I certainly didn't think I could ever make a pivot table, let alone really even know what one was. This project really helped me understand how to properly use one. I actually felt it was necessary to go back and watch both Pivot Table videos over again which really helped solidify everything I had learned.
No comments:
Post a Comment