How to use Excel’s INDIRECT function to refer to cells using the values entered into another cell. We show the basic method of how it works, and a more advanced example to refer to content in other worksheets.
Relative and absolute paths
How to import data into R from files stored in local directories. Includes how to copy file paths in Windows, how to use relative and absolute file paths, and working in R Projects.