Organize Your Caseload: Preview

 

Full Tutorial

 

Formulas

Download this document for the list of formulas shown in the tutorial.

-

Excel Document

Download this document for the Excel workbook used in the tutorial.

-

 Excel Formula For Calculating Age

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 Post Has 7 Comments

  1. Contreras

    This tutorial is incredibly helpful! Thank you for creating this resource and sharing!

    1. schoolpsych.com

      Thank you! Happy to help!

  2. Sherry Bauman

    This is AMAZING, thank you?!

  3. Carolina Sotres

    Speechless, this is amazing!

    1. schoolpsych.com

      Thank you!!!

  4. Adina

    Do the days remaining automatically update as time goes by?

    1. schoolpsych.com

      Hi Adina, great question! Yes, that is the beauty of Excel formulas! They will update automatically, assuming you set them up correctly.

Leave a Reply