Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/
In this video I explain how to create an attendance report in Excel. It includes a dashboard with conditional formatted Icons.

This video is for Excel Hash. This is a contest with other Excel YouTube channels, and is similar to popular TV cooking shows like Chopped. We were given 4 main ingredients (Excel features) and had to create a solution around those features.

The 4 ingredients are:

1. Icon
2. Dynamic Array
3. XOR Function
4. Linked Picture

Here is the link to the playlist where you can watch the other videos:
https://www.youtube.com/playlist?list=PLmHVyfmcRKyxfOLvOtx76xw8bbKgDvUwp

Please vote on the following page:
https://www.excelcampus.com/excel-hash-voting

Download the Excel file used in this video: https://www.excelcampus.com/wp-content/uploads/2022/04/Dunder-Mifflin-Attendance-Report-Follow-Along.xlsx

Dynamic Array Formulas video: https://youtu.be/1HF0UGMF070

I forgot to mention that I also used the new XLOOKUP function in column G of the Data sheet to do a Reverse Order lookup to calculate the duration for the "Out" rows. Here is a video on XLOOKUP. (https://youtu.be/pURSha68Mjs) I'll do a separate video to explain that XLOOKUP formula further.

Here is a video where I explain more about using conditional formatting for shapes (https://youtu.be/o24yr9Oc7l0). This technique also uses the Paste Linked Picture feature, which is similar to the one used in the video above with the transparent icon.

The Office episode clips featured in the video:
Season 1, Episode 1 (World's best boss)
Season 4, Episode 3 (Quarterly reports storm clouds and fireworks)
Season 2, Episode 8 (Dwight's attendance performance)
Season 4, Episode 4 (Is this PowerPoint?)
00:00 Introduction
00:15 About Excel Hash
00:41 The Challenge
01:55 The Data
03:30 The Calculations
04:13 Conditional Formatting