Cookies on the
LGC website
We use cookies to ensure that we give you the best experience on our website. If you continue without changing your settings, we’ll assume that you are happy to receive all cookies on the LGC website. However, if you would like to, you can change your cookie settings at anytime.
Question markFind out more

Using Excel spreadsheets for data analysis in testing laboratories

  • Location:
  • Teddington
  • Duration:
  • 1 day
  • Cost:
  • £320 + VAT


TREXC06 03 Oct 2019
Data analysis is a vital aspect of the work of an analytical scientist, and it is often facilitated by using Excel. Excel may be used to carry out the statistical analysis of data, automate the production of results and aid data trackability. The effective use of Excel for the evaluation of data requires an understanding of its functions and the correct use of statistics. This course is aimed at analysts and covers the main Excel functions commonly applied to data analysis. The course will include hands-on workshops using laptops to facilitate the application of theory.

Download the course programme.

What are the benefits?
This course will help you:
  • Understand the main Excel functions used to manipulate analytical data
  • Calculate the most commonly used statistical parameters
  • Produce calibration plots
  • Use linear and polynomial regression in calibration
  • Maintain integrity of analytical data

The course will cover:
  • Designing clear data tables
  • Using basic calculation functions
  • Using functions and formulas to produce reliable results
  • Using pivot tables
  • Best practice in protecting and linking cells and spreadsheets
  • Plotting charts, linear regression, polynomial regression
  • Using the data analysis add-in to carry out statistical analysis of data
Who should attend?

The course is aimed at analysts who are beginning to use Excel for tasks such as summarising data (using basic functions and formulas), producing calibration curves, or statistical analysis. The course will also be useful for anyone who is self-taught and looking to fill any gaps in their knowledge.
The course focuses on the practical application of Excel and is suitable for those with limited or no prior experience of using Excel.