Building Interactive Spreadsheets In Excel

Authored by David Ringstrom
About this Course
Topics covered include: Using the ComboBox form control to create a searchable drop-down list; Creating an in-cell list by way of Excel's Data Validation feature; Minimizing ongoing spreadsheet maintenance with Excel's Table feature; Unlocking all data validation cells at once within a worksheet as opposed to tracking cells individually; Streamlining data entry in Excel with the CheckBox form control; Creating an in-cell list by way of Excel's Data Validation feature; Preserving key formulas using hide and protect features; Restricting users to enter times within a given time window; Contrasting Form Controls in Excel versus ActiveX Controls; Allowing users to make multiple choices by way of the ListBox form control; Crafting data validation lists that are contingent on selections from a preceding list; Viewing properties that can be set for specific form controls; for example, whether the object should be printed or not. Upon completing this course, you should be able to: Recall the arguments for Excel's INDEX function; Recall what the linked cell for a checkbox displays when a user clicks the checkbox on; State which Go To Special option allows you to select all form controls on a worksheet at once.
$ 37.98
Add To Cart
NASBA Field of Study
Computer Software & Applications
Level
Intermediate
CPE Credits
2.0
Prerequisites
Experience with Excel Spreadsheets
Last Updated
07/30/2018
14272