EASIEST Excel Data Entry Form in 2024 | No VBA Required

Подписаться 619 тыс.

Просмотров 32 тыс.

50% 1

Create a simple automated data entry form in Excel with Microsoft Forms.
👩‍🏫 Learn Excel with my courses: bit.ly/mforms24courses
🔗 Migrate Your Google Forms to Microsoft Forms: techcommunity.microsoft.com/t...
Picture this, you need to gather data from many users, but you don’t want them to see each other’s entries, or you just don’t want loads of people having access to your file because they might break it.
The old-style Excel User Forms provided an interface for data entry, but they not only look incredibly dated, they also require VBA skills to create. And you were limited to using them inside Excel for the Desktop. If you wanted to enter data while out of the office via an iPad or your phone, forget it.
But the new Microsoft Forms simplify data entry integrating seamlessly with Excel in real time. Users can enter data from any device that has a web browser, or they can download the free Microsoft Forms app, and if they need to go back and change a response, they can.
Plus, you can create prefilled links so that standard data is automatically entered.
LEARN MORE
===========
📰 EXCEL NEWSLETTER - join 450K+ subscribers here: www.myonlinetraininghub.com/e...
🎯 FOLLOW me on LinkedIn: / myndatreacy
💬 EXCEL QUESTIONS: Get help on our Excel Forum: www.myonlinetraininghub.com/e...
⏲ TIMESTAMPS
==============
0:00 Forget about Excel UserForms
0:48 How to create and use Microsoft Forms
2:54 No more errors with this feature
4:55 Another big improvement to Microsoft Forms
6:41 Syncing data to Excel
8:46 If you've been using Google Forms
8:58 Teaming up with Power Query
#Excel #MicrosoftForms #DataEntryForm

Наука

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

11 июл 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 71

@MyOnlineTrainingHub 10 дней назад

❓What’s the biggest data entry challenge you’ve faced? Learn Excel with my courses: bit.ly/mforms24courses

@bentonbolt3769 9 дней назад

I have a production line that I need to add several lines of quality check data on a production run- I don’t really want to restart the form from the beginning for each line of data and can never really know how many lines of data will be added, each line normally has four checkpoints. currently I start with a new template excel every production change, that template will have 5-25 lines of data and every time is saved as a new spreadsheet… I want to have a form that allows entry on a tablet, based on product, pulls info to show qb the specs and stores all the data in one form… Pondering what I may be able to make happen with forms…

@MyOnlineTrainingHub 9 дней назад

Sounds like you may be able to use Forms to capture this data and write it to a single Excel file that you can then analyse as required. Hope it's useful for you.

@scotolivera8207 3 дня назад

Google Forms really shines here because you can spice it up with some neat tricks using app scripts.

@GeertDelmulle 9 дней назад

Good stuff! Forms are becoming really good en well integrated... Thanks for another great video!

@MyOnlineTrainingHub 9 дней назад

Thanks for watching, Geert!

@jackcurl2005 9 дней назад

very nice introductory video!

@MyOnlineTrainingHub 9 дней назад

Glad you liked it!

@eduardosandoval2144 17 часов назад

Excelente!

@MyOnlineTrainingHub 6 часов назад

Glad you like them!

@foland2619 8 дней назад

Good video. Thanks

@MyOnlineTrainingHub 8 дней назад

Glad you liked it!

@RobotMegaPower 7 дней назад

Thanks a lot for the information, I'm using Excel for my trading stats

@MyOnlineTrainingHub 7 дней назад

Glad you found it helpful!

@Shahmeermalik 5 дней назад

Hi Ma'am, I love your video tutorials! Could you kindly explain how to easily copy shared (by someone) OneDrive folder names into Excel? I would greatly appreciate your help. Thank you!

@chrism9037 9 дней назад

Awesome Mynda!

@MyOnlineTrainingHub 9 дней назад

Cheers, Chris!

@trinawidders3535 8 дней назад

Great video, you are always so clear and concise. Cute hair too 😊. I am wondering about using this for inventory for garment decorating industry somehow. For example adding and removing items from inventory. Also could it work as a quote request form?

@MyOnlineTrainingHub 7 дней назад

It could certainly add items to an inventory, but not remove them.

@ST_LRussell 4 дня назад

Any way to show existing preset data (eg names, topics) on an MS Form, as well as collect data (eg grades, for topics against each name) back to an Excel file? Could be an ideal UI for complex spreadsheets... quicker and more secure than VBA Forms, Dialogue boxes etc.? Great videos btw. Thanks!

@MyOnlineTrainingHub 4 дня назад

You could do this as a prefilled form.

@anthonygikuri 9 дней назад

Thank you for sharing. Some observations: Capturing details through QR code possible? Pull function? Calculation functions cf Kobo form!!!!!

@MyOnlineTrainingHub 9 дней назад

I guess you could create a pre-filled link and create a QR code for it. Not sure what you're referring to with pull function as I'm not familiar with Kobo forms.

@tarekelsabaa 5 дней назад

Does forms allow dynamic dropdown lists? e.g. If I choose a specific org from dropdown list 1, can dropdown list 2 show ONLY the departments under that org?

@MyOnlineTrainingHub 5 дней назад

Yes, you can use branching, so after selecting an item from list 1, you can branch them to the next question for the departments for the org they choose in list 1.

@alyshalynn 7 часов назад

Still waiting for the ability to populate a form’s drop-down lists using data in lists/tables and without using Power Apps!

@MyOnlineTrainingHub 6 часов назад

Yeah, that would be good.

@rosemarygrundy3539 9 дней назад

