In this video we illustrate how to read data from an Excel format into R with read_excel() from the readxl package. We also illustrate the within() function, which is a convenient tool for modifying variables in a data frame, and cover the source() and sink() functions.
This video covers several important topics, but you may be able to learn about these topics from the course notes and by reading through Mod9Script.R without watching the video, if you prefer that approach.