I SAW MY COWORKER TRACKING ATTENDANCE LIKE THIS

@miss.excel

998.3K followers · usually 2.5K views a post

Views

1.0M

Likes

24.5K

Comments

46

Shares

1.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.

22 videos11 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 ✅

Don’t let your email inbox control your workday. Take 15 minutes to prompt Copil

33.0

79.3K1.7K2

Microsoft Outlook

79.3Kviews@miss.excel

Stop wasting time manually formatting Excel tables. 🛑 This Excel hack can do it

32.9

82.2K1.7K4

Microsoft Excel

82.2Kviews@miss.excel

XLOOKUP 101 ✅ #excel #exceltips #corporate #workhacks

12.8

30.7K1.2K7

Microsoft Excel

30.7Kviews@miss.excel