Excel Unplugged

Tag Archives: Excel

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

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

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

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

    Ultimate Vlookup Alternative? (Part 2)

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

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

    Conditional Colouring of Excel Sheet Tabs with VBA

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

    Making Importing from Folder in Power Query (or Power BI) Bulletproof

    I’ve always been a big fan of the Import from Folder feature in Power Query. So much so, that I wrote my first post on the topic way back in February of 2015. ...

    Modifying Power Query M code with VBA
  • January 23, 2018

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

    Simulating a “Tabular Form” Pivot Table Layout with Conditional Format

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

    Welcome to Excel Template

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

    Get a random subset of data with Power Query

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

    Search a Range for the closest value to a chosen number

    How to find a closest value to a chosen number within an Excel range? Let’s do it through a simple example! We start with a range of values in Excel (A1:G20). ...

    Dynamic Power Query

    Another example how to utilize dynamic capabilities of Power Query comes from our reader. The following post was written as the reply to a great question Dane asked ...

    A great honor for Excel Unplugged

    Yesterday I got an Email form the guys at spreadsheeto.com notifying me that Excel Unplugged will be featured on their “69 World’s Best Excel ...

    Amsterdam Excel Summit 2016 report

    This post is a tribute to the event, that is one of a kind in Europe, and gives Excel professionals a rare opportunity to meet brilliant people, that have dedicated ...

    Power BI publisher for Excel (The Times They Are A-Changin)

    The title of this post is stolen from the legendary Bob Dylan song, but rightfully so since it’s one of the biggest game changers in the Power BI game (and ...