“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 data piles up. Being in PMO, you get your hands on with data every day to measure the performanceContinue reading “45+ Types of Data Visualization”
Tag Archives: Advanced Excel
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”
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”
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 name says, all the information is organized in rows and columns (of course sheet !) in the Smartsheet. Let’sContinue reading “Basic Features of Smartsheet”
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 about the tool in layman terms. Don’t forget to checkout my other posts on Smartsheet here. What is Smartsheet?Continue reading “Introduction to SMARTSHEET”
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 function is very handy when you want to filter the specific part of the table data. Lets see bothContinue reading “Filter , Sort & Sequence Excel Functions”
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 a value in a dataset (vertical or horizontal) and return the corresponding value in some other row/column. XLOOKUP functionContinue reading “Excel Magic Function XLOOKUP() with 10 Examples”
LR Virtual Classroom 