Cara Memantau Beberapa Proyek dalam Excel pada Windows atau Mac

Unduh PDF
Disusun bersama Staf wikiHow

Unduh PDF

Artikel wikiHow yang satu ini akan menjelaskan cara menggunakan templat Microsoft Excel untuk memantau beberapa proyek.

Langkah

Unduh PDF
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/e5\/Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-1.jpg\/v4-460px-Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-1.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e5\/Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-1.jpg\/v4-728px-Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Buka https://analysistabs.com/project/tracking/templates/excel/multiple/#bm1 dalam peramban web. Situs ini berisi templat Excel gratis bernama Analysistabs yang bisa mengelola beberapa proyek dan tugas. [1]
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/57\/Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-2.jpg\/v4-460px-Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/57\/Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-2.jpg\/v4-728px-Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-2.jpg","smallWidth":460,"smallHeight":349,"bigWidth":728,"bigHeight":552,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Langkah ini akan mengunduh templat ke dalam folder Downloads komputer.
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/e0\/Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-3.jpg\/v4-460px-Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e0\/Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-3.jpg\/v4-728px-Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-3.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":548,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Yaitu yang bernama ANAYLSISTABS-Multiple-Project-Tracking-Template-Excel.xslm di dalam folder Downloads . Fail kini akan dibuka di Excel.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/47\/Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-4.jpg\/v4-460px-Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-4.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/47\/Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-4.jpg\/v4-728px-Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-4.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":551,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Yaitu salah satu lembar yang ada di bawah buku kerja.
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/a8\/Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-5.jpg\/v4-460px-Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a8\/Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-5.jpg\/v4-728px-Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-5.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Masukkan semua proyek berjalan beserta perinciannya, termasuk tugas, personel, tanggal mulai dan tanggal penyelesaian yang diharapkan. Anda juga bisa menambahkan atau menghapus kolom dan baris agar sesuai dengan kebutuhan proyek.
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/3b\/Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-6.jpg\/v4-460px-Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-6.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3b\/Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-6.jpg\/v4-728px-Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-6.jpg","smallWidth":460,"smallHeight":342,"bigWidth":728,"bigHeight":541,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Jika diminta, berikan nama fail baru dan simpan ke folder pilihan Anda.
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/81\/Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-7.jpg\/v4-460px-Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-7.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/81\/Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-7.jpg\/v4-728px-Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-7.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Letaknya di bawah buku kerja. Langkah ini akan membuka detail untuk proyek pertama.
  8. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/4f\/Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-8.jpg\/v4-460px-Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-8.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/4f\/Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-8.jpg\/v4-728px-Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-8.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Masukkan nama proyek, pelanggan, dan manajer ke tempat kosong yang sesuai.
  9. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/86\/Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-9.jpg\/v4-460px-Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-9.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/86\/Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-9.jpg\/v4-728px-Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-9.jpg","smallWidth":460,"smallHeight":342,"bigWidth":728,"bigHeight":542,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Letaknya di atas panel kanan. Sebuah daftar proyek tambahan akan muncul.
  10. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/3b\/Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-10.jpg\/v4-460px-Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-10.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3b\/Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-10.jpg\/v4-728px-Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-10.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Langkah ini akan membuka versi terbaru dari lembar terakhir yang Anda kerjakan.
  11. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/ec\/Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-11.jpg\/v4-460px-Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-11.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/ec\/Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-11.jpg\/v4-728px-Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-11.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Setelah selesai, Anda bisa lanjut memilih proyek dan menambahkan detail pada semuanya.
  12. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/e7\/Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-12.jpg\/v4-460px-Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-12.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e7\/Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-12.jpg\/v4-728px-Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-12.jpg","smallWidth":460,"smallHeight":342,"bigWidth":728,"bigHeight":541,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Perubahan apa pun pada lembar ini akan tercermin di dalam lembar Project Plan dan Project Summary .
  13. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/f\/fc\/Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-13.jpg\/v4-460px-Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-13.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/fc\/Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-13.jpg\/v4-728px-Track-Multiple-Projects-in-Excel-on-PC-or-Mac-Step-13.jpg","smallWidth":460,"smallHeight":342,"bigWidth":728,"bigHeight":541,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Iklan


wikiHow Terkait

Cara
Memperbesar Volume Komputer
Cara
Memperbaiki Laptop yang Tidak Mengisi Daya
Cara
Mengatur Kecerahan Layar di Komputer Windows 7
Cara
Mengatur Komputer untuk Mengakses LAN
Cara
Mematikan Komputer Secara Otomatis pada Waktu Tertentu
Cara
Menghubungkan Laptop ke Proyektor
Cara
Menutup Jendela Aplikasi pada Komputer dan Ponsel
Cara
Mengetikkan Simbol pada Laptop
Cara
Menghubungkan Printer ke Komputer Anda
Cara
Menghubungkan Perangkat Audio ke Komputer
Cara
Membalikkan Layar Komputer Anda
Cara
Menonaktifkan Tombol Function
Cara
Menggunakan Aplikasi AirDroid pada Android
Cara
Menghubungkan Headset ke PC
Iklan

Referensi

  1. ↑ https://analysistabs.com/project/tracking/templates/excel/multiple/#bm1

Tentang wikiHow ini

Bahasa lain
Halaman ini telah diakses sebanyak 1.261 kali.

Apakah artikel ini membantu Anda?

Iklan