USING EXCEL AS A PROJECT PLANNER HOW TO

From there, you can tweak the Excel project plan template to fit your project’s scope.

Note: The “total days” field will automatically calculate based on the dates you entered, to make it easier to track the total number of days each task is assigned.

This will include: Project name, task names, assigning each task to a team member, start dates, end dates, and status of completion (“in progress”, “completed”, “overdue”, and “not started”).

Once you’re ready to go, delete the sample data on the template.

From there, a copy of the file will save to your “Downloads” folder, and you can open it or move it to your preferred file folder.

You can also go to “File”, scroll down to “Download”, and select “Microsoft Excel”.

If you’d rather download a Microsoft Excel project plan template:.

Make sure you name your project plans clearly, including project name, version, and date (this will help with version control).

Go to “File,” scroll down to “Make a copy,” and save it to your own Google drive.

If you’re comfortable using Google Sheets:.

A new tab or window will appear, where you will see a Google Sheets version of the project plan template.

Click the link to the free project plan template.

USING EXCEL AS A PROJECT PLANNER HOW TO

How to use your Excel project plan template: in 7 easy steps You can find download your free project plan template for Excel here.

If you’re looking for something a little more advanced, look no furtherĮxcel project plan template: Free download.8 benefits of using an Excel project plan template.

Excel project plan template: Free download.

Using excel as a project planner