Commercial Excel Project Manager
Originally published: 24/04/2020 15:13
Last version published: 24/04/2020 16:31
Publication number: ELQ-77777-2
View all versions & Certificate
certified

Commercial Excel Project Manager

Excel based robust but easy to utilise Project And Task manager tool.

Description
This tool has been created within Microsoft Excel using native formula and VBA. Included withon the tool is a worksheet with user instructions on running the tool. This template does not require any Excel expertise on behalf of the user, In fact the tool is usable for those with minimal or no experience of Excel. The features of tool are:
- Instructions for use
- Setup your environment and organisation worksheet (.i.e Setup Working days, Holidays, Task levels, Task defaults etc)
- Resources management worksheet (Include list and details of potential resources)
- Manage the Project Dashboard
- Includes:
- Setup individual projects (Project name, Project type, Project start date, Status, Project duration)
- Assign Resource(s)
- Collect and define project working papers & files
- Track Project Costs to date
- Define tasks for each project
- Allocate tasks to resources
- Manage and monitor tasks Project by Project
- Track costs on a task basis
- Dymanic Gantt Charts
- Track projects, Task, Resources and cost direct from Gantt chart
- View Future and Historic projects

This tool is ready to use a Project Manager and requires no training apart from the intructions provided withing the file. While its not Microsoft project, It will do all that is required for daya to day Projects.

This Best Practice includes
1 Excel File

Acquire business license for $16.00

Add to cart

Add to bookmarks

Discuss

Further information

This tool provides an easy to use and readily accessable project and task manager within Microsoft Excel.


0.0 / 5 (0 votes)

please wait...