Excel

Have you ever worked with a database using filters and want to know the sum of that filtered data in Excel? To do this, if you’ve used the “Sum” function, you’ll have noticed that the result is the sum of all the data (including data not included in the filter). This article proposes a function […]

A few weeks ago, a reader asked a question in our forum. Unfortunately, I can’t find this question! Nevertheless, I’ll answer it in this article. The reader was wondering how to create a bar chart that was both clustered and stacked in Excel.   When to use both clustered and stacked charts? You might need […]

When you develop a financial model or any other management tool in Excel, you need dynamic calculations that update automatically. So, when you have to work with the age of certain individuals, you have to make sure that these individuals will have aged a year when you use your tool in a year’s time! To […]

When I’m giving training courses, it often happens that a learner has trouble finding out how, for example, to write a > sign in a formula. When changing computers or keyboards, it can indeed be difficult to find special characters, especially when settings have been modified. There’s a universal way of getting around this, and […]

If you’re not yet familiar with the VLOOKUP and HLOOKUP functions, you’re definitely missing a valuable tool in your toolbox! These two functions enable highly efficient searches and automate many processes. That said, like all Excel functions, these are most interesting when used in combination with other functions, such as MATCH.   What is the […]