Date: | February 11, 2021 |
---|---|
Time: | 1:00 PM AEDST |
Event: | Excel Check Box Bonanza |
Topic: | Check Boxes |
Public: | Public |
Registration: | Click here to register. |
Webinar – Excel Check Box Bonanza
Price: $25 incl GST (save money with the Webinar Pass)
Duration: 1 hour
Check boxes are one of the easiest controls to use. They allow you to turn off and turn on calculations and features at the click of the mouse. They are also easy to create and implement. This session includes a couple of worked examples.
This session will cover
- display the Developer tab to allow inserting check boxes
- tips on creating check boxes
- easily link to a cell
- a special format to hide entries
- incorporating the check box in formulas
- validating check boxes
- using range names with check boxes
- protecting sheets
- a macro to create multiple check boxes in one step
There will be tips and keyboards shortcuts along the way.