 Today we're going to show you how to create a form for collecting and organizing your data using Excel 2016. This is important to know stuff, especially when working with a lot of data. Rod here and welcome to Burn to Learn. In this exercise we're going to use three values. First name, last name and email. First we have to set up the table headers. Here's how. Type the words first name in cell A1, last name in cell B1 and email in cell C1. Now select cells A1 through C1. Then go to the menu bar and click on insert and then table. We could use a shortcut by pressing control T but we're going to use the menu insert option instead. Now check to make sure the data information is correct. Then select the option my table has headers and then click OK. Now go to the menu bar again and click on data. We want to find the form button but it's not there on the menu. So we'll have to create and add a form button and here's how you do that. Go to file and scroll down to the end and select options. Now go down the general column on the left and select customize ribbon. Then in the choose commands from section on the left hit the down arrow and select commands not in the ribbon. Now scroll down the box on the left and select the option form. Then click on new group in the right column and the word new group automatically appears on the list of data. Now click the rename button and type in a new name. We're going to rename it data form. We can also add an icon if we want. Now click the add button in the middle to add the form option to the data form. Then click OK and the new form button appears on the data menu. Pretty cool stuff right? Please remember to like this video and leave a comment after watching. We love your feedback. Now click on the form button and a box for giving instructions to Excel appears. Fill in the first name. We're going to use my name Rodney. Then fill in the last name. My last name is Davis. Now fill in my email which is admin at burn to learn dot com. Then click the new button to save the data and Excel automatically moves to the next cell. So let's make another entry from our database with John Smith with an email of John at gmail.com. You can put in as many entries from your database as you want. If you want to edit the form simply scroll to where you want to make the edit and type it in. If you want to delete something just click the delete button then click OK and it's deleted. Now you can create a data form any time you need to collect and organize data from a database using Excel 2016 and you can review and practice the steps we showed you by clicking on the exercise file. Please remember to like this video, share it with friends and leave a comment and please subscribe to our channel so you can receive future videos automatically. Thanks so much for watching! More complex computer skills or needs. Three, an interactive coding platform to teach you coding skills and concepts. Four, an exclusive video library not on YouTube to build your knowledge on many topics. Five, a placeholder that automatically returns to the exact place where you stopped watching. Six, downloadable exercise files to lock in your learning on especially tough topics. And seven, continued access to our free videos on YouTube. So click this button to begin a 14-day free trial. After the free trial you can join the inner circle for a low price of $9.99 per month. Use your free trial to look around and check us out. Then start learning computer skills on an accelerated basis on Burn to Learn.