How to track multiple projects in Microsoft Excel on Windows

0
1

Microsoft Excel is a pop spreadsheet plan used to store, format in addition to organize the data. It is an integral component subdivision of the close trouble organization organisation that is used to perform budgeting, practise fiscal statements, practise residual sheets in addition to other accounting functions. Excel Spreadsheets are also close ordinarily used to perform complex mathematical operations.

For whatever trouble organization to run smoothly, Project management is crucial, in addition to it plays an of import role inward achieving trouble organization deadlines. Excel sheets are used widely for projection management to position critical paths, analyze the latest trends to brand effective decisions, conception the projects in addition to rails the projects. That existence said, Microsoft Excel has a broad diversity of analytical tools in addition to templates that are used past times all scale of trouble organization to deal in addition to study projects.

Track multiple projects inward Excel

If you lot are working on to a greater extent than than 1 project, Excel allows you lot to organize the multiple projects in addition to its resources to accomplish strategic milestones. While managing the multiple tasks in addition to tracking multiple projects tin live on quite challenging, Excel has only about amazing projection management templates that allows to organize in addition to schedule multiple projects effectively all inward a unmarried excel spreadsheet.

In this article, nosotros explicate how to job a Multiple Project Tracking Template Excel to effectively conception in addition to rails multiple projects inward a unmarried Excel spreadsheet. The template provides a user-friendly interface in addition to consists of Data Sheets to add together tasks, multiple projection tracking dashboard, multiple projects tracking Gantt Chart, in addition to Project summary. The template allows you lot to job every bit many projects in addition to tasks every bit you lot wishing inward a unmarried workbook without whatever boundaries.  The template is available for gratis in addition to industrial plant on close of the MS Excel version inward Windows 10.

READ :  Stop Microsoft Word from marking Contractions as errors

Setup the Excel template for tracking multiple projects

Download the gratis Excel template for tracking multiple projects here in addition to salvage it to your local drive. Double-click the downloaded file. The Template file opens automatically inward Microsoft Excel.

Now click on the Data Sheet tab at the bottom of the workbook.  Clear the existing information from the tabular array to practise your projects in addition to tasks.

Add Multiple Projects inward Excel Template

Go to Projects Summary Sheet at the bottom of the workbook.

Clear the existing sample projects inward the minute column from the column B gain B4 to gain B xiii  under the squall Projects.

 is a pop spreadsheet plan used to shop How to rails multiple projects inward Microsoft Excel on Windows

Enter your Project Tiles inward Column B from the range B4. You tin travel into every bit many projects every bit you lot want.

Click on Project Plan Sheet at the bottom of the workbook. The Project Plan canvass is the principal canvass of the template that shows overall tasks in addition to projection metrics in addition to condition report. In this sheet, you lot tin stance all the projects on the Dashboard in addition to Gantt Chart.

Click on downwardly arrow beside  All Projects bill of fare at the overstep of the sheet. Select your showtime projection from the drop-down menu.

 is a pop spreadsheet plan used to shop How to rails multiple projects inward Microsoft Excel on Windows

Enter the details of your showtime projection similar projection name, client name, in addition to projection manager.

Once done, click on the downwardly arrow beside the All Projects bill of fare at the overstep of the sheet.

Now choose your minute projection from the drop-down bill of fare to opened upward a novel version of the sheet.

 is a pop spreadsheet plan used to shop How to rails multiple projects inward Microsoft Excel on Windows

Enter the details of your minute projection similar projection name, client name, in addition to projection manager.

Once done, you lot tin pop off on on adding novel projects in addition to its details every bit much every bit you lot desire past times repeating the inward a higher house steps.

READ :  Microsoft Office 2013 | Office 365 editions pricing explained

Add novel tasks inward Data Sheet

Data Sheet is the canvass inward your workbook that allows you lot to add together the ongoing projection activities in addition to their details inward an organized way. Data Sheet contains fields that allow you lot to travel into tasks for each of your projects in addition to their respective projection activities to track.  In the datasheet, you lot tin add together the chore for each project, assign a squad fellow member to a special task, advert the start engagement in addition to the expected engagement of completion. Follow the below steps to add together novel tasks nether a project.

Navigate to the Data Sheet tab at the bottom of the workbook.

 is a pop spreadsheet plan used to shop How to rails multiple projects inward Microsoft Excel on Windows

Under the Project Column,  Select the Project Title.

In the Task Column, add together a novel task

In the responsible column, add together the squall of a individual  to whom the chore is assigned

In the Start Date Column, assign the information when the responsible individual has to start the task.

Specify the position out of days required past times a squad fellow member or a individual to consummate the projection action for every chore inward the Days Required Column. This progress information volition create the condition of your Project inward Dashboard in addition to Gantt.

You tin update the progress of the chore completed inward per centum on a daily terra firma inward a split column called Progress.

Save the changes.

The changes made to the Data Sheet volition look inward Project Plan in addition to Project Summary.

 is a pop spreadsheet plan used to shop How to rails multiple projects inward Microsoft Excel on Windows

You tin stance the overall condition of the projection hither in addition to larn a nautical chart of the per centum of projection completed, in addition to the per centum of the pending tasks.

That’s all in that place is to it!


Source: https://www.thewindowsclub.com/

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.