I hope this helps you understand how to create a database template in Excel. The database table will automatically increase when you enter the new line. Whenever a new data line input to your database, it will add that line to the database table and apply the formats according to your previous data formats. If you click on “Banglore”, it will filter the data related to Banglore.Īfter setup all these settings, you can add your data whenever a new customer joins into the business. Two slicers are available in our spreadsheet. I tick the checkboxes City and payment terms. Tick the checkboxes for which you want the slicers.
Click on the slicer option then the slicer menu will appear as below. We can create a slicer also as per requirement. You can create a pivot table also using “Summarize with Pivotable”. If you want to remove duplicates in any of the columns, use “Remove duplicates”. You can convert the database into normal data by using the option “Convert to range”. The moment you select the database name, it will take us to our database. Click on the drop-down of the name box it will show our database name. You may think about the use of giving the name to the Database. I give the name “Database”, as shown in the below screenshot. We can give the name to the database using the option “Table name” on the left-hand corner in the design menu. Illustration #3 – Giving a Name to Database The below options are quite understandable if you check and uncheck the checkboxes, you can find the difference in your database table. You can use the below options as per your requirement. If you want to change the style of your database, select the required style format in the “Table Style “ section on the right. Remember the “Design” option will enable only if you select any of the cells in your database once you select the Design option, the following options available for your database.
You can change the database design as you by clicking on the option “Design” highlighted with the red color box in the screenshot. Illustration #2 – Change the Database Format Now your database table looks like below. Here we selected the headers also hence I leave it as checked. Untick the checkbox “My table has headers” option if you do not select your data’s headers. Select the entire data and click on the insert button on the top left corner.Ĭlick on the table option under the “Insert” menu tab.Ī pop-up box will appear asking for the table address it took that range as the data is already selected. Now it’s time to convert the data into the database table. After applying all the formats, save the table. If there is a date available in your data, apply the required format for your date.