Excel's Checkboxes: Best use cases for Excel models

preview_player
Показать описание
Excel's Checkbox feature: Now available for all MS365 subscribers on the Current channel.

It provides in-cell checkboxes that can be clicked by users, or have their status controlled by a formula in the cell itself. I'll walk you through the basics, including formatting options, then dive into three examples of how the checkboxes can be used within more complex Excel models.

Please check the comments section for a link to download the example workbook.

00:00 - Intro
00:26 - The basics
03:26 - Input example 1
05:25 - Input example 2
07:36 - Output example

Intro music: "Pitbull" by Michael Ramir C.

#microsoft #windows #ms365 #msoffice #office #excel #checkboxes #financialmodelling
Рекомендации по теме
Комментарии
Автор

Link to download the workbook used in this video:

upskilloffice
Автор

I had a heck of a time creating VBA code to manage the new check boxes.

cato