Excel Unplugged

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 recognizing patterns of...

Read More

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 new big conference to speak about....

Read More

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 important columns: YM Index, Running 13,...

Read More
Banner Extending the Date Table

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 and Current Month. Part one...

Read More

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

Read More
Amsterdam Excel Summit 2018

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 is returning for the...

Read More
The Unlock Excel Conference - Gašper Kamenšek

Unlock Excel Conference – Australia

The Unlock Excel Conference  took place in April in three cities across Australia. I joined Excel MVP’s Liam Bastick (SumProduct LLC), Jon Peltier (Peltier Tech), Ken Puls (Excel Guru), Mynda...

Read More
Ultimate Vlookup is PowerQuery

Ultimate Vlookup alternative? (Part 1)

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

Read More

XL Shortcut

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

Read More