PhysicsLaboratory ExcelTutorials

 Physics TutorialsE Tutorial Menu 1. TerminologyF

Hello, and welcome to my Microsoft Excel tutorials. I've created these pages to supplement your physics laboratory course here at Clemson University. Most of our lab courses require using Excel or some similar spread sheet application to display data, perform calculations and create plots. These tutorials are designed to familiarize our lab students with specific Excel tasks, which are required for successful completion of the course.

There are dozens of ways to perform the same Excel operation. In these tutorials I present various techniques and methods that I have found works well for me. Below is a listing of the 10 tutorials and their subheadings. Even if you are familiar with Excel, you should start at the beginning and work your way to the end. (At a minimum L200 and L207 students should be familiar with Tutorials 1, 2, 3, 7 and 10.)

1. Terminology
2. Arithmetic
2. Other basic operators
3. Exponential operator
4. Referencing cells within formulas
5. Three built in functions (SUM, AVERAGE, SQRT)
3. Basic Actions
3. Copy and paste your formula
4. Use correct significant figures
5. Emphasize important text
7. More cell manipulations (resize columns, change font styles, add borders)
8. That ###### error message
9. Display sample formulas
10. Consult the page setup (print gridlines and row and column headings)
4. Algebra
5. Displaying Symbols
6. Trigonometry
2. Built-in trig functions (sine, cosine tangent, arcsine, arccosine, arctangent)
3. Finding the height of a tree
4. Finding the launch angle of a ski ramp
5. Verifying a trig identity
7. Graphing Data and Curve Fitting
8. Advanced Graphing and Curve Fitting
10. Using Excel's Statistics Commands
1. Basic built-in functions (AVERAGE, MEAN, MODE, COUNT, MAX, MIN)
2. Linear regression equations (SLOPE, INTERCEPT, CORREL)
3. Error analysis tools (STDEV)
4. Miscellany (ABS)
11. Linear Regression and Excel
12. Helpful Hints Concerning the Physics Lab Reports
1. Work carefully
3. Display sample formulas
4. Check your work by hand

Of course, Microsoft Excel has an extensive built-in help application and you are encouraged to use it to dig deeper into the capabilities of the spread sheet program. These pages are intended to be used by the uninitiated physics laboratory student as a basic tutorial on getting started with Excel.

please let me() know if you find these tutorials helpful. I appreciate any feedback you may have.

If you have a question or comment, send an e-mail to Lab Coordinator: Jerry Hester

 Physics TutorialsE 1. TerminologyF 