Bottom Line: Learn how to use the XOR function in Excel to analyze attendance data.
Skill Level: Intermediate
Download the Excel File
The file that I work within the video can be found below. You can use it to follow along and reconstruct what I'm doing in the video.
Compatibility: This file uses the new Dynamic Array Functions that are only available on the latest version of Office 365. This includes both the desktop and web app versions of Excel.
I'm planning to post a bonus episode in this series that covers how to make the dashboard with older versions of Excel using pivot tables instead.