Excel Unplugged
Remove Blank Rows in Excel

How 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 ...

AI in Excel – Part 3 – Analyze Data, the Future of Data Analysis?

Welcome 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 ...

AI in Excel – Part 2 – Column From Examples

Welcome 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 ...

AI in Excel – Part 1 – Flash Fill

Welcome 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 ...

Global Excel Summit 2022

Hello 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 ...

Extending the Date Table – Part 2

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 ...

Extending the Date Table – Part 1

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 ...

How to Highlight Weekend Dates in Excel Table

Highlighting 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 ...

ggplot2 basics: learn ggplot2 in 15 minutes!

R Academy Menu ggplot2 basics: learn ggplot2 in 15 minutes! R Beginner Tutorial R Beginner Tutorial – Basic Syntax R Beginner Tutorial – R Objects R ...

SEQUENCE function – Add it to your toolbelt today
September 14, 2021

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 ...

R Language Overview and R Language Examples
September 10, 2021

R Language Introduction and R Language Examples R is a programming language and software environment for statistical computing and graphics. It is free and ...

Consolidate Multiple Excel Sheets From Multiple Excel Files

We 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 ...

Turning Product Descriptions into a list of attributes with Power Query

You 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 ...

Extract Columns that Contain Actual Values

We 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 ...

Transforming a Table to Top 10 (by values) and Others with Power Query

How 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 into a table of ten ...

Filtering a Table to a List of Values in Power Query or Power BI

Knowing 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 Values by using Lists in ...

Excel FILTER Function – The Function that does Everything

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 ...

XLOOKUP is finally here

Today 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 ...

Start And End Date Of The Week With Power Query

One 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 for ...

Amsterdam Excel Summit and Power BI Summer School in the Netherlands

In Slovenia (where I come from) there is a significant shortage of Excel and Power BI conferences. Basically, there are none (I’m planning to change that in ...

The New Data Types already enhancing Excel

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 ...

Importing CSV Files with Changing Start Row

In this post, we’re going to talk about importing CSV files with power query! This is a guest post written by John MacDougall, an Excel MVP from Canada. John ...

The Amsterdam Excel Summit 2018

Jan Karel Pieterse and Tony de Jonker will give Excel enthusiasts reason for joy on the 7th and 8th of June 2018. This longest running Excel Conference in Europe ...

New Data Types in Excel – Game Changer

New Data Types in Excel will undoubtedly be THE talking point of the near future Excel evolution. That being said, they are also the reality in Office 365 Fast ...