In this introductory webinar, learn how to use Excel to manage your compound information and method development tasks plus useful shortcuts and functions.
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.
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.
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.