Organize Your Caseload: Preview
Full Tutorial
Final Notes:
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.
This tutorial is incredibly helpful! Thank you for creating this resource and sharing!
Thank you! Happy to help!
This is AMAZING, thank you?!
Speechless, this is amazing!
Thank you!!!
Do the days remaining automatically update as time goes by?
Hi Adina, great question! Yes, that is the beauty of Excel formulas! They will update automatically, assuming you set them up correctly.