This article was co-authored by How.com.vn staff writer, Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for How.com.vn. She has more than 20 years of experience creating technical documentation and leading support teams at major web hosting and software companies. Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions.
This article has been viewed 57,231 times.
This How.com.vn teaches you how to use a Microsoft Excel template to keep track of multiple projects.
Steps
Go to https://analysistabs.com/project/tracking/templates/excel/multiple/#bm1 in a web browser. This site contains a free Excel template called Analysistabs that can manage multiple projects and tasks.[1]
Click ANALYSISTABS – Multiple Project Tracking Template Excel. This will download the template to your computer’s Downloads folder.Advertisement
Double-click the file. It’s the file called ANAYLSISTABS-Multiple-Project-Tracking-Template-Excel.xslm in the Downloads folder. The file will now open in Excel.
Click the Data Sheet sheet. It’s one of the sheets at the bottom of the workbook.
Add your own data to the sheet. Enter all the ongoing projects and their particulars, including tasks, personnel, start and expected completion dates. You can also add or delete columns and rows to fit your projects.
Press Control+S to save your changes. If prompted, give the file a new name and save it to the folder of your choice.
Click the Project Plan sheet. It’s at the bottom of the workbook. This opens the details for your first project.
Fill out the details for your first project. Enter the names of the project, customer, and manager into the appropriate blanks.
Click the small arrow beside the “All Projects” menu. It’s above the right panel. A list of additional projects will appear.
Click Project 2. This opens a new version of the last sheet you were working on.
Fill out the details of your second project. Once you’re finished, you can continue selecting projects and adding the details for each.
Update your progress on the Data Sheet as the projects progress. Any changes to this sheet will be reflected in the Project Plan and Project Summary sheets.
Press Control+S to save your work.Advertisement
Expert Q&A
About this article
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.
