Scribd
Upload
99 views5 pages

Data Entry Tutorial: Step-by-Step Guide

This tutorial provides step-by-step instructions for data entry using Excel, including loading data from a database, creating data entry forms, and setting up data validation. It also covers creating lists and summarizing data from multiple tabs for faculty KPIs. Users are guided through the process of linking data between sheets and testing their forms for functionality.

Uploaded by

Nuraina Azryn
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
99 views5 pages

Data Entry Tutorial: Step-by-Step Guide

This tutorial provides step-by-step instructions for data entry using Excel, including loading data from a database, creating data entry forms, and setting up data validation. It also covers creating lists and summarizing data from multiple tabs for faculty KPIs. Users are guided through the process of linking data between sheets and testing their forms for functionality.

Uploaded by

Nuraina Azryn
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Page |1

Tutorial 1: Data entry

1.1 From any database (txt file)

Figure 1: Example of raw file from database

i. Check delimiters correct or not.


ii. Click Load, button then raw data will be transferred to excel.

iii. Rename your tab name to “INFO JABATAN” and save your workbook.

1.2 Data entry form (by wizard)


i. By default Form commands is not listed in the ribbon. For first time user u need to activate
the command before you start. Go to the ribbon right click customize quick access
toolbar All commands select Form click Add button click OK button.

By: Ts. Nur Hasni Nasrudin


P age |2

ii. Then your form commands will be appeared in quick access toolbar.

iii. Select all Kod Jabatan and Nama Jabatan then click insert table check option “My table
has header” click OK button.

iv. Select the table and click Form commands icon from quick access toolbar. Your form
automatically generated.

By: Ts. Nur Hasni Nasrudin


P age |3

v. Freely test your form such as add new data, delete data and navigate.
vi. Now we try to add data validation to the field Kod Jabatan. Highlight Kod Jabatan column
go to Data tab Data validation. Setup the length and the error alert.

vii. Now, test your form by entering wrong data.

By: Ts. Nur Hasni Nasrudin


Page |4

1.3 Creating list


Create new sheet and named it as Staff list.
- Highlight the cell → click Data tab → Data validation→List

- Click icon on right side to define the source of list.

-Output

By: Ts. Nur Hasni Nasrudin


Page |5

1.5 Data from different tab


For this exercise we will try to create a summary tab for faculty KPI that received data from
individual tab that represent faculty A, B and C.
1. Create a KPI table for faculty A as per example below. You are allow to change the value and the
header if needed.

2. Copy the tab to create Faculty B and Faculty C record. Right click on the tab select move or copy
select move to end click ok

3. Once faculty B tab created, freely to change the records. Do the same steps to create records for
faculty C.
4. Below is the example of summary table. The value for penerbitan, inovasi, konsaltasi and Geran come
from the faculty A records.
How to received value from others tab
Go to the particular cell then type ='KPI-FakultiA'!C7 . KPI-fakulti is tab/sheet name while C7 is the
cell that being referred. Do the same for faculty B and C. You also can use mouse to select the sheet
and cell.

Now try to change the value at any faculty records. Is the summary value change accordingly? If yes,
congratulation u did it.
Create a hyperlink from on sheet to another to help u easily navigate and access the records.

By: Ts. Nur Hasni Nasrudin

You might also like