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.
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.
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
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.
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:
- (coming soon)
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.