Session 1: Working with Excel

In this session we will go through the basics of excel:

  • making the workspace functional (as much as it can be)
  • using formulas
  • dragging formulas
  • graphing (continuous graphs, bar graphs)
  • basic statistics (t-tests, base ANOVA)

Our workshop on September 24, 2026 will use this excel file: Excel Worksheet Session 1

Here is a cheat sheet of some of what we will be up to (not exhaustive...because there are search engines and tutorials for this...): Excel Session 1 Cheat Sheet

Session 2: Excel to R

In this session we will go through:

  • organizing data in an Excel spreadsheet for use in R
  • importing data into R
  • assessing our data
  • descriptive summary statistics
  • how to load and call R packages
  • making graphs using tidyplot
  • t-tests, one-way ANOVA, two-way ANOVA, linear regression code

Our workshop will start with this excel spreadsheet: Excel2R

I will be using code from this cheatsheet: R Cheatsheet

We will reference these two flow diagrams for statistics (Stat Flow Chart) and tidyplot (Tidyplot Flow Chart).