Class 5: Practice using Spreadsheets

Bioinformatics

Andrés Aravena

October 14, 2022

Using a Spreadsheet

  • Using formulas

  • What happens when we copy a formula

  • Using absolute and relative references

Functions

  • MID()

  • IF()

  • MIN() and MAX()

Extra

  • MATCH()

  • INDEX()