Overview
Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Master Excel's most practical form controls and checkboxes to build interactive spreadsheets and dynamic user interfaces. Explore seven essential controls including combo boxes for dropdown selections, traditional and new checkbox options, option buttons for single-choice scenarios, spin buttons for numerical navigation, list boxes for multi-item selection, and scroll bars for data navigation. Discover when and how to implement each control type effectively, with hands-on demonstrations showing real-world applications for creating professional dashboards, forms, and user-friendly Excel tools. Learn to enhance spreadsheet interactivity without relying on complex formulas, making your Excel workbooks more accessible and functional for end users. Practice with downloadable course files and follow structured lessons covering control setup, customization, and practical implementation strategies for various business scenarios.
Syllabus
- Course Introduction
- Combo Box: Select from a List
- Check Box: Check/Uncheck Option
- NEW Checkboxes
- Option Button: Choose an Option
- Spin Button: Move Up and Down a List
- List Box: Select from a List of Items
- Scroll Bar: Scroll Through a List
- Course Exercise
Taught by
Simon Sez IT