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, which only allows for a single criterion. This function is particularly useful in project management, data analysis, and reporting,Continue reading “Mastering the COUNTIFS Function in Excel”
Author Archives: Lashmi Bai Ravindrapandian
Tenant Settings – The Magic Wand
There are different sections in the Tenant Settings. Firstly, familiarity with tenant settings enables data analysts to work more efficiently within the Power BI environment. By knowing how to configure settings such as workspace access, data governance policies, and security protocols, analysts can ensure that they have the necessary permissions and resources to carry outContinue reading “Tenant Settings – The Magic Wand”
A-Z about Power BI Admin Portal (PL-300)
Admin Portal of the Power BI is the key controller and one needs to understand the features, functionality, capabilities, and do’s and don’ts. So, here’s the post about the Admin Portal. There we go, let’s get started. Before that Power BI Administrator role will be renamed to Fabric Administrator 1. How to access the adminContinue reading “A-Z about Power BI Admin Portal (PL-300)”
Tits Bits from Power BI MVP Book (PL-300)
Recently, I read an amazing book – Power BI MVP Book: A book of Tricks and techniques for working with Power BI written by 21 MVP professionals from all around the world. The book has 21 chapters each written by 21 MVPs. Must read by all PL-300 aspirants. Here are the titbits from each chapter.Continue reading “Tits Bits from Power BI MVP Book (PL-300)”
User Interface Unveiled: Secrets to Mastering Power BI Desktop (PL-300)
Most of the time, you need to know/navigate what the menu is available and the list of options/ features underneath. Here’s the post just about the User Interface with screenshot on the Power BI Menu and a brief list of options under each. This will help anyone in the Pl-300 exam. Knowing is the beginningContinue reading “User Interface Unveiled: Secrets to Mastering Power BI Desktop (PL-300)”
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 Microsoft Project 2016 Course – Beginner to Expert. It was a good training material for advanced MS Project Users.Continue reading “Cheat-Sheet of MS Project 2016”
Daily Idioms
Language is a beautiful tapestry, woven with words, phrases, and expressions that often carry meanings beyond their literal interpretation. Idioms, in particular, are linguistic gems that add depth and character to our conversations. These figurative phrases are like secret codes, conveying messages that go beyond the surface. In this journey to explore the world ofContinue reading “Daily Idioms”
All in All PMO Checklist (50+ Pointers)
Every organization and every project is different. It is also turned out that there is no one way to better manage a project. In the thrust to recap my experience and upskill, drafting this consolidated post on the All-in-All PMO checklist. This post will be updated as and when any NEW process, templates, methods, ideologies,Continue reading “All in All PMO Checklist (50+ Pointers)”
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): Each title is a distinct point supporting the main goal of your presentation, and all slides together make itContinue reading “Follow these 5 rules to make professional presentations”
Every Business runs on Capex & Opex
If there are two financial terms that every business should be familiar with to run their organization successfully, then it is CAPEX & OPEX. Right from understanding the terms, categories, differences, how they are accounted for, a few examples, and how they drive the business profitability, we are going to learn A-Z about Capex &Continue reading “Every Business runs on Capex & Opex”
LR Virtual Classroom 