Lesson 8 - Why to Learn Formula or Function
- Home
- / Fun With Excel
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.
Vinay Bhatt is the Founder of LearnInCreation, an education and technology platform focused on making computer science and digital learning simple, practical, and accessible. He holds a B.Sc. degree from Kumaun University and has professional certifications in Full Stack Web Development, Digital Marketing, and Ethical Hacking. Passionate about education and technology, he creates beginner-friendly courses, practical learning resources, and projects that help students develop real-world skills and prepare for their careers.
LearnInCreation helps students learn computer science and technology through easy-to-understand courses, practical projects, books, e-books like learning resources, enabling them to build skills for academic success and future careers.
Watch old videos of computer lessons, Subscribe us on Youtube
