❓What’s the biggest data entry challenge you’ve faced? Learn Excel with my courses: bit.ly/mforms24courses
@bentonbolt37693 ай бұрын
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…
@MyOnlineTrainingHub3 ай бұрын
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.
@PattiAllen-i4g2 ай бұрын
Trying to reduce redundancy by pulling quality test results from an ongoing excel sheet to populate a Certificate of Analysis form with the most recent test results. That way the test results are entered once, automatically completing my CofA.
@scotolivera82072 ай бұрын
Google Forms really shines here because you can spice it up with some neat tricks using app scripts.
@VirtualArcades2 ай бұрын
I am interested in this. Headed to the Internet research zone. :)
@RobotMegaPower3 ай бұрын
Thanks a lot for the information, I'm using Excel for my trading stats
@MyOnlineTrainingHub3 ай бұрын
Glad you found it helpful!
@oxnardmontalvo77492 ай бұрын
That is an amazing feature. And thanks for the introduction video. Question: can I export the results in a file, that cannot be edited later? I want to do this: build a form for onboarding and let HR and IT select how the user needs to be configured and what kind of software etc he will need. Basically a checklist. Once it has been setup, I want to export the file and hand it over to several teams, so everyone can pick up their parts and complete the tasks.it's crucial that the details cannot be changed or accidently altered. (e.g. unticking a certain software that needs to be insatlled).
@MyOnlineTrainingHub2 ай бұрын
Yes, you can export the form responses to another file using Power Query. You can then protect that file so other users can't edit it.
@oxnardmontalvo77492 ай бұрын
@@MyOnlineTrainingHub Thank you so much Mynda, for your quick and neverending support. You are truly a Rockstar!!!
@jackcurl20053 ай бұрын
very nice introductory video!
@MyOnlineTrainingHub3 ай бұрын
Glad you liked it!
@trinawidders35353 ай бұрын
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?
@MyOnlineTrainingHub3 ай бұрын
It could certainly add items to an inventory, but not remove them.
@anthonygikuri3 ай бұрын
Thank you for sharing. Some observations: Capturing details through QR code possible? Pull function? Calculation functions cf Kobo form!!!!!
@MyOnlineTrainingHub3 ай бұрын
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.
@ST_LRussell2 ай бұрын
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!
@MyOnlineTrainingHub2 ай бұрын
You could do this as a prefilled form.
@alyshalynn2 ай бұрын
Still waiting for the ability to populate a form’s drop-down lists using data in lists/tables and without using Power Apps!
@MyOnlineTrainingHub2 ай бұрын
Yeah, that would be good.
@bumpersmith3 ай бұрын
Seems like Microsoft is just catching up to Google Forms.
@MyOnlineTrainingHub3 ай бұрын
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.
@DanielMurrayDanieАй бұрын
Can I start a form with an existing excel file with data
@MyOnlineTrainingHubАй бұрын
Yes, I think they introduced this feature recently from Excel Online. i.e. open the existing file in Excel Online and Insert the Form there.
@Shahmeermalik2 ай бұрын
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!
@hoang161913 ай бұрын
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!!
@MyOnlineTrainingHub3 ай бұрын
You can upload questions using the conversion tool that allows you to convert PDFs and Word documents to Forms.
@hoang161913 ай бұрын
@@MyOnlineTrainingHub I mean upload file. 😁
@hoang161913 ай бұрын
@@MyOnlineTrainingHub oh sorry. I mean upload file.
@MyOnlineTrainingHub3 ай бұрын
Yes, you can allow respondents to upload files.
@GeertDelmulle3 ай бұрын
Good stuff! Forms are becoming really good en well integrated... Thanks for another great video!
@MyOnlineTrainingHub3 ай бұрын
Thanks for watching, Geert!
@tarekelsabaa2 ай бұрын
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?
@MyOnlineTrainingHub2 ай бұрын
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.
@rosemarygrundy35393 ай бұрын
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?
@MyOnlineTrainingHub3 ай бұрын
The file will be in OneDrive/SharePoint, but you can sync OneDrive to your PC and access it from there if you prefer.
@rosemarygrundy35393 ай бұрын
@@MyOnlineTrainingHub thanks Mynda
@UTJK.3 ай бұрын
No desktop version, right?
@MyOnlineTrainingHub3 ай бұрын
Yes, this is the desktop version 😉
@MyOnlineTrainingHub3 ай бұрын
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.
@kumardigvijaymishra59453 ай бұрын
I like VBA, more than PowerPoint.
@MyOnlineTrainingHub3 ай бұрын
Hmm, they're not mutually exclusive, but ok.
@kumardigvijaymishra59453 ай бұрын
@@MyOnlineTrainingHub Knowing VBA means a lot can be achieved with the trinity - Word, Excel and Access.
@samanthaashcroft44143 ай бұрын
Is this a beta/preview option, as it's not showing on my M365 desktop
@Bridsworth3 ай бұрын
Might be disabled by your company. That seems to be the case for me.
@MyOnlineTrainingHub3 ай бұрын
It's available from forms.office.com or via the Microsoft App Store.
@Bridsworth9 күн бұрын
@@MyOnlineTrainingHub App store is also disabled by company policy :(
@naumanafzal66003 ай бұрын
I desire that user "outside my organization" uploads a file while using forms, is it possible in MS Forms?
@MyOnlineTrainingHub3 ай бұрын
Yes.
@DJPGB3 ай бұрын
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?
@MyOnlineTrainingHub3 ай бұрын
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.
@Kylee_MeeraАй бұрын
You can't use them to replace user forms though if you're attempting to use a barcode scanner. Microsoft forms is still the LEAST robust forms tool
@MyOnlineTrainingHubАй бұрын
Yeah, there's a few limitations like that.
@othmar613 ай бұрын
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?)
@MyOnlineTrainingHub3 ай бұрын
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.
@Leibnitz19932 ай бұрын
Thanks for this. Just want to clarify if the Query tab on the Excel file is already a default or you created it yourself?
@MyOnlineTrainingHub2 ай бұрын
It's available on the data tab in all versions of Excel from 2016 onward. For earlier versions it was a free add-in.
@lcorcoran562 ай бұрын
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?
@MyOnlineTrainingHub2 ай бұрын
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.
@lcorcoran562 ай бұрын
@@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!
@VirtualArcades2 ай бұрын
Solid stuff as usual. As an IT Pro, I find this helpful.
@MyOnlineTrainingHub2 ай бұрын
Awesome, thank you!
@1970heroab2 ай бұрын
That tool is great... but one thing I can not make righr: How to collect data to be collected as numbers that I can use directry in build in charts as resusts ? Now I get numbers as text. At this type they are useless because without any conversion they can not give basic ansswers in charts.
@MyOnlineTrainingHub2 ай бұрын
If you import the data from the form spreadsheet with Power Query, you can convert them to numbers there. That said, I don't have this issue anymore. as shown in the video. You just need to set the field as a number.
@1970heroabАй бұрын
@@MyOnlineTrainingHub ... but Forms have bult-in charts which I want to share to all respondents as additional info without any conversions or required actions
@johnfromireland75512 ай бұрын
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"?
@MyOnlineTrainingHub2 ай бұрын
Yes, connect Power Query to the data in the table that the form builds.
@johnfromireland75512 ай бұрын
@@MyOnlineTrainingHub Great, Thanks!
@msmith3090Ай бұрын
Can you use Forms to start an approval flow?
@MyOnlineTrainingHubАй бұрын
Yes. You could also connect it to Power Automate to automate the approval process.
@LaloinLondon3 ай бұрын
Can the data be validated at the time the user fills the form? For instance, reject dates earlier than 1st Jan 2020.
@MyOnlineTrainingHub3 ай бұрын
No, no data validation on dates.
@LaloinLondon3 ай бұрын
@@MyOnlineTrainingHub Thanks
@VeliMark-e7v3 ай бұрын
Can I add pictures? Want use for a site inspection form. Is this possible?
@MyOnlineTrainingHub3 ай бұрын
You can allow files to be uploaded, so yes, you could add pictures.
@VeliMark-e7v3 ай бұрын
Thanks for the reply
@pakhari31283 ай бұрын
I wish there was a way to enter coordinates
@MyOnlineTrainingHub3 ай бұрын
You could use a text/numeric field for this.
@foland26193 ай бұрын
Good video. Thanks
@MyOnlineTrainingHub3 ай бұрын
Glad you liked it!
@eduardosandoval21442 ай бұрын
Excelente!
@MyOnlineTrainingHub2 ай бұрын
Glad you like them!
@chrism90373 ай бұрын
Awesome Mynda!
@MyOnlineTrainingHub3 ай бұрын
Cheers, Chris!
@drinno89003 ай бұрын
Mac excel doesn’t have forms
@MyOnlineTrainingHub3 ай бұрын
Forms are an online tool available on all operating systems. You access them through Forms.Office.com.