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…
Keep reading
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…
Keep reading
Meet Microsoft Loop: Your new secret weapon for PMO success
Microsoft Loop: A Practical Collaboration Tool for Delivery Teams Most delivery teams don’t struggle because of a lack of tools. They struggle because information is everywhere. Updates sit in emails.Actions sit in meeting notes.Risks live in…
Keep reading
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…
Keep reading
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,…
Keep reading
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…
Keep reading
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…
Keep reading
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…
Keep reading
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,…
Keep reading
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…
Keep reading
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):…
Keep reading
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…
Keep reading
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…
Keep reading
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…
Keep reading
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…
Keep reading
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…
Keep reading
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…
Keep reading
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…
Keep reading
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…
Keep reading
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…
Keep reading
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…
Keep reading
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…
Keep reading
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…
Keep reading
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.…
Keep reading
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.…
Keep reading
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…
Keep reading
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…
Keep reading
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…
Keep reading
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…
Keep reading
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…
Keep reading
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…
Keep reading
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,…
Keep reading
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…
Keep reading
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…
Keep reading
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…
Keep reading
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,…
Keep reading
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…
Keep reading
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…
Keep reading
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…
Keep reading
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…
Keep reading
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…
Keep reading
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…
Keep reading
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…
Keep reading
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…
Keep reading
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…
Keep reading
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…
Keep reading
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…
Keep reading
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…
Keep reading
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…
Keep reading
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…
Keep reading
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…
Keep reading
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…
Keep reading
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…
Keep reading
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,…
Keep readingA-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 to…
Keep reading
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…
Keep reading
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…
Keep reading
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…
Keep readingAddins (3) Advanced Excel (18) Agile (21) Blog (14) business (1) Clarity (3) Cloud Computing (3) Confluence (3) Dashboards (21) Data Analytics (17) Data modelling (9) DAX (17) Downloads (2) excel (1) GenAI (33) Jira (12) kanban (1) KPI (2) Loop (1) MS Project (1) MS Teams (3) OneNote Tutorial (2) Outlook (1) PMO (74) Power BI (50) Power BI Dashboards (1) Power BI Desktop (29) Power BI service (2) Powerpoint (5) Power Query (3) Product Development (2) Productivity Tips & Tricks (59) project-management (3) Project Governance (2) Project Online (1) Ravindrapandian (1) Roadmap (2) scrum (4) scrum-master (2) Sharepoint Online (2) Smartsheet (5) Sway (1) Team Bonding (1)
Get new content delivered directly to your inbox.