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”
Tag Archives: Productivity Tips & Tricks
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 errors, and make your reports more effective. 1. Copy Only Visible Cells Issue: Hidden rows/columns get copied with filteredContinue reading “Excel Tips Every PMO should Know”
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”
All types of Average, Max & Min (Statistical DAX)
Average, Max and Min are most commonly used in Excel and it’s quite handy to use this function combined with other calculations. Let’s learn different types of Max, Min & Average DAX functions. MAX() MAXA() MAXX() MIN() MINA() MINX() AVERAGE() AVERAGEA() AVERAGEX() The concept is same for all. MAXX() , MINX() & AVERAGEX() will beContinue reading “All types of Average, Max & Min (Statistical DAX)”
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 < now() : DAYS_BETWEEN (duedate, NOW()) CONCAT “days late” Roll up earliest start date to parent: IF (COUNT #CHILDREN{0},Continue reading “Jira structures Formulas”
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 your checklist as well. Hope you find it useful. Office 365 SharePoint Trial Version: Frist of all, lets knowContinue reading “All About SharePoint Online”
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 Pivot menu, simply right click on the toolbar and then select customize this ribbon. Over to the right here make sureContinue reading “All about Power Pivot”
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 adopted to build multiple products for the organizations to scale their business. Right from MS Office suite to latestContinue reading “Microsoft Tools for Project Management”
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 also covers the gaps in learning the small elements that you missed in the structured learning in terms ofContinue reading “10 Smartsheet Tips and Tricks”
LR Virtual Classroom 