Easy Excel Forms - No VBA & access from any device!

[@ImranKhan-pm6gd]

Hi there, I was searching for a doughnut chart video and your video came in as a suggestion. Beleive me or not, I saw the whole of your 53 minutes video and at the end realised that I just spent an hour's time without noticing. Your illustrations are just exceptionally good. Looking ahead for more great videos. They are extremely knowledgeable and helpful.

[@MyOnlineTrainingHub]

Wow! I'm delighted it was worth your time to watch my video :-)

[@TheGatatsu]

Was just looking for a means on data entry online without the restriction of a localized APP. Thank you, Your videos are always a big help!

[@MyOnlineTrainingHub]

Great to hear!

[@julianzacconievas]

Thank you, I wasn't aware MS had come out with these forms. They would have been perfect for implementing what we are doing now, but I'm sure there will be another chance to give them a go soon. Keep up the good work!

[@MyOnlineTrainingHub]

Great to hear you'll be able to make use of them, Julian :-)

[@DanielADamico]

Awesome video as always. I've been using Forms for a few weeks and never realized that I could keep the form linked to an Excel online file. I always used the export option but with this new trick things are going to be a lot easier 😉

[@MyOnlineTrainingHub]

Glad I could help, Daniel!

[@IvanCortinas_ES]

I knew about this new functionality. Very practical for doing small surveys. Thank you very much Mynda for the information!

[@MyOnlineTrainingHub]

My pleasure, Ivan!

[@rochellerobinson939]

I really like this. I created a form to track my spending habits at home. Will be great to use at work as well. Thanks for sharing.

[@MyOnlineTrainingHub]

Great to know it'll be useful, Rochelle :-)

[@Ismail-Yahya]

Always love your tutorials. They’re some of the best on YT!

[@MyOnlineTrainingHub]

Glad you think so!

[@mubambeshimete3645]

I just love your videos. So informative, simplified and easy to follow. Can't thank you enough. You the best!!!

[@MyOnlineTrainingHub]

Thanks for your kind words, Mubambe!

[@boycottarmy8826]

Might have been useful to mention right at the start that you need a business account and not a personal account to implement the form (with file upload) and to have the option to continue to receive data while opening the excel spreadsheet.

[@nchimunyamuyuni7920]

So my personal 365 can't work? Smh, thanks

[@SHarris64]

Yes, That would have been very useful... :(

[@hpapasutube]

First time commenting in youtube. Great work Mynda. I like both your content and the pace of presenting stuff - not too slow and boring with too many details. Great job!

[@MyOnlineTrainingHub]

Awesome to hear! Thank you, Harry!

[@Boyeng_TV]

Thanks for always inspiring me to build systems using Excel.

[@MyOnlineTrainingHub]

You're welcome!

[@oliverbuckley5121]

Looks like a feature with great potential. Thanks for demonstrating it.

[@MyOnlineTrainingHub]

Hope you can use it, Oliver :-)

[@shenry25]

Many thanks, Mynda. 🤣 I always thought you were British 🤣. Admittedly, I've never been good with accents, and/or it wouldn't be surprising for a Brit to live in Australia....

[@MyOnlineTrainingHub]

I’m Australian but I lived in London for a long time so my accent is a combination 😁

[@barttitulaerexcelbart9400]

Thank you Mynda, It has been a while since I used Forms, I see that microsoft has an option to upload a file as an answer, I just tried this, it is a cool option, now my students could upload their files in this way! Great!. You can also make a sheet of visuals (based on the answers) and share this with your respondents. Thanks again. !!

[@MyOnlineTrainingHub]

Yes, it's a big improvement on the old Excel Survey. Yes, you could create a report from the data in the Excel file and share it in the Excel Web App in a web page.

[@barttitulaerexcelbart9400]

@@MyOnlineTrainingHub Yes, and do not forget to set the browser options to only display the graphs sheet, not the raw data. Strange, this setting is in Info.... btw: I saw another option for sharing: you can enter a date and time. This is a nice option for online examns. !! :) So you can only access the exam at a certain time.

[@edjoseph4383]

Thanks Mynda. As always very helpful videos.

[@MyOnlineTrainingHub]

Cheers, Ed!

[@abhijithdsouza8091]

I live in Brisbane and always thought it was pronounced Blee Blee ! Thanks for the wonderful video and the correct pronunciations :)

