As promised in the Pragmatism vs. Purity in Excel article from last week, this week’s article will explain the following array formula ...
One of the greatest things about Excel is that with its endless array of tools and commands it almost always offers multiple ways of achieving a certain goal. ...
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 ...
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 ...
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 ...
Can you create a Data Validation Dropdown list that uses data from another workbook as a source? This question has been proposed to me continuously since I published ...
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 ...
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 ...
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 ...
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. ...
There are many more or less unknown tools in Excel. One of those is definitely the Camera Tool. Imagine the following scenario. You have two sheets in Excel. On one ...
One might think that analyzing data with a Pivot table is hard, but Unpivot a Pivot table proves to be even harder. But Power Query or better yet a Query editor ...
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 ...
If someone was to tell you, do a 1;2;3;4;5;6;7;8;… series in Excel, there are many that would not hesitate and go for one of the two options Write 1 and 2 in the ...
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 ...
Custom cell formats are a very important steppingstone to eternal happiness in Excel. And among all Custom Formats, one takes precedence for both, its usability and ...
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 ...
Here’s a nifty little trick I use every day while working in Excel. It’s a two part trick. Part one will be selecting all the blank cells in a range or ...
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 ...
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 ...
In my work as a trainer I’m usually the one serving the Excel goodies to the audience. But every so often I’m the one getting served. Whereas sometimes ...
Simply put, there are two ways to turn Conditional formatting On and Off. The manual way will take you to the Home/Conditional Formatting/Manage Rules… window ...
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 ...
We have a column of dates in Excel, and our goal is to get Q1, Q2,… or QTR1, QTR2,… or Quarter 1, Quarter 2,… . I think you get the picture 🙂 First we ...