Author Archives: Lashmi Bai Ravindrapandian

Key Project Management Terms

Project Management is a framework defined with methodology, process, tools & techniques for managing the projects. Project Management is common but nuances differ as per the industry. Project Management is not industry specific but Project Manager or the PMO must be able to adapt, and must-have gained the technical know-how required for efficiently managing orContinue reading “Key Project Management Terms”

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”

Scorecards vs Dashboards

Often when working in PMO, you will hear the term – Scorecards & Dashboards. Often wondered on their similarities and differences, and here’s the post outlining the key takeaways. Does Organizations need both of them? When to use them in an ideal scenario? What kind of details they represent? What are their benefits? Using scorecardsContinue reading “Scorecards vs Dashboards”

Presenting Data to Senior Stakeholders in 5 simple steps

Often, its really overwhelming when we were asked to present the data to Directors and Senior stakeholders. It’s natural human tendency to feel anxious but it can be overcome by strategic preparation. I personally feel there are a lot of elements involved while presenting the data to Directors. This post consolidates all the key learning…fromContinue reading “Presenting Data to Senior Stakeholders in 5 simple steps”

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”

All About Status Report

I recently read that “The art of communication is the language of leadership”. Project Status Report is one of the key artifacts in Project Management. Check out the below post which are related to Project Status Report. Hope you might find it useful. Lets unveil more about Project Status Report. What is Status Report? SoContinue reading “All About Status Report”

Tit-Bits of Excel

I’m sure you might be using these Tit-Bits in Excel! A sudden thought triggered to compile all the interesting features and information about Excel as and when I come across so that it will be etched in my mind forever. Let’s get started to learn together. 1. Must have options enabled in Quick access toolbar.Continue reading “Tit-Bits of Excel”