Cookies

We use cookies to ensure that we give you the best experience on our website. You can change your cookie settings at any time. Otherwise, we'll assume you're OK to continue.

Department of Physics

Excel Guide

Microsoft Excel is used extensively in the Level 1 Physics labs at Durham for data analysis and graph plotting. All the necessary information is provided on this page, through the tutorial documents below.

For students who are not already familiar with spreadsheets, using functions and formulas, it is suggested you begin with Excel Tutorial Guide 1. The Excel Tutorial Guide 2introduces plotting data and preparing graphs using Excel for a lab report as well as further skills including LINEST and using Greek letters, special symbols, and writing subscripts and superscripts in Excel.

The Excel Example Guide introduces how to prepare a worksheet and goes step by step through various tasks of data analysis and graph plotting typical of what you will do in the Level 1 Physics labs in Term 1.

Further information regarding EXCEL data analysis tools can be found on the Data Analysis page on the Lab site.

Resources