[@MyOnlineTrainingHub]

Well know you know the correct pronunciation you won't look like a tourist in your own state :-D

[@michaelshelnutt3534]

Do you have a suggested video on how to use Power Query to do as you suggest at the end of the video? I set up a Form to get daily production data and would like to take the Excel data and create one of your dashboards from it.

[@MyOnlineTrainingHub]

Sure, you can watch this video to learn how to connect Power Query to files on OneDrive or SharePoint: kzbin.info/www/bejne/qJS8g5apec-Dg6s

[@GioSinatraFan]

Great video. Quick question. Is there a way to drop a specific date according to a calculation? For example, lets say I wanted to add one new record each week. Is there a way of figuring out the last record date and adding a week to it?

[@MyOnlineTrainingHub]

Probably, but there's some information missing from your question. Please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum

[@GioSinatraFan]

@@MyOnlineTrainingHub I tried registering but then nothing happens and nothing got sent to my email.

[@Nipthezephyr]

Very useful! Thanks for having this video.

[@MyOnlineTrainingHub]

My pleasure, Shawn!

[@atulwalvekar3328]

Hi Mynda, thanks for demonstrating how simple creating forms could be. Thanks Microsoft team for developing that tool. A couple of questions (though you mentioned it is still in preview) ... 1. Is it possible to create multiple pages form using this tool? How? A short demo could help. 2. Could the user design his / her own form layout. Not all the fields need to be that wide ... thereby reducing the length of the form or the number of pages? Thanks in advance for your answers.

[@MyOnlineTrainingHub]

Hi Atul, you can't have a form put the answers to questions on different pages (sheets) in the Excel file, but you could to this yourself later with Power Query or a PivotTable when you're analysing the data. The layout of the form is dictated by the questions you ask. It will automatically scale to the device the form is opened in. There's no way to alter the layout as such, but I personally wouldn't be put off by this as someone entering data into the form.

[@atulwalvekar3328]

@@MyOnlineTrainingHub many thanks Mynda for your answers.

[@davidtopp1972]

Great video with excellent information! I have questions due to my set-up. I am running a MacBook Pro on Monterey, and I have Excel Only! ; I purchased Excel Home and Student from Microsoft because that is all I use 99% of the time. Now after seeing your video, I would like to try Microsoft Forms in conjunction with Excel for my Home Budget, check registers, and savings accounts. Please advise me what you feel is the best course of action for me. I really do not want to pay a monthly or yearly subscription for MS 365.

[@MyOnlineTrainingHub]

Hi David, You could use VBA to create your own form: www.myonlinetraininghub.com/excel-forms

[@demetriusoatis8474]

Awesome video. I sent out a survey to my team located all over the state of Georgia and received back great results. Question, in several months from now, is it possible to send out a "pre-filled" survey with their last survey responses so that they can update if necessary?

[@MyOnlineTrainingHub]

So great to hear you've found Excel Forms useful. The prepopulated answers is not so easy. There's no built in way to do it, but you might be able to use Power Automate to somehow do it, but I don't have any examples of how, or know whether it has ever been done before. You'd be best to ask in the Power Automate Community forum: powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

[@FGustavSchmid]

I came across this video and would like to thank you for the insights that led me away from the desktop version for better productivity. I have a question; if you allow me: is it possible to convert an existing worksheet into a form for automation with PowerBI? The current form creation options do not contemplate the complexity of the scorecard I have in Excel format, and thus I am wondering if I will need to reach out to a developer or if I can do it on my own. Thanks in advance for the great video and for your attention!

[@MyOnlineTrainingHub]

You can't connect a form to an existing worksheet, but you can use Power Query to get the data from the form's workbook and bring it into your Power BI model.

[@martinargimon730]

Hi Mynda. Can we create a form from an ‘existing’ worksheet? . It does look like is as easy as from ‘scratch ? Thx 😊. Martin

[@MyOnlineTrainingHub]

Not an existing worksheet. However, you can now insert a form into an existing workbook via the Insert tab > Forms.

[@martinargimon730]

@ thanks Mynda

[@amelahadzicmba]

Amazing! This video just saved me at work 😅 THANK YOU!!

[@MyOnlineTrainingHub]

Great to hear!

[@lukev730]

