This site uses cookies to store information on your computer. Some are essential to make our site work; others help us improve the user experience. By using the site, you consent to the placement of these cookies. Read our privacy policy to learn more.

Digital skills

Top 5 Excel functions you might not know Logo cgma

  Liam Bastick |   Free |   Feb 2020 |   FM magazine

Our Excel MVP unveils a fistful of functions that pack a real punch.

Topics covered:
  • Management accounting: Digital skills: Digital content creation, Advanced

5 Comments/Reflections

Julian Thomas-Bell

Julian Thomas-Bell Oct 2023

This was a very useful article which I have bookmarked for future reference.

The N function is something I was not aware of, and will be able to use

I use SUBTOTAL regularly and will now switch to AGGREGATE

David Johnson

David Johnson Aug 2023

It's always worthwhile looking to see what Excel functions are available that you don't currently use, to see if there is a different and more efficient way of doing things.
Rashmi Patel

Rashmi Patel Aug 2023

Andrew Teal

Andrew Teal Jan 2023

Imalka Thushari Gunawardena

Imalka Thushari Gunawardena Jun 2022

Great recap of useful excel formulae to be used in day to day tasks.
AGGREGATE instead of SUBTOTAL and TEXTJOIN instead of CONCAT/CONCATANATE have been immensely helpful for my team.