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

{"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]
X
Teliti sumber}
{"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.
{"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.
{"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.
{"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.
{"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.
{"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.
{"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.
{"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.
{"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.
{"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.
{"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 .
{"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

[1]

Masuk

Cara Memantau Beberapa Proyek dalam Excel pada Windows atau Mac

Langkah

wikiHow Terkait

Referensi

Tentang wikiHow ini

Apakah artikel ini membantu Anda?

Artikel Terkait

Ikuti kami

Bagikan

Explore Categories