Wonderful Excellent teaching! Appreciated.

[@MyOnlineTrainingHub]

Glad it was helpful, Luke!

[@sherryizzie5309]

Thanks for sharing it! Love this new application which makes survey creation much easier:)

[@MyOnlineTrainingHub]

Glad it was helpful, Sherry!

[@wayneedmondson1065]

Hi Mynda.. great video. Thanks for the quickie tour of Excel Forms. Looks interesting and promising. Thanks for sharing.. glad to know about it. Thumbs up!

[@MyOnlineTrainingHub]

Cheers, Wayne!

[@NANA-gy7yx]

Awesome video 👏 I created a sales performance calculator on excel and I would like it to open as form where any sales agent can open it and enter his revenues and then press enter to get his percentage and expected end of month achievement. How can I convert this into a form where when the file is opened it only shows the form and nothing else (as if it isn't an excel like what you did here)? I hope this makes sense 😅

[@MyOnlineTrainingHub]

You can use this form for your sales agents to enter their revenues, but they would need to then view the percentages in another report that extracts the data from the Excel file the form populates. You could embed this file in a web page, but it would only update once per hour. If you want something more instant, then you might be best to get an app built.

[@Oprimaita]

It was a good idea to start my working day by watching your video. Thanks a lot

[@MyOnlineTrainingHub]

My pleasure :-) Have a great day!

[@thanhle-xy4of]

You try to give the video more brightness it will be great if you do

[@elainenuttall6637]

Love your videos! Question please, if I'm wanting to import the forms data to Power BI is this the best option or should I just use Microsoft Forms and create a Power Automate Flow?

[@MyOnlineTrainingHub]

Hi Elaine, I would just connect the Excel file that Forms generates to Power BI and refresh as required or set up a scheduled refresh. I don't think there's any value Power Automate can add to this process.

[@hanankhalifa2589]

Thank you dear appreciate your time for this

[@MyOnlineTrainingHub]

My pleasure :-)

[@EssentialExcel]

Thank you! 👏

[@MyOnlineTrainingHub]

You're welcome!

[@evapruitt9213]

Thank you! Can you add calculated fields in the forms with some formulas?

[@MyOnlineTrainingHub]

Hi Eva, Not sure exactly what you had in mind, but you can't have the form perform a calculation, but you can certainly do this in the Excel worksheet that the form data gets deposited in.

[@darrylmorgan]

Hi Mynda!Excel Forms Are A Great Addition To Microsoft 365.Cool Introduction Tutorial Thank You :)

[@MyOnlineTrainingHub]

Glad you think so, Darryl :-)

[@pakhamulus]

Very useful and handy. But does the person who will be filling in the form must have corporate email too?

[@MyOnlineTrainingHub]

No, the person completing the form doesn't need any specific account or to login. They simply load the form in a web page and can complete it.

[@pakhamulus]

MyOnlineTrainingHub thank you for the answer.

[@jamesadambano208]

Great tutorial again! More power and keep up the good work! I have a question though, how do you restrict someone to submit multiple times? I just want each of my respondents to have the capability to answer once.

[@MyOnlineTrainingHub]

Thanks, Jim! I'm not sure there's a way to prevent multiple entries.

[@jax01234]

Going to use this feature! Thanks!

[@MyOnlineTrainingHub]

Very pleased to hear that, Jacqulyn!

[@HammamDisini]

Thank you, clean and clear explanation.

[@MyOnlineTrainingHub]

Glad it was helpful, Hammam!

[@moesadr3342]

This is an awesome training, and I would like to thank you for the awesome topics and simple but through explanations. Are there any limitations on the number of fields and specially records. My purpose is to see if it would work for a medium or large size table. Also, if we have multiple sheets in our workbook, can this method still work for collecting data for each sheet. Last but not least, you talked about Data Validations, how could one refer to a list for selection from an existing list?

[@MyOnlineTrainingHub]

Hi Moe, glad this tutorial was helpful. I would expect there's no limitation on the number of records, other than the number of rows in an Excel worksheet, which is over 1M. As for the number of fields/questions/columns, I'm not aware of any limits here, other than the number of columns, but you're unlikely to exceed this. You cannot collect data for multiple sheets, however you can collect it in separate files and then use Power Query to bring the data into one or more sheets in another file. There's no way to reference an existing data validation list. You need to recreate them in the form.

