1 / 10

Mastering Excel for Bioinformatics: Tips from the NCBI Short Course

Excel can be a frustrating tool for bioinformaticians, often mismanaging data formatting and analysis. In this guide from Deanna M. Church's NCBI Short Course in Medical Genetics (2013), we explore the pitfalls and best practices of using Excel for biological data. Key takeaways include understanding how Excel interprets your data, adjusting default settings for better accuracy, and effectively utilizing BLAST parameters for sequence comparison. Learn how to optimize Excel as a valuable asset in your bioinformatics toolkit.

peony
Télécharger la présentation

Mastering Excel for Bioinformatics: Tips from the NCBI Short Course

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Excel is your Frenemy Deanna M. Church Staff Scientist, NCBI Short Course in Medical Genetics 2013 @deannachurch

  2. Typical response from your local bioinformatician “I just emailed my data as anExcel workbook…”

  3. Typical response from your local bioinformatician http://dontuseexcel.wordpress.com/

  4. It is a poor workman, Malcolm, that blames his tools New Yorker Cartoon (May 14, 1955), Robert J. Day

  5. Application’s default settings Excel will try to guess what type of data you have and format it accordingly

  6. Application’s default settings Oct4 4-Oct Note: The official HGNC name for this gene is POU5F1, but Oct4 is a commonly used alias

  7. Change default settings as needed For every column

  8. Change default settings as needed http://www.ncbi.nlm.nih.gov/blast

  9. Change default settings as needed Only some of the available BLAST parameters Default BLAST page parameters tuned for highly related sequences

  10. Take home messages • Understand how your tools work • Understand default parameters • Adjust your parameters to address your question • Do the exercises to see this in action!

More Related