We love Joins and we hope you do too! If you’re not there yet, you should really check Part 1 of this series and learn why Power Query Join is...
Read MoreWe love Joins and we hope you do too! If you’re not there yet, you should really check Part 1 of this series and learn why Power Query Join is...
Read MoreWho doesn’t love Join? It’s like Excel’s LOOKUP, but better! I use Join all the time for merging tables one way or the other. Let’s look at all the different...
Read MorePower Query is a great tool for data transformation. I often use as an upgrade to Excel. We already covered two great functionalities in first two parts: fill and split....
Read MorePower Query can be more than an ETL tool – I often use it as an upgrade to Excel. It has some neat functionalities that make transforming data so much...
Read MorePower Query is meant to be an ETL tool, but I often find myself using it in addition to Excel. Power Query has some neat functionalities that make transforming data...
Read MoreLet’s see how to create your own data types in Power BI! This is a follow up of Part 1, where we learned how it’s done in Power Query. How-to...
Read MoreHow can you create your own data types in Excel? Oh yes, you can do it! In this article, we’ll learn how you can create data types in Power Query....
Read MoreHow to remove blank rows in Excel? Let’s look at some examples for simple and complicated tables. Simple Table Let’s start with the following table. The table contains clean empty...
Read MoreWelcome back to Artificial Intelligence in Excel! In Part 1, we looked at a feature called Flash Fill. It works by recognizing patterns of data and filling out the remainder....
Read MoreWelcome back to Artificial Intelligence in Excel! In Part 1, we’ll looked at a feature called Flash Fill. It works by recognizing patterns of data and filling out the remainder....
Read MoreWelcome to the brave new world of Artificial Intelligence in Excel! In this article, we’ll look at a powerful new feature called Flash Fill. It works by recognizing patterns of...
Read MoreHello Excel Enthusiasts. We haven’t yet recovered from the Excel Virtually Global conference and the first-ever Bangladesh Excel Summit. And already there is a new big conference to speak about....
Read MoreWe’re continuing our quest for beautiful and dynamic dashboards. We make the greatest strides towards that by simply extending the date table with four important columns: YM Index, Running 13,...
Read MoreLet’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 and Current Month. Part one...
Read MoreHighlighting Weekends can be hard in Excel. So just for fun, we’ll do this in three different ways: we’ll use conditional formatting to highlight the weekend dates in a column....
Read MoreThe Excel SEQUENCE function In this article, we’ll introduce the SEQUENCE function. SEQUENCE function is one of the new dynamic arrays functions and when combined with other functions can do...
Read MoreWe often have our data spread out in multiple Excel workbooks and sheets. How do we combine all of them into one table? Let’s walk through an example. We have...
Read MoreYou can also watch the video version of this content here: https://youtu.be/5QDERKmMvZQ or watch the embedded video at the end of this post. It’s true Power Query magic. One task...
Read MoreWe often work with large datasets containing multiple columns, but only need a few. In this tutorial we’ll show how to extract the columns that contain Actual values from your...
Read MoreHow to get the top 10 values in a table, and an aggregate for all the other data? Our goal today is to turn a table of countries with attributes...
Read MoreKnowing how to use Lists in Power Query or Power BI is like a superpower. This Post will show you how to filter a Table to a Dynamic List of...
Read MoreLast 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 possibly the...
Read MoreToday is most definitely one of the most exciting days of this year for all Excel users out there. Today the endless discussions about whether people should use VLOOKUP or...
Read MoreOne of the most popular posts on Excel Unplugged is Formula to get the Start and End Date of the Week. For the last two years I’ve been a strong advocate...
Read More