Appendix C: Using Excel to Process Data and Make Graphs

Excel: a scientist’s best friend or worst nightmare?  Like it or not, spreadsheets play an important role in organizing and plotting data.  Excel (and to some extent Google Sheets) include commands to make your life easier – if you know how to use them.

Here, we compile useful tutorials and resources for excelling in your Excel skills.

References (Online)

Ben Ryder (9/1/2016) Plotting scientific graphs in Excel (physics). https://youtu.be/HyCghkVPgPY

Ben Ryder (9/1/2016) Using Error bars in Excel with scientific data. https://youtu.be/yoNuNjTZARU

Doug McNally (10/16/2016) How to make a scientific graph in Excel. https://youtu.be/657w2QjURvs

Licenses and Attributions

Text written by Elizabeth Johnson, JMU

CC-by License