Our previous article on Project Management Framework had set the background for how a ‘Schedule’ forms the foundation for all calculations in Project Management. One of the huge highlights in our Project Management templates (Example: Project Manager Excel Template) is the ‘Automatic Scheduling Engine’ which, as the name suggests, automates the schedule creation step and […]
Category: project management
Project Management Framework
In this article, we will discuss the Project Management Framework that we apply in the Project Management Excel Templates available from indzara.com. Projects can be of different types and Project management techniques also vary with the type of projects. The simplified framework we will see now applies to most common project scenarios. PROJECT MANAGEMENT FRAMEWORK […]
Project Management Toolkit – Excel Templates – Support
This is the support page for the Project Management Toolkit – Excel Templates. Project Management Toolkit – Excel Templates This product is a bundle of 6 individual Excel Templates. The following are links to those individual templates and their support pages. Please visit them for help material around each of them. If you have questions […]
Terms used in Project Manager Excel Template
The Project Manager Excel template uses the following terms. This list is also provided in the template itself. The list includes user input fields and calculated ones. The calculated ones are shown in green font below. Click to know more about the features in the template TASKS TASK ID Unique Task ID (Required) TASK NAME Task […]
Project Manager Excel Template – User Guide
In this article, we will cover the overview of how to use the Project Manager Excel Template. Then, we will use a simple project to illustrate how to use the template. SIMPLE OVERVIEW OF INSTRUCTIONS PLANNING Enter basic inputs in SETTINGS Enter task details in TASKS Review Baseline Plan summary in PROJECT_REPORT Take action to […]
Project Manager Excel Template – Support Page
This page will host support material for Project Manager Excel Template. To read about the template’s highlights and purchase, please visit Project Manager Excel Template. If there are questions about the product, please leave them in the comments section below. SUPPORT ARTICLES Fundamentals Project Management Framework Automatic Scheduling – What is it and why we […]
Earned Value Management 2023 – Free Excel Template
Download this free Excel template to measure the progress of a project with respect to cost. Calculate cost and performance to estimate the project completion values to understand the status of the project.
Resource Capacity Planner – Excel Template – Support
This page will host supporting information for the Resource Capacity Planner Excel Template which can be used to plan resource capacity, compare versus demand and identify over-utilization and under-utilization. To know the features of this template, please visit the product page. The latest version (v2) was published in July 2018. The following are the support articles […]
How to implement predecessor tasks in Gantt Charts?
While building project plans, you will most often have dependencies between tasks. For example, Task 3 cannot begin until Task 2 is complete. In that scenario, Task 2 is called the predecessor to Task 3. In our Project Planner (Advanced) Excel Template, a task can have up to 2 predecessors. The template will then automatically […]
How to skip non-business days for recurring tasks?
When you have recurring tasks and one of the instances/occurrences happens to fall on a holiday, you may like to skip that occurrence. You may want to remove just that one occurrence and keep all the others. You can do that easily in our Task Manager (Advanced) Excel Template. This article explains how to do […]