Excel Guide #4: Creating Equations

Creating equations in Excel will allow you to be able to use operators and create equations for lab. There are different functions built in Excel that can be used in various formulas; such as the average, sum, trigonometric functions, and the standard deviation. One can also name a cell, which can then be used throughout the spreadsheet without having to rewrite a certain constant or formula. Not only that, you can also reference a certain constant. By using a reference for the constant, this allows the constant to be able to be used in different parts of the spreadsheet without changing the value.

Why is this important:
Knowing how to write equations in excel is important when creating different formulas during lab. An important thing to remember is to use the equal sign (=) before starting any equation or when using an operator.

Creating Formulas:

Creating Formulas:
1. In order to create equations or use any operator, one has to write an equal sign (“=”) to indicate that what will be writing into the cell will be a formula. This will tell Excel that that will be followed by the “=” will be an operator rather than random numbers or words.

 photo d9ac18df-26a8-4a4d-abf2-2a8f81364377_zps038e91d9.jpg

2. If you do not remember certain formulas, one can click on the “Formulas” tab. This is show different formulas that can be used in Excel in case you forget how to write a particular formula during class or at home while writing your lab report.

 photo 2_zps45aa3cb8.png

1. Trigonometric formulas (cos, sin, tan, etc) are, by default, in radians in Excel and need to be converted In order to convert from radians to degrees. This can be done by converting from degrees to radians by multiplying the radians angle by “π divided by 180″ (π/180).
2. In Excel, π is written as “pi()”