Excel Unplugged

Category Archives: Excel Facts

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

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

Let’s go to Amsterdam

This Post is a Call To Action for all European (and UK 🙂 ) Excel Lovers… Whereas the reasons for going to Amsterdam are clear to anyone, I’d like to ...

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

Format/Default Width…

I should give a subtitle of »Oh, so that’s what it does« to this post. So the command we are talking about is HOME/Format/ Default Width… First I will tell ...

Using Named Ranges in Excel

There will be three different views of named ranges this post. First all different techniques of creating named ranges. After that a few techniques of using named ...

Amsterdam Excel Summit Report

Whereas this post does not contain any excel shortcuts or commands, it does contain plenty of information I wish I had when I was trying to expand my Excel horizons. ...

test = zzyw = BBAb

The title might make you think that I lost my mind, but this is actually one of the best tricks to show your colleagues and also a transparent demonstration that all ...

Custom Views or Excel Tables (Sophie’s Choice in Excel)

Custom Views or Excel Tables? This is really a lose – lose situation in Excel and therefore a true Sophie’s Choice. Let’s elaborate on the two ...

Learn a foreign language with Excel

Surprisingly, this is not a post about the Translate feature in Excel. Rather we will take an in depth look into Cell Format and a great feature of Excel that allows ...

Scroll trouble in Excel (scrolling beyond your data)
February 17, 2015

Sometimes in Excel, people insert data in places where they weren’t supposed to. And even if they remove any trace of their wayward journey, a scroll bar ...

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

Case sensitive/insensitive Sort in Excel (bug or a feature)

This post will talk about the way that Excel sorts data and the Case Sensitive sorting it offers. If we look at this data And sort it in ascending order (A-Z), we ...

What Excel should learn from Word
November 25, 2014

I’m only guessing, but I think that anybody who wants to use Excel at an above average level, will have to learn at least a few keyboard shortcuts to get ...

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

Who knew (Just another day with Excel)?

One day as I was giving a basic(!!!!) Excel training, my mind got sort of blown. We were discussing the use of A1:A100 in the Name Box for the selection of a range ...

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

15 digit limit in Excel

15 digit limit in Excel is something everyone should know about. Why? It both enables Excel to do lightning speed calculations and limits Excel in a great way. And ...