We’re continuing our quest for beautiful and dynamic dashboards. We make the greatest strides towards that by simply extending the date table with four ...

Let’s look at some crucial tools for creating polished dynamic dashboards. We always extend the date table with three important columns: YM Index, Running 13 ...

The Excel SEQUENCE function In this article, we’ll introduce the SEQUENCE function. SEQUENCE function is one of the new dynamic arrays functions and when ...

Last year, Microsoft announced the introduction of a new group of functions in Excel, known as dynamic array functions. One of these – the FILTER function – is ...

I wrote a blog post on the New Excel Data Types in May and stated that “the Sky is the limit” in the way the New Excel Data Types can affect the way we ...

This is part 2 of the Ultimate Vlookup Alternative post and a continuance from last week’s post. We will be using the same Excel workbook as we did in part ...

Almost a year ago, more precisely in May of 2017 a site called defeat excel invited 27 Excel Experts (including myself) to end the endless debate of Vlookup vs. ...

Readers of Excel Unplugged know that I am a big believer in using keyboard shortcuts to be fast and more efficient in Excel. There are a lot of good resources for ...

Ever wondered if your could use conditional colouring on Excel sheet tabs? Of course! This post will feature VBA code that will recolour the Worksheet tab based on a ...

The core of this blog post is a VBA code that will create a copy of a Power Query M code, modify it, create a new sheet and load the result of the modified Query to ...

This is a follow up post on the final result of last week’s post Table.Join function in Power Query. So basically, we want to get from this To this Only by ...

It’s the newest “Quick Excel Guide” template in Excel and all I can say is BRAVO Microsoft. As the name implies, the target audience are Excel ...

How to get a random subset of data with Power Query? The other day I made a Dashboard with a classic by time and relevant dimensions analysis. The data was pulled ...