Category Archives: Productivity Tips

Create Dashboard Index in Jira

Managing multiple dashboards in Jira can quickly become overwhelming. Each project or team might have its own set of key metrics and reports, scattered across various dashboard links. As a Jira user, navigating through these links every time you need specific information can be tedious and time-consuming. Imagine having all your essential dashboard links neatlyContinue reading “Create Dashboard Index in Jira”

PPM Clarity – My Recent Exposure

During the Honeywell days, I have extensively worked in the SAP – Project Systems which gave me exposure to connect the dots in the E2E (End-to-End) project management in terms of scope, schedule, budget, resources, quality, risk, issues, change request, communication, reporting, phase gates etc. The tool had the concept of various T-codes which youContinue reading “PPM Clarity – My Recent Exposure”

Streamline your Jira with Structures

During my time working on a complex project with multiple teams, I discovered the immense value of properly organizing Jira issues to meet our specific needs. It wasn’t just about task tracking; it was about streamlining workflows and ensuring everyone was aligned. Through trial and error, I found that the project portfolio management tool, StructureContinue reading “Streamline your Jira with Structures”

Filter , Sort & Sequence Excel Functions

It’s a tremendous compounding effect when you learn excel formulas everyday. Here’s drafting the explanation about the three major excel functions with examples. You can download the excel from here for reference. 1. Filter Function: Filter function is very handy when you want to filter the specific part of the table data. Lets see bothContinue reading “Filter , Sort & Sequence Excel Functions”

Effective Delay Management for Jira Tasks

In project management, delays are inevitable. Understanding how to calculate the delay of one task relative to another and forecasting new completion dates is crucial for maintaining project timelines. In this post, we’ll explore a methodical approach to calculate delays and forecast completion dates using Excel. Let’s break down the formula: =IF(E2=””,IF(D2<TODAY(),NETWORKDAYS(D2,TODAY())-1,0),IF(NETWORKDAYS(D2,E2)<0,NETWORKDAYS(D2,E2)+1,NETWORKDAYS(D2,E2)-1)) This formula isContinue reading “Effective Delay Management for Jira Tasks”

Jira Reporting for Beginners

Visualizing and understanding the Jira reports is significant feature to know. Lets see the different types of Jira reporting available. These reports provide details about your projects, issues and performance. I have used Jira for the inventory management . In the thrust of learning, took time to understand and summarize in layman terms about theContinue reading “Jira Reporting for Beginners”

Icons for PowerPoint

Ever wanted to get the coolest looking icons in your PowerPoint slides? You don’t need to install any add-in!. Just with the in-built function, you can have many icons inserted to your dashboards and presentations.  The four fonts type which does this magic is Webdings Wingdings Wingdings 2 Wingdings 3 Just type the char mentioned at the top andContinue reading “Icons for PowerPoint”

Excel Magic Function XLOOKUP() with 10 Examples

Long awaited Xlookup finally arrived. If you have been using VLOOKUP or INDEX/MATCH, I am sure you’ll love the flexibility that the XLOOKUP function provides. XLOOKUP is a function that allows you to quickly look for a value in a dataset (vertical or horizontal) and return the corresponding value in some other row/column. XLOOKUP functionContinue reading “Excel Magic Function XLOOKUP() with 10 Examples”

Excel Advanced Formulas

Excel formulas are like bread and butter for anyone being in PMO. Summarising the important formulas one should be aware of, along with examples. It was a good recap for me. The below is the list of functions we are going learn together. AND(), OR(), NOT() IF() and IFS() SWITCH() SUMIF() SUMIFS(), AVERAGEIF() / AVERAGEIFS()Continue reading “Excel Advanced Formulas”