Excel Unplugged

Category Archives: Excel Facts

Search a Range for the closest value to a chosen number

We start with a range of values in Excel (A1:G20). Now we are looking for a formula to get the closest value to the value we input in cell I1. First we’re ...

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)

This is really a lose – lose situation in Excel and therefore a true Sophie’s Choice. Let’s elaborate on the two commands. Excel Table A table is ...

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, we are just an innocent bystander when enthusiasm gets the better of people and they start drifting around Excel inserting data in places where ...

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

This is something everyone should know about Excel since it both enables Excel to do lightning speed calculations and limits Excel in a great way. And the guilty ...

"