Introduction To Excel Formulas & Functions – MS Excel Functions Tutorial Part 1

Every day we perform countless calculations at our workplaces. Imagine how difficult it will be to perform all the calculations manually. Thanks to our calculators! But what if we have a large dataset and need to perform important and lengthy calculations? What if our data is stored in a huge table and we need to make calculations? A business always demands calculations and a calculator does not always serve the purpose. Excel formulas are handy in such situations. With excel formulas and functions you can perform calculations in a jiffy and use the results for effective data analysis. Excel formulas and functions can help you perform almost any calculation or computation you can think of! Guess what, the formulas are easy to understand and don’t require any specialized knowledge!

In this series on Excel Functions and Formulas, we will cover below topics:

Let us first understand the difference between excel formula and excel functions.

An Excel formula has to be created manually by the user and it does not take arguments. For example, let us suppose that we want to add the contents of cells from A1 to A4 using excel. The formula for adding the content will be:

=A1+A2+A3+A4

This formula has to be typed in by the user manually.

On the other hand excel has some pre-defined functions. Functions can be created by the user by simply entering the equal to sign in a cell and the function name. For example, in order to add the contents of four cells from A1 to A4 a user has to enter the SUM function:

=SUM(A1:A4)

A function takes arguments. This function will automatically add the contents of the cells from A1 to A4.

Excel has a wide range of functions for performing calculations and data analysis. In next posts, we will learn how to insert excel formula, functions and named ranges. We will also learn various types of functions in excel.

In next post, we will learn about Inserting Formula, Function & Named Range In Excel.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">