Checkboxes Arrive in Excel
I've been waiting for the Insert Checkbox feature to show up in my Microsoft 365 version of Excel. They are finally here. This short demo will show how to insert them, create a simple IF statement, count TRUE or FALSE with COUNTIF and even use with filters in PivotTables.
Sample Functions:
=IF(B2=TRUE,100,0)
=COUNTIF(B2:B9,TRUE)
Dawn Monroe Training
Microsoft Office Specialist Master
Wichita, KS, USA
https://dawnmonroetraining.com/
PLEASE SUBSCRIBE for more tips!
🔔 Subscribe for Updates 🔔
YouTube: / dawnmonroetraining
❤️ Connect on Social ❤️
LinkedIn: / dawnmonroetraining
Facebook: / dawnmonroe.training
💥 View Learning Opportunities💥
Calendar: https://learn.dawnmonroetraining.com/...
Website: https://dawnmonroetraining.com/
#microsoft #365 #exceltips #excel #checkboxes #truefalse #if #countif