Skip to Content

Masuk/Daftar

Cara Membuat Daftar Inventaris di Excel

Disusun bersama Staf wikiHow

Artikel wikiHow ini akan mengajarkan kepada Anda cara mengelola inventaris bisnis atau perusahaan menggunakan lembar lajur Excel pada komputer Windows atau Mac. Anda bisa menggunakan templat daftar inventaris yang sudah diformat, atau membuat sendiri lembar lajur baru secara manual.

Metode 1

Metode 1 dari 2:

Menggunakan Templat

{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/c4\/Create-an-Inventory-List-in-Excel-Step-1-Version-5.jpg\/v4-460px-Create-an-Inventory-List-in-Excel-Step-1-Version-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c4\/Create-an-Inventory-List-in-Excel-Step-1-Version-5.jpg\/v4-728px-Create-an-Inventory-List-in-Excel-Step-1-Version-5.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Program ini ditandai oleh ikon berwarna hijau tua dengan huruf “X” putih.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/7\/78\/Create-an-Inventory-List-in-Excel-Step-2-Version-5.jpg\/v4-460px-Create-an-Inventory-List-in-Excel-Step-2-Version-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/78\/Create-an-Inventory-List-in-Excel-Step-2-Version-5.jpg\/v4-728px-Create-an-Inventory-List-in-Excel-Step-2-Version-5.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

2
Klik bilah pencarian. Bilah ini berada di bagian atas jendela Excel.
- Pada komputer Mac, klik menu “ File ” di pojok kiri atas layar terlebih dahulu, kemudian pilih “ New from Template… ” dari menu drop-down .
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/9\/9e\/Create-an-Inventory-List-in-Excel-Step-3-Version-5.jpg\/v4-460px-Create-an-Inventory-List-in-Excel-Step-3-Version-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/9e\/Create-an-Inventory-List-in-Excel-Step-3-Version-5.jpg\/v4-728px-Create-an-Inventory-List-in-Excel-Step-3-Version-5.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Tikkan inventory list pada bilah pencarian di bagian atas halaman, kemudian tekan tombol ↵ Enter . Daftar templat pengelolaan inventaris akan ditampilkan.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/2\/2f\/Create-an-Inventory-List-in-Excel-Step-4-Version-5.jpg\/v4-460px-Create-an-Inventory-List-in-Excel-Step-4-Version-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/2f\/Create-an-Inventory-List-in-Excel-Step-4-Version-5.jpg\/v4-728px-Create-an-Inventory-List-in-Excel-Step-4-Version-5.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

4
Pilih templat. Klik templat daftar inventaris yang paling sesuai. Halaman pratinjaunya akan dibuka.
- Setiap templat daftar inventaris menawarkan beragam fitur. Jika Anda tidak menyukai opsi yang dipilih, tekan tombol Esc untuk kembali ke halaman templat.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/1a\/Create-an-Inventory-List-in-Excel-Step-5-Version-5.jpg\/v4-460px-Create-an-Inventory-List-in-Excel-Step-5-Version-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/1a\/Create-an-Inventory-List-in-Excel-Step-5-Version-5.jpg\/v4-728px-Create-an-Inventory-List-in-Excel-Step-5-Version-5.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Tombol ini berada di sisi kanan jendela pratinjau templat.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/85\/Create-an-Inventory-List-in-Excel-Step-6-Version-5.jpg\/v4-460px-Create-an-Inventory-List-in-Excel-Step-6-Version-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/85\/Create-an-Inventory-List-in-Excel-Step-6-Version-5.jpg\/v4-728px-Create-an-Inventory-List-in-Excel-Step-6-Version-5.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Proses ini memakan waktu beberapa detik. Setelah templat dibuka, Anda bisa beralih ke langkah berikutnya.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/ca\/Create-an-Inventory-List-in-Excel-Step-7-Version-5.jpg\/v4-460px-Create-an-Inventory-List-in-Excel-Step-7-Version-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/ca\/Create-an-Inventory-List-in-Excel-Step-7-Version-5.jpg\/v4-728px-Create-an-Inventory-List-in-Excel-Step-7-Version-5.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

7
Masukkan informasi inventaris. Untuk mengubah kotak-kotak yang sudah terisi teks, klik dua kali kotak, hapus nomor atau teks yang ada, dan masukkan informasi baru. Meskipun templat terpilih memiliki opsi yang sedikit berbeda, setiap daftar inventaris biasanya mencakup opsi-opsi berikut:
- ” Item Number ” – Nomor inventaris produk/barang (SKU).
- ” Item Name ” – Nama atau label deskriptif produk/barang.
- ” Item Cost ” – Harga satu produk/barang.
- ” Number in Stock ” – Jumlah stok produk.
- ” Net Value ” – Harga total bersih stok produk.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/e9\/Create-an-Inventory-List-in-Excel-Step-8-Version-5.jpg\/v4-460px-Create-an-Inventory-List-in-Excel-Step-8-Version-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e9\/Create-an-Inventory-List-in-Excel-Step-8-Version-5.jpg\/v4-728px-Create-an-Inventory-List-in-Excel-Step-8-Version-5.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

8
Simpan pekerjaan. Untuk menyimpannya:
- Windows – Klik menu “ File ”, klik “ Save As ”, klik dua kali “ This PC ”, pilih lokasi penyimpanan di sisi kiri jendela, tikkan nama dokumen (mis. "Daftar Inventaris") pada kolom teks " File name ", dan klik “ Save ”.
- Mac – Klik menu “ File ”, klik “ Save As... ”, masukkan nama dokumen (mis. "Daftar Inventaris") pada kolom " Save As ", tentukan lokasi penyimpanan dengan mengeklik kotak " Where " dan memilih folder yang diinginkan, dan klik “ Save ”.
Iklan

Metode 2

Metode 2 dari 2:

Membuat Daftar dari Awal

{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/6\/61\/Create-an-Inventory-List-in-Excel-Step-9-Version-4.jpg\/v4-460px-Create-an-Inventory-List-in-Excel-Step-9-Version-4.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/61\/Create-an-Inventory-List-in-Excel-Step-9-Version-4.jpg\/v4-728px-Create-an-Inventory-List-in-Excel-Step-9-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Program ini ditandai oleh ikon berwarna hijau tua dengan huruf “X” putih.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/a4\/Create-an-Inventory-List-in-Excel-Step-10-Version-2.jpg\/v4-460px-Create-an-Inventory-List-in-Excel-Step-10-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a4\/Create-an-Inventory-List-in-Excel-Step-10-Version-2.jpg\/v4-728px-Create-an-Inventory-List-in-Excel-Step-10-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

2
Klik Blank workbook . Kotak ini berada di pojok kiri atas jendela.
- Lewati langkah ini pada komputer Mac.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/cd\/Create-an-Inventory-List-in-Excel-Step-11-Version-2.jpg\/v4-460px-Create-an-Inventory-List-in-Excel-Step-11-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/cd\/Create-an-Inventory-List-in-Excel-Step-11-Version-2.jpg\/v4-728px-Create-an-Inventory-List-in-Excel-Step-11-Version-2.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":545,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

3
Buatlah judul daftar inventaris. Pada kotak-kotak berikut, masukkan judul-judul ini:
- A1 - Nomor Produk
- B1 - Nama Produk
- C1 - Harga
- D1 - Jumlah Stok
- E1 - Harga Total Stok
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/2\/2e\/Create-an-Inventory-List-in-Excel-Step-12-Version-2.jpg\/v4-460px-Create-an-Inventory-List-in-Excel-Step-12-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/2e\/Create-an-Inventory-List-in-Excel-Step-12-Version-2.jpg\/v4-728px-Create-an-Inventory-List-in-Excel-Step-12-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Klik ruang atau pembatas antara dua huruf kolom (mis. “ A ” dan “ B ”) di bagian atas lembar lajur, kemudian seret kursor ke arah kanan untuk memperlebar kolom.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/9\/99\/Create-an-Inventory-List-in-Excel-Step-13-Version-2.jpg\/v4-460px-Create-an-Inventory-List-in-Excel-Step-13-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/99\/Create-an-Inventory-List-in-Excel-Step-13-Version-2.jpg\/v4-728px-Create-an-Inventory-List-in-Excel-Step-13-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Klik kotak “ A2 ”, kemudian tikkan nomor inventaris barang (mis. 123456 ) dan tekan tombol ↵ Enter .
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/2\/2a\/Create-an-Inventory-List-in-Excel-Step-14-Version-2.jpg\/v4-460px-Create-an-Inventory-List-in-Excel-Step-14-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/2a\/Create-an-Inventory-List-in-Excel-Step-14-Version-2.jpg\/v4-728px-Create-an-Inventory-List-in-Excel-Step-14-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Klik kotak “ B2 ”, kemudian masukkan nama resmi barang (mis. nugget ikan ).
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/58\/Create-an-Inventory-List-in-Excel-Step-15-Version-2.jpg\/v4-460px-Create-an-Inventory-List-in-Excel-Step-15-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/58\/Create-an-Inventory-List-in-Excel-Step-15-Version-2.jpg\/v4-728px-Create-an-Inventory-List-in-Excel-Step-15-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Klik kotak “ C2 ”, kemudian masukkan harga untuk satu produk (mis. 27.500 ).
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/9\/97\/Create-an-Inventory-List-in-Excel-Step-16-Version-2.jpg\/v4-460px-Create-an-Inventory-List-in-Excel-Step-16-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/97\/Create-an-Inventory-List-in-Excel-Step-16-Version-2.jpg\/v4-728px-Create-an-Inventory-List-in-Excel-Step-16-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Klik kotak “ D2 ” dan masukkan jumlah stok produk yang ada (mis. jika Anda memiliki 80 bungkus nugget ikan, tikkan 80 ).
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/2\/26\/Create-an-Inventory-List-in-Excel-Step-17-Version-2.jpg\/v4-460px-Create-an-Inventory-List-in-Excel-Step-17-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/26\/Create-an-Inventory-List-in-Excel-Step-17-Version-2.jpg\/v4-728px-Create-an-Inventory-List-in-Excel-Step-17-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

9
Masukkan rumus harga bersih total ( net value ). Klik kotak “ E2 ”, kemudian tikkan rumus =C2*D2 pada kotak dan tekan tombol ↵ Enter . Anda bisa langsung melihat harga total stok pada kotak tersebut.
- Anda bisa mengulangi rumus umum ini pada setiap kotak di kolom "Harga Total Stok". Pastikan Anda mengganti entri “ C2 ” dan “ D2 ” dengan huruf dan nomor kotak yang sesuai (mis. jika Anda ingin mengalikan nilai pada kotak “ C10 ” dan “ D10 ”, gunakan huruf dan nomor kotak tersebut sebagai pengganti “ C2 ” dan “ D2 ”).
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/c5\/Create-an-Inventory-List-in-Excel-Step-18-Version-2.jpg\/v4-460px-Create-an-Inventory-List-in-Excel-Step-18-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c5\/Create-an-Inventory-List-in-Excel-Step-18-Version-2.jpg\/v4-728px-Create-an-Inventory-List-in-Excel-Step-18-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Ulangi proses di atas untuk setiap entri inventaris. Gunakan satu baris untuk setiap produk hingga daftar Anda lengkap.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/c7\/Create-an-Inventory-List-in-Excel-Step-19-Version-2.jpg\/v4-460px-Create-an-Inventory-List-in-Excel-Step-19-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c7\/Create-an-Inventory-List-in-Excel-Step-19-Version-2.jpg\/v4-728px-Create-an-Inventory-List-in-Excel-Step-19-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

11
Simpan pekerjaan. Untuk menyimpannya:
- Windows – Klik menu “ File ”, klik “ Save As ”, klik dua kali “ This PC ”, pilih lokasi penyimpanan di sisi kiri jendela, tikkan nama dokumen (mis. "Daftar Inventaris") pada kolom teks " File name ", dan klik “ Save ”.
- Mac - Klik menu “ File ”, klik “ Save As... ”, masukkan nama dokumen (mis. "Daftar Inventaris") pada kolom " Save As ", tentukan lokasi penyimpanan dengan mengeklik kotak " Where " dan memilih folder yang diinginkan, dan klik “ Save ”.
Iklan

Tips

Anda juga bisa menambah lembar baru pada buku pekerjaan dengan mengeklik tombol “ ＋ ” di pojok kiri bawah halaman.

Iklan

wikiHow Terkait

Iklan

Tentang wikiHow ini

Disusun bersama :

Staf Penulis wikiHow

Artikel ini disusun oleh tim penyunting terlatih dan peneliti yang memastikan keakuratan dan kelengkapannya.

Tim Manajemen Konten wikiHow memantau hasil penyuntingan staf kami secara saksama untuk menjamin artikel yang berkualitas tinggi. Artikel ini telah dilihat 70.810 kali.

Daftar kategori: Microsoft Office

Cetak

Halaman ini telah diakses sebanyak 70.810 kali.

Apakah artikel ini membantu Anda?

Iklan

-

-

503

.mwimg a.image{display:none}#header_logo{display:none}#cse-search-box{display:none}#cse-search-box-noscript{display:block !important}#cse-search-box-noscript .cse_q{color:#FFF;background-color:#B3CE9C}.wh_search .cse_q{width:88%}#mw-mf-main-menu-button{display:none;visibility:hidden}.header .search{display:none}#search_footer .cse_sa{background-image:url(/extensions/wikihow/mobile/images/white_mag.png);background-size:22px}.related_box{display:block;background:#EEE;border:5px solid #FFF;vertical-align:bottom;width:127px;background-size:180px;float:left;height:120px;position:relative}.related_box p{line-height:15px !important;font-size:13px;background-color:rgba(67,95,44,.4);color:#FFF;font-weight:bold;padding:8px;margin:0 !important;position:absolute;bottom:0}#noscript_header_logo{display:table-cell;vertical-align:middle;background-position:50% 77%;background-repeat:no-repeat;background-image:url(/extensions/wikihow/mobile/images/wikihow_logo_230.png);background-size:105px;width:auto;height:51px;padding:0 14px}.articleinfo{display:none}#iorg_free_data{z-index:50;width:100%;position:fixed}#ara_recommendations{display:none}

Design a Mobile Website

View Site in Mobile | Classic

Share by: