Excel Unplugged

Tag Archives: Excel Functions

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

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

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

    Excel vs. Excel 365

    Whatever side of the Cloud vs. On Premise debate you take, it’s a fact that at this point there are two Excel 2016 versions out there. First there’s ...

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

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

    REMOVE, REPLACE OR SEPARATE BY LINE BREAKS (ALT ENTER) INCLUDING VBA

    Alt Enter is known as a manual line break in Excel. It’s what you use when you want to have text show in multiple lines regardless the width of the column. But ...

    Sum up the diagonal of your data anywhere on a Sheet

    The title of this post is actually a question I got on one of the last trainings I gave in 2015. It struck me as a great little sample of using array formulas, and ...

    NETWORKDAYS.INTL and WORKDAY.INTL

    I can still remember when I learned about the WORKDAY and NETWORKDAYS functions. I found them very useful and used them regularly but since I also do a lot of ...

    Another formula to get quarters from dates

    A while back I wrote about multiple ways to get quarters from dates. Even “manual” quarters (starting with any months you like). You can read that post ...

    Difference between two times formula in Excel

    In short, times in Excel are decimal numbers between 0 and 1 that show you the percentage of the day that has past. Now with that in mind let’s calculate two ...

    Last word in a string with an Array formula

    As promised in the Pragmatism vs. Purity in Excel article from last week, this week’s article will explain the following array formula ...

    Last day of previous month formula in Excel

    On many occasions we would like to somehow get the dates belonging to the last day of current, previous or any other month, the first day of this month or any day of ...

    Boost your Excel efficiency with one key – F5 (Go To and Go To Special)

    Very often you will find yourself in a position where you wish to either move efficiently through the workbook or you wish to select only cells containing certain ...

    Creating a dynamic Dropdown List with Data Validation from another workbook with a little help from Power Query

    Probably the longest title of all times, but it leads to something great. First let’s explain Power Query. Power Query is an AddInn for Excel and part of ...

    The New Pivot Column option in Power Query

    If some pictures are hard to view, you can get the PDF of the article The Pivot option in Power Query. With the latest update of Power Query AddInn for Excel quite a ...

    Option Button Control on the Developer Tab, Top Bottom 5 in Pivot Table and CHOOSE Function in Excel

    We have a dish where I come from (Slovenia), called Minestrone. It’s interesting since there is no single recipe for it. It’s made from whatever ...

    Dependent Data Validation dropdown lists

    Our goal here, is to create a dropdown list by using Data Validation, where the contents of the list will be determined by another Data Validation Dropdown list. ...

    Get Todays Date in Cells A1:A15000

    In my work as an Excel Trainer, I do love to challenge the audience. And one of my favorite challenges to extend is the focus of this post. So fill all the cells in ...

    Convert Text to Numbers in Excel

    A task that comes about every so often in Excel and can be quite tricky. Now our ultimate goal is to get a number out of something like (text 1 text) or even ...

    Rounding numbers to a specific multiple in Excel

    Excel can be very tricky about rounding numbers. Almost half of Excel users still believe that if they format a cell to round to two decimals, that what they see is ...

    Why Excel thinks “Time is on my side” by the Stones is a joke on him…

    Excel has quite a few funny perks. Once you get over the 15 digit limit in Excel and the fact it does not calculate exactly as it should, you will sooner or later ...

    Sum of ten largest values

    This will be a short lesson on three great and sadly unknown functions and how to use them as an array function. The eighth LARGEst value One of my favorite ...