Create an Excel Receipt Template for Teams Effortlessly

Excel receipt template for teams

welcome back friends in this tutorial I am going to explain how to use this mini application to effectively track the details of Courier receipt suppose that if you are working in an organization as a front desk officer and you are looking for a Microsoft Excel template to track the details of the cers or physical mails you are here in the right place first I will explain each and every features of this application and at the end of video I will provide you the download link and instructions to set it up for first use after you open the downloaded Excel file you will see this app launch sheet here you have the button to launch The Courier receipt tracker application hover over your mouse here and click the application window opens this application has three parts first is the record entry section second is the data export section and third one is the database display section in record entry there is a form to input the data it Con contains total eight Fields these are date of receipt courier company name tracking number sender name and address receiver name and address package contents Handover status and Handover date except Handover date all other fields are mandatory if you missed to input value in a field you cannot submit or enter your data in the system if you select yes in the Handover status then Handover date also becomes mandatory field in the data export section you can export the data that you have entered in a new Excel workbook if you want to export data for a specific date range then you have to first select the from and to date then click on this export selected button if you want to export whole data click on this export all button in this database section all data that have been entered in this application will be visible in the bottom part of the application window there are four buttons to control the entry this this submit button is to enter the details into the system cancel button is to cancel the entry if you have entered few details and if you need to cancel it click on this button if you need to modify the previously entered record then use this update record button to delete a record from the system use this delete record button in the top left part of the screen there is a button to save your data click on this button to save your data entry in the Excel file note that submit button only transfers the record into the system to save the enter records you must click on this save your data button let's operate this application practically by entering some dummy data of Courier receipt if you are entering the record for the current date or today's date the date will be given automatically no need to select date here but if you are entering details for some other date click on this calendar icon to pick up a date let me click on 5th of November here you see see date is entered in the field click on courier company name field then input the courier company from which Goods is received press Tab Key to go to next field or you can also click in the Box input all the details of receipt click on the submit button to send these details into the application here you see the record is placed in the database click on save your data button to save the Excel workbook data has been saved let's add here a few more records before using other features here you see all records are visible in the database after entering the data if you figured out some mistake then modify the record by double clicking on it for example let me double click on this record after double click the details goes into the entry section where you can modify the record here let's change the courier company name after modifying the record click on update record button record has been updated to delete a record single click on the record to delete then click on delete button it will ask you to confirm the delete operation click on yes record deleted successfully if you want to export the data to a new Excel sheet click on this export all button here you see data has been exported to a new Excel work book to export data for a specific date range first select the date range using the calendar let me select here the date from November 5th to November 6th click on this export selected button here you see data has been exported for the selected date range only after you make change in your database never forget to click on this save your data button so that was all about the operating guideline for this mini application to track the details of Courier or mail receipt if this application is useful for your work or business download the application for free from the link displayed in the screen or you can also visit video description section below thank you so much for watching stay connected by subscribing this channel for similar videos in future