[@moesadr3342]

@@MyOnlineTrainingHub Thanks for the input, much appreciated. I don't mind having only one sheet per workbook. Just to be clear, I cannot use a couple of columns dedicated to the list of names (Name Range or Table) , that can be used for Data Validation purposes, is that correct?

[@mahernasri1885]

This is great, I guess I need this kind of business tools. Thank you.

[@MyOnlineTrainingHub]

Glad you can use it :-)

[@paddymcdonnell425]

Hi this is exactly what I'm looking for, but i use it on an iPad to capture data on water/waste plants, sometimes there is no connection what so ever on the plants, is there anyway at all that it can be used offline.

[@MyOnlineTrainingHub]

Hi Paddy, unfortunately, Forms cannot be used offline, sorry.

[@khyambaig7121]

Another fantastic and very helpful video - thank you so much!

[@MyOnlineTrainingHub]

Glad it was helpful, Khyam!

[@eduardouribevera7971]

Thank you. This is great and it has been completely useful in our company. I have got a question, will it be possible to input old data from a different workbook (which contain the same information) to a recent excel form without corrupting the file?

[@MyOnlineTrainingHub]

You can try adding data to your Form Excel file. In the past this has caused problems, but I'm told it doesn't anymore.

[@asadmahadi628]

Great. I can use this excel form functionality to conduct opinion poll with my counterparts within my organization . Thank you

[@MyOnlineTrainingHub]

Glad it was helpful, Asad!

[@moisestatis5418]

Great video, thanks!

[@MyOnlineTrainingHub]

Glad you liked it!

[@johngogo7190]

what im working on is a bit more complex...is there anyway i can get more in depth information about the forms.

[@MyOnlineTrainingHub]

Hi John, this is the documentation available for Microsoft Forms: support.microsoft.com/en-us/forms

[@awesh1986]

Hi Mynda as usual too good. What software are you using for your screen casting and what display are you using

[@MyOnlineTrainingHub]

Thanks, Awesh! I use Camtasia Studio. Not sure what you mean by 'display'?

[@AweshBhornya-ExcelforNewbies]

I mean what is the monitor configuration because your display is just too good as in crytal clear and crisp

[@damatar]

Per recommendation from Mynda on another video, I'm working on possibly using Forms. One sticking point so far: I need large drop-downs (and some will change each month) for most of my questions. Nothing I could type in. Can Forms use drop-down lists like Data Validation in Excel? Secondly, the file upload seems to just send a link to the file to the Excel output. It would make things SO easy on my end if the uploaded files would instead populate the Excel output with what's IN the file. Is that possible? I have 100+ users who fill in about 30 columns of data and 1-50 or so rows of data. If all of that data could be uploaded in Forms and combined in the output, that would be incredible.

[@MyOnlineTrainingHub]

Yes, there is a drop down list for forms. The form deposits the data into an Excel workbook. You can then use Power Query to gather the data from the workbook and bring the data into the file you want.

[@damatar]

@@MyOnlineTrainingHub Thanks so much. I'll keep working along on it, then. :)

[@skd5432]

Awesome as usual..... 👌👏

[@MyOnlineTrainingHub]

Thank you so much 😀

[@willemgodschalk6438]

Can you also adjust an entry or update one. For instance you put in a Sales Volume. Send in the form and then realize something is wrong.

[@MyOnlineTrainingHub]

Yes, you can change the entries in the Excel file.

[@omezga]

Hi, in the last seconds of this video your mentionned the use OneDrive for business to build a permanent connexion between the form and the corresponding Excel file. Could you please provide more details on how to do that ? Thank you

[@MyOnlineTrainingHub]

I showed you how to use OneDrive to create the Form in the video. Perhaps you can watch it again. If you get stuck, let me know.

[@Asad-fd3lp]

Is it possible to source the questions from an already build excel sheet? Let's say, I have a list with actions numbers (unique values) and I need information about specific Action number, the details about that action. (If it's EPO or not) that I need from the users, can I somehow automate it in a way that specific action number goes as the 'question' of the form and the set of answers to chose from?

[@MyOnlineTrainingHub]

Hi Asad, you can't auto-generate the questions that go into the forms, sorry.

[@mamhyamo]

