Главная
Study mode:
on
1
- Course Introduction
2
- What are Form Controls?
3
- Types of Form Control
4
- The Developer Tab
5
- Form Controls vs ActiveX Controls
6
- Combo Box Form Control - Select From a List
7
- Combo Box Form Control - Check a Box
8
- New Checkboxes Excel 365
9
- Spin Buttons
10
- Option Buttons + Excel Chart with Dynamic Title
11
- Course Conclusion
Description:
Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only! Grab it Learn to create interactive spreadsheets in Excel using form controls in this comprehensive 53-minute tutorial. Discover how to enhance user interaction, streamline data entry, and display dynamic content by implementing buttons, checkboxes, combo boxes, and more. Explore the versatility of spin buttons for incremental value adjustments and harness the power of option buttons to dynamically filter and visualize data. Follow along with free downloadable course files to master techniques such as creating combo boxes for interactive list selection, implementing checkboxes for task management, and designing Excel charts with dynamic titles. Gain valuable skills to empower your spreadsheets and improve data management efficiency through hands-on instruction and practical examples.

How to Build Interactive Spreadsheets in Excel

Simon Sez IT
Add to list