Microsoft Excel – Why To Learn Formula, Function

Course - Fun With Excel

Why you should learn about Formula and Function?

Before getting started with Advance excel, you should need to know why you should learn about formula and function. What’s a need of formula or function in excel.

Excel is a spreadsheet program, allows you to enter, edit, maintain and analysis a data. And to maintain and analysis a data it’s important to edit your data. The best part of excel is that it’s allow you to create or insert the formula or function respectively. It’s help to create a new mathematical formula and execute the pre-defined one.

Imagine a situation that, you have a large data of company annual sales, and at the end of the data there is a column of total annual sales which is a total sum of twelve month sales.

Now, at the time of rechecking, data analyzer found that there is a mistake in sales data in the month of March, July and September. Since Total Annual Sales is sum of all twelve month it means Annual sales is wrong.

Now, an employ who prepared sales data is need to correct it. If he manually calculated each sales and then prepared an annual sales reports, then it’s a time taken process and also it’s not a right method to work with excel.

On the other hand, if he knows about formula and function then he just need to change the entry and excel itself calculated the month sales and finally shows the Annual sales in column of total annual sales, and that’s a right use of excel.

Unless you didn’t work with formula and function while making a big sales or purchase reports you will just use a text editor to input data not Excel spreadsheet.