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

Custom Power Map to show Mick Jagger’s stage presence during Gimme Shelter

This article will show you how you can use that nobody’s child called Power Map or 3D Map to solve a problem many of us wish to run into one day. We get ...

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

Creating a Dynamic Calendar for Your Data Model

This article will take care of the most fundamental need when it comes to Power Pivot or even Power BI and Time Intelligence. Having a Date Table (Calendar Table) is ...

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

New Charts in Excel 2016
May 26, 2015

Up to Excel 2016, if you wanted to create advanced and special charts, your best option was Jon Peltier. He created great Excel charting add-ins. My favorite is ...

My three favorite things in Excel 2016

First off, this post is written on basis of a public preview of Office 2016 which you can get here. The official version will contain a few more goodies like many ...

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

Excel Shortcut of the year

On February 3rd this year I published a post titled My Excel Shortcut of the Year. Now, only two months later, I’m passing the flattering title on to another ...

Add data to your Chart (the easy way)

(as simple as Copy and Paste) This is our sample data. First we select the data for all days but only for the first three months and press Alt + F1. That is the best ...

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

Formula to get the Start or End Date of the week

On many occasions and in many dashboards, time will be the main factor of your analysis and reports. As far as time goes, you can create Yearly, Quarterly, Monthly, ...

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

Allow users to edit ranges in Excel

One simple command that elevates Excel Sheet protection to a whole new level. Imagine wanting to protect a Worksheet in Excel but with a few requirements. all ...

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

Get data from Folder in Power Query

Following a wide demand, I also wrote a post about getting data from Excel files in a folder. You can read it here and I recently followed up with a post on how to ...

My Excel Shortcut of the Year

In my work as a Trainer and also as a Data Scientist (I love that term), Shortcuts in Excel are a vital part of doing things efficiently. This shortcut helps you ...

WORKDAY and WORKDAY.INTL functions in Excel

I can still remember when I learned about the WORKDAY function. I found it very useful and used it regularly but since I also do a lot of project calculating in ...

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

Holiday chart in Excel
December 28, 2014

This is what happens when someone has too much time and Excel 🙂 Happy holidays and all the best in 2015 to all Excel lovers!

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