Lashmi Bai Ravindrapandian

6 Tips to follow in PMO Finance Template

Being in PMO, you will get to play with numbers and provide objective data for decision making. Number crunching is a term for processing numerical data from which to draw conclusions and provides context to business situations, decisions and results. Lets see some of the tips to keep in mind while creating finance related excelContinue reading “6 Tips to follow in PMO Finance Template”

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 for this. By using the conditional formatting function, you can eliminate the blanks as below. Select the entire pivotContinue reading “How to remove blank rows in Pivot Table”

My First experience with MS Visio with Samples

During my tenure in Cyient in 2017, I first got introduced to the mind-blowing tool called MS Visio. At first, it was very overwhelming to crack the tool. Over a period of time, I got so connected with the tool for its amazing features to create project artifacts in a visually appealing and intuitive representation.Continue reading “My First experience with MS Visio with Samples”

All about Parameters (PL-300)

1. A parameter serves as a way to easily store and manage a value that can be reused. 2. Parameters give you the flexibility to dynamically change the output of your queries depending on their value, and can be used for: 3. Power Query provides two easy ways to create parameters: 5. You can alsoContinue reading “All about Parameters (PL-300)”

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 ID👉 Task Name👉 Completed (with checkboxes)👉 Progress Bar👉 Percentage Completed👉 Conditional Formatting Step 1: Add Checkboxes👉 Go to InsertContinue reading “How to Create a Task Tracker in Excel in Less Than One Minute”

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 you want to extract, must field instance_num – ‘n’ occurrence/instance of delimiter you want to extract By default, itContinue reading “3 New Excel TEXT Functions”

The Road to Success: Life’s Lessons in 21 Vital Skills

Life, as they say, is an intricate tapestry woven from experiences, challenges, and, above all, learning. Throughout our journey, we collect a treasure trove of skills and abilities, each one shaping us in its unique way. These abilities, often acquired through trials and tribulations, guide us towards success. Let’s delve into these 21 essential skillsContinue reading “The Road to Success: Life’s Lessons in 21 Vital Skills”

All about Resource Capacity

Resource management is an integral part of any business or organization. Planning the demand and the supply of the resources effectively and efficiently will help the organization in many ways. Also, 70%, as per the recent survey on Labor statistics, 70% of the total business costs come from employee benefits and payroll. Hence, we needContinue reading “All about Resource Capacity”

Foundation details about Modelling Data (PL-300)

Titbits of Information about Model data with Power BI from the Learning Path 1. Understanding the structure of semantic models can help you design the right model to support your reports and dashboards. A semantic model can be developed in many ways, yet one or several of those ways are more optimal. Optimal models areContinue reading “Foundation details about Modelling Data (PL-300)”

Have you heard of Pomodoro Technique

Recently I read somewhere about a productivity technique called the Pomodoro technique. The name sounds very interesting so thought to dig deep into the concept. It is worth sharing with you all. What is Pomodoro Technique? First things first. By definition, the word Pomodoro means “Timer”. This is by far the simplest productivity technique. ItContinue reading “Have you heard of Pomodoro Technique”