Electronically Signed Excel Made Easy

Electronically signing spreadsheet

options for sign in sheets and gathering data there are several options available let's start with Microsoft forms and we'll use our office 365 account let's go to portal office comm you'll log in with your work email and your password is requested if you don't see Microsoft forms listed you can tap Explorer or your apps find forms and tap on it click new form you can give it a name and then you can choose what type of questions you'd like to ask on the sign-in sheet let's say that the first question might be banner ID and that could be a short answer we don't need a paragraph will just be an ID then the next question might be status that could be a choice so we might have teacher student staff and let's add one more question which could also be a choice item use let's say lounge and when done we can click share and let's say anyone with link can respond and we'll copy the link and now wherever use the computer where you want people to sign in just open up a blank web page and paste the link and this will be the sign-in that people will see people can enter their information and they can click Submit when done and then you could click submit another response or the person that comes along next can click submit another response and enter the information and I'm gonna enter a few here so we've entered some data into the form and how we find our form to look at the data I went back to Puerto us comm and this time since I've recently used forms it shows up in my main menu if it didn't once again you could explore all app so I'm gonna tap forms and here's the sign-in sheet notice it says 8 responses and I can click responses and it gives us summary as you can see it makes charts and everything but you could also open in Excel here at the top right and downloads and offline Excel spreadsheet let's tap on that to open and here is the data I'm gonna tap enable editing and notice what it did here it automatically enter the date and time even though we didn't see that on the form it also added a block for email and name that's if folks had signed in with their information to it to office we would have seen this information but we didn't ask for this information and we didn't have people sign in to office to use the form but here's the information that people enter their banner ID some people skip the status here and item used now this opens up in a table that we can use a filter on let's say that we only want to see the items used or we want to see just the lounge use we could click the drop down uncheck select all choose lounge and just see the lounge use and what days and times it was used and we can also use the filtering on the start and completion time but you can see how you can break it down by times months year and day and you could also use a pivot table to analyze this data if it start times here and count of start times and we can see the 10:00 a.m. hour happened eight times then we can see the minutes and how they happened and then you could break down the minutes now you can see how often they happen probably seconds there so that's one way to use this with Marcus all forms but also within your Marcus off portable you can make an Excel form and this will save your data to an online spreadsheet let's close this and this time let's open Excel we'll go to a new blank workbook will tap the insert tab forms new form and then we will build this in much the same way that we will build the Microsoft forms but I'll show you the difference here in a minute let's just add a couple of test questions so I've entered some responses and we're back to the Excel form and notice it automatically goes to the form I haven't named the form so I automatically named it book two but notice how it stays online but you still get the same data you get the start time and you get the information that the customer entered so now with this information you could do your calculations online you can share this with co-workers online or you can open this into offline Excel if you want it to file save as and we could click download a copy another option is Google Forms and you need a Google account for this I just went to forms google.com it shows forums I've made before and it has some template forms already made for you or you can start your own blank form let's just choose event registration that's an example of one that's already made for us notice that I already have some data made up for us and notice this decoration here you could also decorate your Microsoft forms you would just go to themes and there were themes in Microsoft forms and they're also themes and Google Forms I want to change this thing so just like using the Excel form in Microsoft you can enter information you can see responses and once responses are there you can open up the responses in a spreadsheet it would be a Google sheet and a lot of the processes and Google sheets are the same as in this excel and also you could say Google sheets as an Excel document if you like you can just download it to excel so those are just some quick examples on using Google Forms Microsoft Forms and Microsoft Excel forms as a sign-in sheet for more information check out our Facebook page facebook.com slash NLC Infotech and we have lots of different software training there and our youtube channel youtube.com slash user slash NALC IT Help Desk