Archive for June, 2020
Top 10 Excel formulas for IT people
Are you in IT & use Excel often? This article explains top 10 formulas for IT professionals. Useful for project managers, IT analysts, Testing people and BAs.
We cover a 10 practical situations and explore various Excel formulas to solve them. Example workbook provides more details too.Continue »
Lookup last non blank value – Excel Challenge
I have a fun Excel lookup challenge for you. You have data as shown below and want to find the last non blank value for a given account number. For example, for acct number 2015, the answer would be Freedom. How would you solve this? Refer to this workbook for 3 possible answers. Just move […]Continue »
Excel TEXTJOIN Function – What is it, how to use it & 3 advanced examples
Use TEXTJOIN function to combine text values with optional delimiter. It is better than CONCATENATE because you can pass a range instead of individual cells and you can ignore empty cells too. Here is a sample use of TEXTJOIN Excel function.Continue »
How to make a variance chart in Power BI? [Easy & Clean]
Power BI is great for visualizing and interacting with your data. In this article, let me share a technique for creating variance chart in Power BI. Variance charts are perfect for visualizing performance by comparing Plan vs. Actual or Budget vs. Actual data.Continue »
How to make an Interactive Chart Slider Thingy
Ok, I will be honest. I have no idea what to call it. May be Chart Cover Flow? But Interactive Chart Slider Thingy sounds so better. So let’s go with it.
Learn how to create this magical contraption in Excel.Continue »