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”
Category Archives: Productivity Tips
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 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”
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”
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 