Тёмный

How to Build Interactive Spreadsheets in Excel 

Simon Sez IT
Подписаться 606 тыс.
Просмотров 4 тыс.
50% 1

✅Download the free course files and follow along here:
➡️www.simonsezit...
In this tutorial, you will learn to utilize form controls in Excel to enhance user interaction, streamline data entry, and display dynamic content. Empower your spreadsheets with buttons, checkboxes, combo boxes, and more. Create combo boxes for interactive selection from lists and implement check boxes for task management. Explore the versatility of spin buttons to adjust values incrementally without manual input. Discover the power of option buttons to dynamically filter and visualize data.
📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead! Timestamps:
00:00:09 - Course Introduction
00:02:00 - What are Form Controls?
00:02:51 - Types of Form Control
00:03:33 - The Developer Tab
00:04:38 - Form Controls vs ActiveX Controls
00:05:42 - Combo Box Form Control - Select From a List
00:13:03 - Combo Box Form Control - Check a Box
00:23:01 - New Checkboxes (Excel 365)
00:33:47 - Spin Buttons
00:40:01 - Option Buttons + Excel Chart with Dynamic Title
00:51:50 - Course Conclusion
🌍 Get unlimited training with Simon Sez IT’s 200+ courses ⏩ www.simonsezit...
🚀 Level up your skills with a free 30-day trial to our complete training library of 10,000+ videos ⏩ www.simonsezit...
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 400+ hour training course playlist here ➡️
• Simon Sez IT Long Trai...
✅ Check out our free video playlist for Excel beginners 👉 • Microsoft Excel Beginn...
✅ Excel 2021 Tutorials for Intermediate Users here 👉 • Excel 2021 Tutorials f...
✅ Microsoft Excel Tips and Tricks 👉 • Microsoft Excel Tips a...
✅ Microsoft Office 2021 and Office 365 Training here 👉 • Microsoft Office 2021 ...
💬Stay in touch!
SimonSezIT.com: www.SimonSezIT...
LinkedIn: / simon-sez-it
FaceBook: / simonsezit
🔔 Subscribe to our channel:
www.youtube.co...
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

Опубликовано:

 

27 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 11   
@SimonSezIT
@SimonSezIT 4 дня назад
✅ Download the free demo file and follow along here ➡ www.simonsezit.com/interactive-spreadsheets-in-excel-demo-file
@DingusBatus
@DingusBatus 3 дня назад
When placing form controls , to help line things up and get them to the same size as the cell you want to draw into hold down the {Alt} key as you draw the control. It then helps snap the control to size and shape of the cell.
@SimonSezIT
@SimonSezIT 21 час назад
Thanks for sharing that tip! The {Alt} key really is a game changer when it comes to aligning form controls perfectly with cells.
@benosborne413
@benosborne413 3 дня назад
Hi, Great. I have just to start with the video. Form control, first one (combo box). You mentioned that it can be added to charts etc. Would be nice to see how it is done. Thanks for great training
@SimonSezIT
@SimonSezIT 21 час назад
We have some upcoming training for Excel. Subscribe to our channel if you haven’t already, and click the bell icon 🔔 to get notified of new free training we add to RU-vid.
@tanveerabbas3271
@tanveerabbas3271 4 дня назад
@SimonSezIT
@SimonSezIT 3 дня назад
Thanks for watching! 😃
@mrpeterhacks
@mrpeterhacks 2 дня назад
Wow wow wow immeasurable value here thanks Debs I love you 😍😍
@SimonSezIT
@SimonSezIT 22 часа назад
Thanks for the kind comments 😊 Glad it was helpful.
@hw7channel571
@hw7channel571 3 дня назад
Great tutorial
@SimonSezIT
@SimonSezIT 3 дня назад
Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️ ru-vid.com/group/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
Далее
ДЕНЬ УЧИТЕЛЯ В ШКОЛЕ
01:00
Просмотров 446 тыс.
An Introduction to Microsoft Copilot
35:49
Просмотров 3,2 тыс.
EASILY Make an Automated Data Entry Form in Excel
14:52
The Excel Formula I Can’t Live Without
13:49
Просмотров 23 тыс.
Creating custom visuals in Power BI with DAX
35:04
Просмотров 10 тыс.
The ONE Excel Feature I Wish I Knew Sooner
16:08
Просмотров 8 тыс.
Advanced Excel Tutorial: 3+ Hours of Tips and Tricks
3:21:31
Excel Formatting Tricks That Make You Look Like a Pro
12:15
4 Advanced Power BI Tricks Using Disconnected Tables
18:52
ДЕНЬ УЧИТЕЛЯ В ШКОЛЕ
01:00
Просмотров 446 тыс.