Week 5: Clear

Week five covered the topic of mastering Excel. The clearest topic to me in week five was the formulas. They were extremely easy to catch onto as long as you didn't forget to put the equal sign ( = ) at the beginning of your formula. Formulas can be built by clicking on a cell and typing in the correct combination of letters, numbers, and symbols to produce a answer. This may seem a little intimidating at first, but the formulas are all basic math followed by the order of operations that you learn in elementary school (PEMDAS). The lectures were extremely helpful in demonstrating how to enter and copy your formulas into other cells. However, it was also helpful to me to explore the formula help bar to identify the correct formulas I needed to use and what they are used for. 


Mastering the use of formulas in excel can be very beneficial later on in life when you are looking for a job or just managing your money and time. Many work places have strict rules about using Excel for certain projects and having well rounded knowledge of the program ahead of time can give you a leg up on the competition in the job market. Also, I have talked to many college professors and they said that submitting your resume in Excel really shows how important the job is to you and sets you apart from the other thousands of applications that are submitted in Word format. 


For the more experienced Excel user there are formulas that can help you form advanced mathematical calculations quickly and accurately. Also, when working with Excel formulas you need to keep in mind the difference between absolute cell addressing and relative cell addressing. An absolute cell address consist of the column letter and row number surrounded by dollar signs ( $ ) and is used when you want a cell address to stay in a specific cell. While a relative cell address point to a different cell in relation to how far the cells are apart. Relative cells addresses change and absolute cell addresses do not. 


The following link helped me to remember the format when differentiating relative and absolute cells. It also helped me recognize formula formats for basic math. 


http://www.baycongroup.com/excel2007/02_excel.htm