Where does the Excel file have to be saved to? Can I keep the file on my PC or on a 3rd party file system such as Dropbox? Or does it have to be in something like One Drive or Sharepoint?

@MyOnlineTrainingHub 9 дней назад

The file will be in OneDrive/SharePoint, but you can sync OneDrive to your PC and access it from there if you prefer.

@rosemarygrundy3539 8 дней назад

@@MyOnlineTrainingHub thanks Mynda

@samanthaashcroft4414 9 дней назад

Is this a beta/preview option, as it's not showing on my M365 desktop

@Bridsworth 9 дней назад

Might be disabled by your company. That seems to be the case for me.

@MyOnlineTrainingHub 9 дней назад

It's available from forms.office.com or via the Microsoft App Store.

@lcorcoran56 2 дня назад

Can you create dependent drop-down lists in forms? I currently use MS Access forms with three levels of drop-down lists. I use these forms to measure progress by tracking the project number, WBS code (work breakdown structure), a list of deliverables for each project, and the number of hours worked. The selectable items are stored in a table that can be updated. When you select a project, you should only see the deliverables for that specific project. Is this possible in Forms?

@MyOnlineTrainingHub 2 дня назад

You can use branching to present the next question based on the answer to the previous question, so in a way, yes. But it can't extract data from a spreadsheet to populate the form in real time.

@lcorcoran56 2 дня назад

@@MyOnlineTrainingHub That's a pity, it would have been a nice feature, to have the dropdowns linked to a table. I think the branching would be just to much work, as we deal with hundreds of deliverables across multiple disciplines and projects. So it seems I'll have to stick with using Access. I've tried to convert the Access form into a web link without success. Anyway, thank you very much for your quick response!

@VeliMark-e7v 9 дней назад

Can I add pictures? Want use for a site inspection form. Is this possible?

@MyOnlineTrainingHub 9 дней назад

You can allow files to be uploaded, so yes, you could add pictures.

@VeliMark-e7v 9 дней назад

Thanks for the reply

@LaloinLondon 9 дней назад

Can the data be validated at the time the user fills the form? For instance, reject dates earlier than 1st Jan 2020.

@MyOnlineTrainingHub 9 дней назад

No, no data validation on dates.

@LaloinLondon 8 дней назад

@@MyOnlineTrainingHub Thanks

@naumanafzal6600 8 дней назад

I desire that user "outside my organization" uploads a file while using forms, is it possible in MS Forms?

@MyOnlineTrainingHub 8 дней назад

Yes.

@DJPGB 9 дней назад

I like your tutorials. However, it would be nice to give us a warning whenever your topic includes features not available on the macOS version of Excel 365. That would save us from the stress of searching for features that are not there. Is this one available for macOS?

@MyOnlineTrainingHub 9 дней назад

This is an online feature available at office.forms.com of from the Microsoft App Store as mentioned at the beginning of the video. You can access both of these on a Mac.

@UTJK. 9 дней назад

No desktop version, right?

@MyOnlineTrainingHub 9 дней назад

Yes, this is the desktop version 😉

@MyOnlineTrainingHub 9 дней назад

Correction, I was thinking of a different video 🤦‍♀️ It's available in forms.office.com and Excel Online and there will be a desktop version (there used to be), but it's not available yet.

@kumardigvijaymishra5945 9 дней назад

I like VBA, more than PowerPoint.

@MyOnlineTrainingHub 9 дней назад

Hmm, they're not mutually exclusive, but ok.

@kumardigvijaymishra5945 8 дней назад

@@MyOnlineTrainingHub Knowing VBA means a lot can be achieved with the trinity - Word, Excel and Access.

@johnfromireland7551 4 дня назад

You say you can use Power Query to connect to the Form's data yet there is no "Forms" Connector option. You mean connect to Excel - not "Forms"?

@MyOnlineTrainingHub 4 дня назад

Yes, connect Power Query to the data in the table that the form builds.

@johnfromireland7551 3 дня назад

@@MyOnlineTrainingHub Great, Thanks!

@pakhari3128 8 дней назад

I wish there was a way to enter coordinates

@MyOnlineTrainingHub 8 дней назад

You could use a text/numeric field for this.

@othmar61 8 дней назад

Unfortunately Forms are not yet usefull for planning purposes. That means instead of just asking the users to enter data they can at least see what data already exists, and then enter new data. Or using Forms for validation existing data would be nice as well. (Or did I miss something?)

@MyOnlineTrainingHub 8 дней назад

Users can edit their own entries as shown at the end, but they can't access the file containing all the data unless you give them permission to do so. You could build a report interface to the data if that helps.

@hoang16191 9 дней назад

only one thing, why don't allow upload question? Everyone can use upload question freely on google form but for Microsoft form, it is only available for business only!!

@MyOnlineTrainingHub 9 дней назад

You can upload questions using the conversion tool that allows you to convert PDFs and Word documents to Forms.

@hoang16191 9 дней назад

@@MyOnlineTrainingHub I mean upload file. 😁

@hoang16191 8 дней назад

@@MyOnlineTrainingHub oh sorry. I mean upload file.

@MyOnlineTrainingHub 6 дней назад

Yes, you can allow respondents to upload files.

@bumpersmith 9 дней назад

Seems like Microsoft is just catching up to Google Forms.

@MyOnlineTrainingHub 9 дней назад

Yes, like Google Sheets is catching up to Excel 🤔 It seems no IP is safe in the tech wars. Let's not forget that before Excel there was Lotus 1-2-3 and before that VisiCalc. Let them continue because we users are the winners.