This is wonderful! Been looking for this info. Thanks for sharing. Quick que. Is it possible for the responder to receive a summary of the data he/she submitted?

[@MyOnlineTrainingHub]

There's no built in way for the form to present a summary of what they entered. If they have a Microsoft account and they're logged in when entering the form, then you could use Flow to automate sending them an email with the data they just entered.

[@mamhyamo]

@@MyOnlineTrainingHub Thanks so much for replying. Is there a step guide on how to use Flow to do this?

[@kossiviaglee2997]

I have a personal outlook account and I'd prefer to start my forms following your tutorial by Excel. Is it possible to get the "Forms" button in online free Excel?

[@MyOnlineTrainingHub]

No, you can only get the Forms button inside of Excel with a 365 account.

[@kossiviaglee2997]

@@MyOnlineTrainingHub Thanks, you are doing an amazing job!

[@moniomar12]

Great Video. I've got a question. Is it possible for a user to edit his/her response after submitting the form? For instance, If they were to submit a form filling only some of the fields in it, can they populate the rest of the fields later?

[@MyOnlineTrainingHub]

No, the user can’t edit their response unless you allow them access to the Excel file.

[@FaysalEasyExcel]

it's like google docs. thanks enjoyed my coffee with your video :)

[@MyOnlineTrainingHub]

Glad you enjoyed it!

[@johnnwakanma5522]

Lovely Training, Thanks

[@MyOnlineTrainingHub]

My pleasure 😊

[@tamunosakiwestscott-bloack2229]

Hello. I created an excel spreadsheet using forms. When creating the forms I originally created about three questions which I later deleted and replaced with another three. However looking at the excel spreadsheet submissions, I see that the original three fields I deleted are still there ( Unfilled) alongside the other fields I created which are of course filled in by respondents. My question is can I get rid of these three empty columns without messing up my work?

[@MyOnlineTrainingHub]

I don't recommend removing redundant columns as it may break the connection between the sheet and the form. Instead, use Power Query to get the data from the Excel file and remove the redundant columns before loading the data to the workbook/Power Pivot model.

[@Earth-360]

you are a gift.

[@MyOnlineTrainingHub]

Glad I could help 😊

[@carl-janvanamelsfort5361]

Great insight in this option of using forms. I have a question. I want to use forms to create a overview of records which I want to further want to add data in the original records. How can this be done, also using the forms format to ad information? Hope to hear from you. Thank you in advance for a reaction.

[@MyOnlineTrainingHub]

You can use Power Query to get the data from the Excel worksheet connected to the form and merge/append other data to it.

[@carl-janvanamelsfort5361]

MyOnlineTrainingHub Hi thank you. Could you give me some guidance on how this is done. Unfortunately I do not have the knowledge how. Would be great if you could help me out with this. Thank you in advance. Carl-Jan Have a nice day.

[@findthetruth3021]

You are amazing and i love your videos

[@MyOnlineTrainingHub]

Thanks so much!

[@19LloydG]

Wow, this looks great. So much potential! Thanks.

[@MyOnlineTrainingHub]

Glad you like it, Lloyd!

[@davidcharlton7765]

is there a way to add a dropdown list to one of the fields, instead of typing the info, use the data validation?

[@MyOnlineTrainingHub]

Yes, under the Choice question type you can choose drop down.

[@vincelolx]

Great video. Is there any way to link an existing form to Excel? Or I must create a new Form for Excel?

[@MyOnlineTrainingHub]

No, you'd need to start a new form, sorry.

[@MrModeller68]

Hi. Thanks for a good video. But there is something I don't get. If I can't add formulars to the Table where data are registrated, then I can't show the the answers dynamic. Thats really a drawback using Forms. Unfurtunately my company is using Forms so I'm stucked with that. Question: I have a questionnaire using "Form for Excel". It has worked uptill now but now I only get a blank page when opening the Form-page. Can you tell me why?

[@MyOnlineTrainingHub]

You can take the data from the table the form deposits it to with Power Query and add formulas etc. to analyse it and update it by clicking 'Refresh All' on the Data tab of the Excel ribbon. Regarding the blank page, not sure, sorry.

[@MrModeller68]

@@MyOnlineTrainingHub Thanks🌞

[@bumpersmith]

Good video. Is there a way to link these forms to an MS Access desktop database?

