Productivity is the key to being successful in a PMO role.
Here you can find information about the latest Tools & Technology being used in the Project Management field & also tips & tricks from my knowledge & experience.
How Jira Automation Supercharged Oracle ERP Implementation
When I began working on our recent Oracle ERP implementation, I quickly realized just how overwhelming it could get – hundreds of tasks, defects, test cases, and change requests all flowing through Jira. Manual tracking wasn’t…
Use MS Sway to Elevate PMO Communication
In today’s fast-paced project environments, PMO’s face increasing pressure to communicate effectively across diverse stakeholders. Traditional static reports are losing relevance in our increasingly digital workplaces. It is clear that there is a need for more…
Meet Microsoft Loop: Your New Secret Weapon for PMO Success
As a consultant, you’re the bridge between strategy and execution. Whether you’re embedding into a PMO, advising on delivery frameworks, or rolling out cross-functional programs, you’re expected to bring clarity, structure, and momentum fast. But let’s…
Building Stronger Teams, One Activity at a Time
In today’s fast-paced work environment, team dynamics play a huge role in success. While talent and hard skills are vital, the ability to work well together is what truly sets high-performing teams apart. One of the…
9 Thinking Methods Every PMO Should Know
Strategic thinking becomes the cornerstone of managing multiple stakeholders effectively. It empowers you to anticipate challenges, align diverse interests, and make decisions that drive both short-term results and long-term success. The ability to think critically, creatively,…
The Ultimate Guide to Agile Principles
I have compiled a comprehensive list of 38 essential Agile principles that every Agile enthusiast, practitioner, or leader should know. These principles form the backbone of Agile methodologies, guiding teams toward better collaboration, adaptability, and value…
45+ Types of Data Visualization
“Data is the new oil”. Yes, Michael Palmer expanded on Humby’s quote by saying, like oil, data is “valuable, but if unrefined it cannot really be used. Data Visualization In the era of digital technology, more and more…
How To Be 10x More Productive
In today’s fast-paced world, it’s more important than ever to be productive. Productivity is the ability to get things done efficiently and effectively. It is a valuable skill that can be used in all aspects of…
Mastering the COUNTIFS Function in Excel
Use Case for the COUNTIFS Function in Excel The COUNTIFS function in Excel is a powerful tool used to count the number of cells that meet multiple criteria. It is an extension of the COUNTIF function,…
Cheat-Sheet of MS Project 2016
It’s been more than quite a couple of years since I put my hands on MS Project tool. In the thirst to recap, recently I took a refresher course on MS Project on Udemy – Ultimate…
Follow these 5 rules to make professional presentations
Use meaningful titles: Life is short: most people won’t read the full content of your slides; If your slide has a meaning, so should your title. Make your slides and bullets Mutually Exclusive, Collectively Exhaustive (MECE):…
Excel Tips Every PMO should Know
Very late in my career, I realized something important: mastering Excel isn’t just about knowing formulas or building charts. It’s about understanding the right shortcuts, features, tools and techniques that can save hours of work, reduce…
How to remove blank rows in Pivot Table
When there are blanks in the dataset, the pivot table also has cells with “blank strings” as below. So, how to remove them. It is so frustrating to read the data right? There is a solution…
How to Create a Task Tracker in Excel in Less Than One Minute
In this post, you will learn how to quickly build a task tracker in Excel using checkboxes, formulas, and progress bars, all in under one minute! Task Data – Your Excel sheet has the following columns:👉 Task…
3 New Excel TEXT Functions
There are 3 new excel TEXT() functions that got released recently. Let’s explore and learn one by one. TextBefore() TEXTBEFORE – Returns text that’s before delimiting characters text – the actual text delimiter – text before which…
Jira structures Formulas
Hi Readers, This is continuation of post on Jira Structures. Check out the post here to know the basics of Jira Structures. Coming up more formulas for ready reference. Formulas to use in Structures: IF duedate…
All About SharePoint Online
The UI of the Sharepoint online was so easy to make navigation and achieving simple tasks easy. It is easy on the eyes. Out of curiosity, summarizing the learnings about the key features here to enable…
All about Power Pivot
Excel’s Power Pivot is a standard Excel desktop feature. Power Pivot along with Power Query with Pivot table and Pivot Chart is the wonderful combination in the Excel for data analysis of huge data sets. To enable Power…
Microsoft Tools for Project Management
Microsoft is one of the organization, I truly admire for their products specifically for Project Management. This is not an affiliate post, just an opinion about the variety of products they have and how quickly they…
10 Smartsheet Tips and Tricks
When you learn any tool, always look for contents related to Tips & Tricks. This lets you to understand the tool features & functionally in detail, know the shortcuts which in turn improves the productivity. This…
Manage Tasks / Timeline in Mordern O365 Sharepoint
When you are dealing with initiatives, you might be required to manage the tasks list and track the timeline of the project. SharePoint Online is a great platform with plenty of features that can help you manage…
10 Useful MS Teams Apps
MS Teams which is the most commonly used platform in all the organizations that brings together everyone under one umbrella. Many not aware that this collaboration tool has lot many app integrations with plethora of benefits…
Managing Projects with Microsoft Teams
MS Teams is the biggest recent technology that is ruling virtual meetings since COVID. Hence there are lot many features beyond the basic features. The tool is very intuitive and thought to share the learning with…
5 Free PowerPoint Add-ins for Creating Creative Content
Recently I came across a 5 interesting Add-ins. Mind blowing to use these to create creative content. I’m sure you don’t want to miss these interesting 5 Free Add-ins in PowerPoint which are self-explanatory and DIY.…
Functionality of Smartsheet
Let’s see about the features and functionality in this post. Don’t forget to checkout my other posts on Smartsheet here. There are 7 major elements in Smartsheet and lets see one by one in detail. 1.…
Are you aware of Different Views in Smartsheet
The most significant feature in the Smartsheet is the ability to view the sheets of Rows and Columns (Grid view) in three different forms – Cards , Gantt & Calendar view. Let’s see in detail. This…
Basic Features of Smartsheet
Before understanding the key elements and functionality of the Smartsheet, its very important to know the key features of the sheet. Before scrolling down, don’t forget to checkout my other posts on Smartsheet here. As the…
Introduction to SMARTSHEET
My recent acquaintance about SMARTSHEET. In order to broaden my horizon in the latest project management related tools, I started to subscribe for a free trial on Smartsheet and got the hands-on self-training. Let me share…
JQL using Filter Function
Understanding the Filter Function: The filter function in JQL allows you to reference and reuse saved filters. A saved filter is a predefined JQL query that in you or your team have created and saved for…
All about Jira Rich Filters
I recently learned about rich filters in Jira, and they’ve been incredibly useful for managing our projects more effectively. These filters allow us to create highly customized searches using JQL (Jira Query Language), which is great…
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…
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,…
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…
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…
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…
Mastering JQL
Unlock the full potential of Jira with Jira Query Language (JQL)! This powerful tool lets you create custom queries to filter and sort issues with precision. Want to manage tasks based on due dates, statuses, labels,…
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…
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…
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…
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…
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…
7 Awesome Excel Hacks!
Recently, I can across amazing Excel tips on LinkedIn which are worth sharing. You will be amazed by these shortcuts. I started to learn how Google Sheets works as well. As a first step, thought to…
Are you using these Confluence Macros
During the Harman days, I got exposed to this Confluence tool. Mind-Blowing experience I say in the short period of time. I have been using traditional SharePoint all my career, however, duo of Confluence and Jira…
Jira with JQL
JQL (Jira Query Language) is very simple and interesting to learn, unlike SQL. Just like Excel, you need more practice and remember the concepts to apply the JQL. It is important to know the powerful way…
Optimize Jira with these Tips
I recently took a course on effective utilization of Jira. The reason behind is as the Jira tool is totally effective and productive ONLY if you and all the team members keep it updated. Sometimes updating…
Jira in Layman Terms
Having a hands-on experience in Jira is one of the most sought skill these days in IT world. Thanks to the tremendous success of Agile Project Management Methodology. In this post, I’m going to share the…
SharePoint vs Confluence
Collaboration tools are the integral part of the PMO function. Choosing the right tool will help you effective time, configuration (version), communication & knowledge management within your teams. Ensuring the right processes will relive stress and…
Guidelines for achieving Zero Inbox
15 Outlook Tips for Increased Productivity Have you heard about Inbox Zero? It is a productivity philosophy about dealing with a constant, life-long stream of email. It was first expressed by Merlin Mann on his 43Folders…
Top 6 Free Add-Ins for PowerPoint
A PowerPoint presentation can be a simple deck of slides. It can also be a visually breathtaking course of animations and graphics. In every case, a good presentation requires thought, hard work, and time. Microsoft PowerPoint…
Top 6 FREE Add-Ins for Excel 2019
Microsoft Excel is by far the most used application for data analysis. Mastering Excel is a must-have skill in many companies. It can also be a huge time-saver. Add or remove an Excel add-in. Click the…
Email – An extension of your Identity
Often, in the corporate environment, Emails are overlooked and the sender also overlooks the content of the mail while sending without going deep into the reasons behind sending the mail. Many workplace problems arise due to…
Introduction to OneNote 2019
Digital Note Taking If you are in PMO, you need to be efficient in stakeholder management. In the midst of Covid’19, new norm of Work from home has evolved and which in turn meetings have been…
10 Excel Hacks + 3 Bonus Tips
Sometimes, the smallest features bring out the best when using Excel. These 20 Excel hacks are worth not being missed. Let’s check out one by one. Next time, you do something in Excel, check if you…
Excel Automation using Power Query
Microsoft Excel includes a powerful feature called Power Query—also known as Get & Transform or Get Data—which provides fast and powerful data gathering and cleansing capabilities. A biggest advantage of Power Query & Power Pivot is,…
A-Z of Power Query
Create Low Code Automated Dashboard Are you finding difficult to learn VBA – Macros like me? Are you taking more time to clean & transform your data like me? Are you looking for “Low code options…
Do you know these features in Pivot Tables
Excel is the most commonly used tool for data storage, data analysis, accounting, budgeting, reporting, visualizations and the list goes on. Pivot table is one of the key feature of the Excel and used to various…
Create Project Timeline in PowerPoint in 10 min | No Complex Editing and Formatting |
I strongly believe that, No Business Strategy Initiative will be fruitful without Roadmap in place…. No Project Management Plan is complete without a Timeline in place… Whether it is Portfolio Roadmap Strategy, Program Increment Release Planning…
15 Powerpoint Presentation Tips
If you haven’t used PowerPoint lately, you haven’t used Powerpoint. Technology is changing so fast, so with this latest update, PowerPoint is packed with a variety of different features that leverage artificial intelligence to help us work smarter and…
Addins (3) Advanced Excel (18) Agile (23) Blog (21) business (1) Clarity (3) Cloud Computing (3) Confluence (3) Dashboards (21) Data Analytics (17) Data modelling (9) DAX (17) Downloads (2) excel (1) GenAI (8) Jira (12) kanban (1) KPI (2) Loop (1) Motivation (3) MS Project (1) MS Teams (3) OneNote Tutorial (2) Outlook (1) PMO (72) Power BI (50) Power BI Dashboards (1) Power BI Desktop (28) Power BI service (2) Powerpoint (5) Power Query (3) Product Development (2) Productivity Tips & Tricks (59) project-management (4) Project Governance (2) Project Online (1) Ravindrapandian (1) Roadmap (2) scrum (5) scrum-master (2) Sharepoint Online (2) Smartsheet (5) Sway (1) Team Bonding (1)
Get new content delivered directly to your inbox.
LR Virtual Classroom 