In this article we will talk about the INDEX and MATCH formulas, which are two useful lookup functions when others (such as VLOOKUP) reach their limits. Do you like examples? I do, let’s be practical: Example The report below, which I know it’s very complicated, hard to understand (not). We see that the Sales box is empty, […]

One thing you are probably using in Excel is multiplying formulas, you know, that thing that happens when you drag from the botton-right part of a cell. In this article we will try to understant the “mistery” behind formula multiplication. We can take the image above as an example, we have 2 columns and want to apply […]

Recently a friend who works in tourism asked me for a little Excel related help. He is working in the housekeeping department in a relatively large hotel and needed help with keeping track with the expiry date of products. He had a report that had all the rooms in the hotel and expiry dates for each product. He wanted […]

In case you didn’t hear about Pareto, let me shed a little light. He is the person that gave us the Pareto principle, also known as the 80/20 rule or the uneven distribution principle. It’s not my point to tell you the story of his life, you with a short Googl’ing session you can find out […]

I am starting a series of articles on formulas in Excel and Google Sheets. I am putting these 2 together because most of the formulas work on both platforms pretty much the same way. I will skip the basics, like SUM or AVERAGE and will try to write about the formulas that do not get invited […]

Let me start this post by describing the steps most people take when creating a chart in Excel: Prepare a table that contains the data set Select that table Click on the insert chart icon Hope that the chart will look exactly like I want it to Don’t get me wrong, I don’t have anything against […]