Skip to Content

Tag Archives: Excel

Ind Zara – Advanced Task Manager

Advanced Task Manager is produced by Ind Zara. Product Summary: A to-do list Excel template for creating one-time and recurring tasks, assigning them to team members and updating their status. This tool can be used by project managers who handle multiple tasks and manage multiple team members. It can also be used by individuals to manage personal…

Best Practices for Initiating a New Project Schedule with Microsoft Project

Project Management Institute (PMI)® Professional Development Units (PDUs): This Webinar is eligible for 1 PMI® PDU in the Technical category of the Talent Triangle. Event Description: In the first webinar of this multi-part series, Microsoft Project expert Ira Brown will present techniques for initiating a new project that is consistent with established organizational standards. This presentation…

Tips for Initiating a New Project Schedule with Microsoft Project

As organizations work to improve their project management maturity level, they often develop methodologies that include standard processes and best practices. However, ensuring project managers consistently initiate new projects according to these standards and processes often proves challenging. In this mini-article I provide quick tips for enabling easy and consistent project initiation across an organization….

Get rid of your last separate Excel sheets: Use your MS project schedule for project financials

Project Management Institute (PMI)® Professional Development Units (PDUs): This Webinar is eligible for 1 PMI® PDU in the Strategic category of the Talent Triangle. Event Description: Many, many times we see that project timing and project resourcing are managed in MS Project, while project finances are kept in Excel. Using the financial governance capabilities in MS…

Make Your Life Easier with Project Macros

Project Management Institute (PMI)® Professional Development Units (PDUs): This Webinar is eligible for 1 PMI® PDU in the Technical Category of the Talent Triangle. Download the slides from this session. Event Description: Ever want to build macros to make routine tasks easier and more efficient in Microsoft Project, but you are not a programmer?  This presentation…

Ind Zara – Project Management Toolkit Excel Templates

  Product Summary: A set of Excel files to help users speed up project management.         These Excel-based templates cover six jobs: Project Manager: Designed to help you or a novice user manage a single project at a time. You can set a baseline plan, track actual progress and compare the current…

How To Remove (blank) Values in Your Excel Pivot Table

You might call it perfectionism, but I hate when my reports don’t look their best. One of the most irritating elements is the “(blank)” text you may have on your Excel pivot tables. I’ve tried some pivot table options to eliminate that word, “blank,” but nothing seems to work properly. So I’ve come up with…

A Free Project Pipeline Tracker for Excel

This free Excel Template allows you to track projects and calculate your effectiveness in completing them. I find it applicable for scenarios where all the projects go through the same set of pre-defined stages in sequence. For example, all building projects may have three stages: plan, design and build. Once planning is completed, designing begins;…

Why You Should Add Microsoft Project Visual Reports to Your PM Toolkit

Do you understand how to use Visual Reports in Microsoft Project? In my experience, seldom do project managers use any kind of Project reports — let alone the visual ones — even when they understand how to. To help PMs cross this chasm, I’m going to provide a quick and painless introduction to Visual Reports…

Create Beautiful Reports on Project Desktop with Tools Other Than Just Project!

Project Management Institute (PMI)® Professional Development Units (PDUs): This Webinar is eligible for 1 PMI® PDU in the Technical category of the Talent Triangle. Event Description: Even though Project Pro for Office 365 is available through a monthly subscription, there are many companies and individuals who still use old versions of MS Project (Project 2010, Project…

Please enter your email to continue viewing