[@MyOnlineTrainingHub]

Not directly, but you could import the Excel data to Access.

[@Belgarathe]

New viewer and really great insight. Any suggestion for monthly self reported productivity for employees using these forms? Any way to have password requirement? Can employees change data they submitted? Right now my boss is using excel but try to migrate to access to make data management easier

[@MyOnlineTrainingHub]

If you require password protection then you'd need to use another system e.g. Teams or SharePoint where they are authenticated by their Office/Microsoft 365 credentials. They can't modify the data they already entered unless you give them access to the Excel file.

[@susanverrall6443]

Great tutorial, I've managed to set up quite a lengthy form for data input. I've set a number of questions to numeric, put some dummy data in, and now want to generate a pivot table with the average values. However these display as 0. Checking the cell where the data is stored it has an inverted comma e.g. '5 so stored as text, and the data is left justified. How do I get the numeric values to be stored as numeric as you have done in the example at 8:30 mins. Thank you.

[@MyOnlineTrainingHub]

Hi Susan, I've reported this to Microsoft as a bug way back when I recorded this video. However, in the workaround is to use Power Query to get the data from the survey Excel file and convert the text values to numbers.

[@susanverrall6443]

@@MyOnlineTrainingHub Thank you.

[@susanverrall6443]

Me again with another question. I have created a form and have used an image to set out my companies privacy statement, however I noticed this comment after submitting a test form "Powered by Microsoft Forms | The owner of this form has not provided a privacy statement as to how they will use your response data. Do not provide personal or sensitive information." I can't see where a "privacy statement" can be added as part of the functionality of the form, currently I'm using an image at question 1. However if there's a better way of doing this please can you point me in the direction of a help page. Thank you

[@mait6898]

Hi Mynda, I wonder is there a way that the user can re-use their previously submitted request to re create the same request but with a little tweak to the answers they already provided? For user experience, there are couple requests that are almost the same and the requestor would like to re use what they have submitted before and submit it as next versions. The requestor find that it takes time to go through the questions over again when they already entered it and just need to tweak for other versions. Thanks for your help.

[@MyOnlineTrainingHub]

That sounds like a great idea, but currently Excel Forms doesn't have that functionality.

[@windwalker3046]

Would this be able to be done with using the "Quiz" format? Thus far I can't seem to be able to find a way to do it.

[@MyOnlineTrainingHub]

Not sure what 'this' is and not sure why you'd want to use the Quiz format.

[@udaracperera]

Awesome video thanks. is there a way to print the form as pdf get out a document on individual records

[@MyOnlineTrainingHub]

On the responses tab in Forms.Office.com, click on the ellipses above the 'Open in Excel' link and choose Print Summary. In the Printer dialog, choose "Microsoft Print to PDF"

[@udaracperera]

@@MyOnlineTrainingHub Thanks Mynda 👌🔥

[@zerocool200380]

Hi Mynda, quick question do you know if you can integrate these forms to sharepoint page? I want to create a sharepoint for my users once they access the page they click on a picture and the form starts and they can fill it Please let me know your thoughts

[@MyOnlineTrainingHub]

Sure can :-) Just get the embed code from the 'Share' options.

[@ParthKotecha]

Hi, I wanted to collect similar data for 10000 outlets. Is there any way I can feed the options for any particular question from a list? It'll be a great help. Also if we can branch the options for the same. Like selecting country, city, warehouse, salesperson, outlet - all in dropboxes And then collect sales.

[@ParthKotecha]

Stuck on this problem since over a month. Tried a few google APIs for google forms but no success.

[@MyOnlineTrainingHub]

No way to import options, but you can branch based on a selected answer via the ellipsis > branching.

[@silversolver7809]

Very well explained, thank you.

[@MyOnlineTrainingHub]

Thanks so much!

[@chengcheng7682]

Hi, Would like to ask for a question. I did set the restrictions for number but the data result show in excel is text format : '12345. But in your video is showing number format. Not sure why :(

[@MyOnlineTrainingHub]

Me neither, sorry. It sounds like the setting didn't get applied properly. Maybe you could delete that question and try setting it up again.

[@bhavikbrahmbhatt2867]

Maybe I was looking for this 👍

[@MyOnlineTrainingHub]

Hope it was useful :-)

[@olipeeeeee]

