written by
Chris Chua

51 Excel Functions That Will Change Your Life in 2019

Microsoft Excel 1 min read

Happy new year to you! It's the time of the year where we should be making new year resolutions and I hope you've decided to put defeating Microsoft Excel at the top of your wishlist this year.

Photo: Sharon McCutcheon / Unsplash

Why Microsoft Excel?

2.5 quintrillion bytes of data is being created every day. And this number will continue to grow with the increasing amount of technologies available to us (think smart watches and home IoT devices). Over the last two years alone 90% of the data in the world was generated.

According to an Accenture study, 79% of enterprise executives agree that companies that do not embrace Big Data will lose their competitive advantage and die out. Further, 83% have pursued Big Data projects to gain a competitive edge.

Photo: rawpixel / Unsplash

And Microsoft Excel remains a popular tool for companies to work with data.

No matter where you are and what your role is, if you're working in an office, you're expected to know Excel, and know it well.

Change your life with Excel functions

An Excel function is basically a preset formula that typically takes input values, performs calculations, and return an output value.

The magic happens when you provide cell references instead of actual values, and Excel will automatically re-calculates when the values in these cell references change.

Save time and reduce error

Photo: Lukas Blazek / Unsplash

When you set up your Excel worksheet with formulas, you invest that little bit of time in exchange for much more:

  • Time saving: Every time you can re-use your formulas, you recoup the initial time invested and free up more time for you to do other stuff.
  • Zero error: Since you didn't re-write any formulas, there is zero chance of making any errors in calculation.

Life-changing Excel functions

In this year, I'll be sharing 51 essential Excel functions that will be life-changing to anyone who has mastered them. These commonly used functions will be your best tools against any Excel monsters that you'll encounter.

Photo: JESHOOTS.COM / Unsplash

51 essential Excel functions

As I publish more articles to reveal each of these essential Excel functions, I'll add them to the list below:

  1. SUM
  2. (coming soon)

Stay informed

Share this article with your friends and colleagues if you think this will benefit them.

Also leave down your email below to receive the latest Excel articles.

Excel functions