Sunday, February 28, 2010

Week Nine: Clear- Relative and Absolute Cell Addressing

My first introduction to relative and absolute cell addressing was in the introductory required computing class CGS 2531. We had a MONSTER Excel project to complete. At one point a friend who was in the class with at the same time as me consulted the Microsoft Excel help desk because she was stuck and even the professional could not figure out the correct formula!

I revisited relative and absolute cell addressing this past summer at my internship where I used Excel on a near daily basis. One of the projects I was working on required me to write several complex formulas using data over several worksheets. I created a workbook that gave the results and my analysis of a market research survey I conducted. The knowledge I gained from that killer CGS 2531 project and referencing Excel Bible got me through the project with ease and certainly wowed by bosses with my above average understanding of Excel =).

No comments: