Organize Your Caseload: Preview
This tutorial has been conducted using fake student information. This tutorial was conducted on a PC, meaning if you're using a Mac, the layout may look differently. For example, there may be different steps to plug in a formula into conditional formatting. If this is the case, simply watch an additional Youtube tutorial on how to navigate through conditional formatting using your specific version of Microsoft Excel. Regarding part 3, there is an alternative way to shade every other row rather than what was demonstrated in the tutorial. On a PC, you can click the "Format as Table" option, which is right next to the conditional formatting button. On a Mac, depending on the version, it is likely to be in the Tables tab, then Table Styles. This can also be used to sort information and is a great tool to familiarize yourself with.