Create an Excel database and data entry form. Excel 1690 magic trick.
Download the Excel file: https://excelisfun.net/files/EMT1690.xlsx
Learn how to create an Excel database. Add a data entry form. Add a button to the toolbar to open the form. Technically, we are not creating a real database, but in Excel, when you want to store data, you use the Excel Table functionality.
The subjects:
1. (00:00) Introduction.
2. (00:19) Step 1: Field names with format.
3. (00:44) Step 2: First recording with correct number formatting
4. (03:21) Step 3: Convert to Excel Table
5. (04:38) Step 4: Add a form button to the Quick Access Toolbar.
6. (06:14) Step 4, Part 2: Use the form to add records.
7. (07:25) Summary, closing and video links
Learn how to create an Excel database. Add a data entry form. Add a button to the toolbar to open the form. Technically, we are not creating a real database, but in Excel, when you want to store data, you use the Excel Table functionality.
The subjects:
1. (00:00) Introduction.
2. (00:19) Step 1: Field names with format.
3. (00:44) Step 2: First recording with correct number formatting
4. (03:21) Step 3: Convert to Excel Table
5. (04:38) Step 4: Add a form button to the Quick Access Toolbar.
6. (06:14) Step 4, Part 2: Use the form to add records.
7. (07:25) Summary, closing and video links
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
No Comments