Already 1 month since the creation of my blog. Continue reading “1 month already”
In Excel, you can allocate a name to a cell or group of cells (range). This article describes how and why using named ranges in your spreadsheets. Continue reading “Named Ranges (★)”
At the beginning of each month, I will publish a tip to make easier & quicker your use of Excel. Continue reading “Tip of the month (1)”
Hello everyone, it is 29th February ! What makes this day so special ? Continue reading “Happy Leap Day ! (★★)”
Have you ever met this Excel “issue” before ?
Your manager just called you and sent you a file with the table below : Continue reading “The powerful Index / Match (★★)”
Let’s start this blog with the Vlookup function which is probably the most widely used function in Excel and determine whether it deserves its popularity or not. Continue reading “The very popular vlookup function (★)”
Today, Monday 15th February 2016, is the official launch of my blog.
The idea is to discover, share and learn about Excel, VBA & Power BI through interactive articles, videos and tips.
Many articles to come…