I SAW MY COWORKER TRACKING ATTENDANCE LIKE THIS

@miss.excel

1.0M followers · usually 2.9K views a post

Views

1.5M

Likes

40.1K

Comments

66

Shares

2.6K

SoundTikTok sound · original sound - migorengmedia

Promoted product

Microsoft Excel

Create and edit spreadsheets online with Microsoft Excel for the web. Easy formatting, analysis, and real-time collaboration from any device.

26 videos13 creators

Why it worked

The video provides a practical and visually engaging solution to a common workplace problem, leveraging a widely used software (Excel) with a clear, step-by-step demonstration and a useful shortcut.

Summary

The video demonstrates how to create an interactive attendance tracker in Microsoft Excel using checkboxes and a formula to calculate attendance percentage. It shows the steps of selecting cells, inserting checkboxes, and inputting a formula to automatically tally attendance.

Structure

1Show coworker's manual attendance tracking
2Introduce the improved method
3Select cells for checkboxes
4

Original caption

Smarter spreadsheets > less stress 😅 #excel #exceltips #corporate #workhacks

More from @miss.excel

Product placement

Microsoft Excel: This is the software used to create the attendance tracker. It acts as the interface for the entire video, and its functionality is demonstrated. Removing it would change what happens in the video.

On-screen text

I SAW MY COWORKER TRACKING ATTENDANCE LIKE THIS SO I SHOWED THEM THIS SELECT THE CELLS FOR CHECKBOXES PRESS ALT + N + C + B CHECK THE BOXES TYPE THIS FORMULA ATTENDANCE TRACKED ✅