VIP : Accompanying file

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 […]

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 […]