This is awesome. Love it

[@MyOnlineTrainingHub]

Great to hear, Matthias!

[@MorganChabalaJr]

Thank you so much! This was useful and very educative

[@MyOnlineTrainingHub]

Great to hear, Morgan :-)

[@kylejacobs1007]

mine doesnt have a file upload option so i am not sure how that function works....however, do we know if there is a way to have user upload multiple responses at once? For those that will have a lot of responses and would prefer to load them using a predefined excel template that is identical to the form?

[@MyOnlineTrainingHub]

Hi Kyle, it sounds like you don't have an Office/Microsoft 365 account and are accessing the old Forms via OneDrive Personal. Here they are called Forms Survey and won't have the functionality I describe in the video. For that, you need to log in via Forms.Office.com. In regards to uploading multiple responses, you'd need to use Power Automate to handle the multiple responses and automatically submit the forms for the user.

[@m.asifhussain1730]

Does it support voice recording input by user?

[@MyOnlineTrainingHub]

I’d have thought so, but I haven’t tested it.

[@Funkafella01]

How do you get the form icon in the toolbar, I went to add commands advanced, all commands I couldn’t get it on there like you have it next to tables

[@MyOnlineTrainingHub]

That icon is only available with a Microsoft 365 license.

[@Funkafella01]

@@MyOnlineTrainingHub I have a 365 license, are there steps I have to follow to put it on the toolbar?

[@glenngallemit5470]

Hello...it is nice presentation...i have a question though, i have already a prepared excel file that is filled up manually whrn you meet the person face-to-face... i am thinking of using the forms to fill up the excel file ahead of the meeting, however, i am thinking of manually entering the information from the automatic excel file as explained to the video to the excel file that i have created. Is there any way to automatically fill up the ready excel when they fill up the form?

[@MyOnlineTrainingHub]

Hi Glenn, I'm not sure what you mean, but if you want to point the form to an existing Excel file, then you can't do that. If you want to manually populate the Excel form table by entering data directly in the table, then you can. Probably best to just try it and see.

[@glenngallemit5470]

MyOnlineTrainingHub is there possibility with ms flow?

[@MyOnlineTrainingHub]

Sure, Flow can probably automate this.

[@aashraynalawade]

Hi, it was awesome video, just and few queries. Fee of our sales guys have open office installed on their system. Will this form work on their system. Also, if in using office 365 on my laptop (not online as shown in example) and the other end user using open office i.e spreadsheets. Will put out result be same as shown in the video. Actually there is small project we gonna do.its online training where around 20 branch manager will take trianing for almost 150 guys in various batches daily where they need to daily fill the attendance sheet and send accross to me on mail and I'll have to sit n collate all those 20 sheets daily. If you could answer ny query it would be great. I would like to share one bad experience. I had prepared one sheet with few macros in it. And I didn't knew some of our sales guys have open office spreadsheet where these macros didn't work and my that sheet was a big failure in those location. So this time before making any such thing just wanted to be double sure.

[@MyOnlineTrainingHub]

Hi Kiran, If your branch managers are simply entering the data, then this form will work because it is not dependent on Excel. You open the form in a web browser. This will save you a huge amount of data entry. However, if those same branch managers want to open the associated Excel file to see what data has been entered into the form, then they can if you give them permission to open the file through 'sharing', but it won't retain a connection to the form so it won't get any updates once it is downloaded. They would have to download it again to get the latest version. Only if you open it from OneDrive with your Office 365 account will you see the updates.

[@aashraynalawade]

@@MyOnlineTrainingHub Thanks mate for the quick query resolution.

[@Rain-of-fblthp]

I noticed that any numerical input in Forms is transcribed to Excel with a leading apostrophe, for example, if I enter 300 in Forms, it shows up as '300 in Excel. As a result, you can't easily play with the data in forms. Am I missing something or is there a workaround to this?

[@MyOnlineTrainingHub]

Yes, Dave, this is a very annoying 'feature'. I have reported this to the Excel team as a problem. In the meantime, you can use Power Query to get the data from the worksheet and fix the format.

[@Inquire98]

"Thank GOD", 🙏🏾 and thank you very much ☺️ Are your forms Excel version specific 🙄 Let me know 🤔

[@MyOnlineTrainingHub]

