I recently posted on how to make a process of getting data from a folder bulletproof. You can read it here. Whereas that post was about getting data from multiple ...

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

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

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

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

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

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

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

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

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

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

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

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

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

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? This is really a lose – lose situation in Excel and therefore a true Sophie’s Choice. Let’s elaborate on the two ...

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

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

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

It seems that lately Excel users can be separated into two groups. One group that gets the new Excel (2010 or 2013) but still uses the application as if it’s ...

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

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

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

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