Part 1: Excel for science and mass spectrometry users

In this introductory webinar, learn how to use Excel to manage your compound information and method development tasks plus useful shortcuts and functions.

 

Part 2: Excel for science and mass spectrometry users

In Part 2, find out how to use conditional formatting with custom formulas, about the Visual Basic modules and how to create and use formulas and approaches such as INDEX-MATCH or VLOOKUP. 

Part 3: Excel for science and mass spectrometry users

In this final webinar, we cover cleaning up method tables plus the Take function and Filters, explore the Clock function and 96 well plate layout converter and finish with a section on multiple data sheets.

Workbooks

There is an associated Excel workbook for each webinar for you to download. The workbooks allow you to go through the presented information step by step providing practical examples along the way.