Make a Pivot from Another Pivot Table in Excel
Recently, a client shared data with me that is clearly a pivot table and wanted me to make another pivot from it using Excel. This is a common and annoying problem we all face when working with Excel. Today, let me share my approaches for creating a pivot from another pivot report using Excel. Option […]
How to use XLOOKUP with two sheets?
Learn how to use Excel XLOOKUP function with two sheets in this step-by-step tutorial. Why you may want to use XLOOKUP with two sheets? If you have data in two places (sheets or Excel workbooks) like depicted above, you may want to use XLOOKUP to combine data from both places to get the full picture. […]
How to create SVG DAX Measures in Power BI (Easy, step-by-step Tutorial with Sample File)
SVG (Scalable Vector Graphics) is a great way to add a bit of flavor and pizzazz to your boring Power BI reports. I have been using them for a while and really love how easy and fun they are to work with. So today, let me share the technique and provide sample measure code that […]
How to freeze rows in excel
Ever have a report that is too big to fit in one screen but when you scroll you loose the context? Something like this.. Use FREEZE PANES option in Excel to “Freeze” top rows / columns We can use the excellent “Freeze panes” option in Excel to make the top few rows (and columns) sticky. […]
Automatically Format Numbers in Thousands, Millions, Billions in Excel [2 Techniques]
Ever wanted to automatically format values in thousands, millions or billions in Excel? In this article, let me show you two powerful techniques to do just that.
Get all BOLD text out Excel Cells Automatically
Use the getBoldText() function in Excel to extract bolded portion of a cell automatically. Saves you time and helps with data cleaning.
How-to create Dependent Drop Downs in Excel [Dynamic & Multiple]
Do you want to create a dynamic dependent drop down list in Excel like below? You can use XLOOKUP and data validation to set this up quickly. It is fully dynamic and works across a full column too.