Excel

CFO Masqué brings you a series of tutorials offering numerous Excel tips and tricks. You can also join the VIP program to download the accompanying files. Most of these articles were written by an MVP (Microsoft Most Valuable Professional).

Dashboards

Excel: Create a clustered and stacked chart

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 …

Excel: Create a clustered and stacked chart Read More »

Sophie Marchand M.Sc.

16 July 2018

Excel

Stop searching in vain for symbols and special characters on your keyboard

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 …

Stop searching in vain for symbols and special characters on your keyboard Read More »

Sophie Marchand M.Sc.

06 July 2015

Excel

Excel functions: VLOOKUP, HLOOKUP and MATCH

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 …

Excel functions: VLOOKUP, HLOOKUP and MATCH Read More »

Sophie Marchand M.Sc.

24 March 2011

Aucun résultat

(Page: 1 de 1)