Excel Training Courses – Intermediate

System monitoring, for an up-to-date and secure Power BI environment   As part of the 10 steps to a successful Power BI implementation series, we take a look at the most important success factors for an enterprise Power BI implementation. Indeed, Microsoft recently published a series of articles on the adoption of Power BI in […]

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

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

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

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

What is an RSS feed? An RSS feed (really simple syndication) allows you to follow the latest updates on a website. A site’s RSS feed is always symbolized by an orange square with white curved lines. For example, on this site you have two feeds: one to follow the evolution of the articles published on […]