The form itself is web based, so it can be used from any device with a web browser and internet connection. Creating the form can also be done from the web via Forms.Office.com so no version dependency there either.

[@Inquire98]

@@MyOnlineTrainingHub Thank You 👍, thank you very much ☺️

[@Jahspecs1]

I wish Microsoft would make this more flexible... Like several questions on one page so when you print the form it can fit on one page

[@shawnward3494]

Great video

[@MyOnlineTrainingHub]

Glad you enjoyed it

[@freakris30]

Thank you, I learnt another important useful excel tip

[@MyOnlineTrainingHub]

Glad to hear that, Krishna!

[@lyshumka875]

I don't have "Forms for Excel" but "Forms Survey" in my Onedrive. Is there another step for me to get it to show up? When I clicked on "Forms Survey" it takes me to Forms but not Forms for Excel.

[@MyOnlineTrainingHub]

You can get to them from this link: forms.office.com/

[@julesgouton945]

Is it possible if this can work offline? If no, do you know of any alternatives to Microsoft form?

[@MyOnlineTrainingHub]

Hi Jules, No you can't use forms offline, sorry. I don't know of a workaround/alternative.

[@Disaenz10]

What if I have an existing Forms and answers and I want to move these responses to an online excel. Is it possible?

[@MyOnlineTrainingHub]

Create your form, then open the associated Excel file and add your data to the table.

[@MrGulsaeed]

Hi, when the data is imported from forms to the Excel table, the numbers appear as text. Even after changing the column format from Text to #, the new data still appears as text. Any suggestions would be appreciated.

[@MyOnlineTrainingHub]

Yep, I’ve reported this to Microsoft. In the meantime you can use Power Query to get the survey data and transform the number column format.

[@MrGulsaeed]

@@MyOnlineTrainingHub Thank you

[@mostafa4321]

Hi hope all is well with you in these crazy times the whole world is living nowadays. I am a big fan I watch your channel religiously I have an excel project I am working on and could not get to the bottom of it. here are the details 1. I have a workbook with sheets one capturing client id , the creditor's follow-ups date 2. Sheet two have a table with months headers 3. The goal is as the data is being entered in sheet 1 I want The different dates calculated to be extracted from sheet1 and populate in the table in sheet 2 under the appropriate month column eg.If in sheet one, the month calculated is 06/12/2020 I want that date to populate under June column and so on I can provide the workbook

[@MyOnlineTrainingHub]

You should use a PivotTable to generate sheet 2.

[@DDBEIndia]

Is there a way to do it the other way around... I mean like converting Excel data to forms.. We can do it in Google forms but I prefer ms Excel. Please help

[@MyOnlineTrainingHub]

Not that I'm aware of.

[@21121990jay]

Hi , could you please show how did you exactly make that live link excel which is continuously updating even after download it?

[@MyOnlineTrainingHub]

Hi Jitesh, the key is to ensure you create the Form from OneDrive or Excel Online.

[@21121990jay]

@@MyOnlineTrainingHub ! Thanks I've connected but excel showing on onedrive. I downloaded a copy from onedrive and then filed one more form. I can see the one drive excel gets updated but the one i downloaded hasn't get refreshed

[@MyOnlineTrainingHub]

It sounds like you haven't synced your hard drive to backup to OneDrive, so once you download the file there is no connection to the original file. If you open it in Excel Online, instead of downloading it, the connection will persist.

[@21121990jay]

@@MyOnlineTrainingHub ! Thanks. Works fine now :)

[@uploadsnovatrack5856]

I tried connecting the form i built to an excel file using Power Automate, but it just wasn't working. My Forms has a (Preview) to it, why is that and how to I change it to your type?

[@MyOnlineTrainingHub]

All Forms are currently in Preview. It shouldn't make any difference in regards to using Power Automate though.

[@joshuamerriss6461]

Question: Will I as the creator get notifications when a user has finished filling out a form?

[@MyOnlineTrainingHub]

Hi Joshua, not by default. You could set up a Power Automate (Flow) to notify you when the Excel file changes though.

[@catherinegould6662]

Thanks for that, however I would recommend using Flow instead or Power Query to create a new workbook to add new columns or rearrange them for analysis

[@MyOnlineTrainingHub]

Great suggestion! Flow is a whole other learning curve...many people already know Power Query, although not enough :-)