Uses of basic excel formula | Excel

Uses of basic excel formula

Excel Formulas – We have constantly heard that How Excel is one of the most powerful software tool. Excel equations is much the same as enchantment which makes life simpler from complex and time consuming calculation of math, insights, Business etc. It has capacity to figure numerical data using basic excel formulas. In this article advance excel training in Chandigarh planning to emphasize especially on basic of Excel Formulas. So this article gives you answers of following:

Basics of Microsoft Excel

- How to open Excel Spreadsheet

- What is Excel formula?

- How to use excel formulas in excel?

- How to perform basic calculation in excel

Top 10 Excel formulas useful for any professionals.

Advance excel Training Program that make you Excel Master

When you do realize how to use basic formula in excel, at that point you can easily find ways to use it in your work. Before entering usually down into the Excel lets take in a few basic like How to start Excel? So how about we rapidly take the review of Excel interface. The greater part of us may know about all these stuff. What you have to would when you like to begin excel program? For the most part we click on the start  button then >> Programme >>MS office >> select MS Excel. Or on the other hand essentially type "excel" in Run and press Enter at that point clear Excel spreadsheet will open.

What is Excel Formula?

Presently what do you meant by excel formula? Sounds like excessive language! Be that as it may, don't stress! Excel formula makes like simple. In the event that you need to calculate numbers in very active passion, then you can use excel formulas. Excel formula will figure numbers or qualities for you so you don't need to invest much time in calculating huge numbers manually and risk making mistakes.

"A formula is an instruction given by the user to do some activity inside spreadsheet, for the most part its calculation."

This is the formal meaning of excel formula. Our main concern is learn essential excel formula in excel so we should see How to enter a formula in Excel? When you enter a formula in excel then you need to clear about your thoughts or what you need to do in excel. Suppose you are in one cell and you need to enter formula then firstly you need to begin by typing the = (equal) sign, at that point the staying of your equation.

Here excel gives another choice to you. You can also begin an equation with either an or more (+) sign or less (- ) sign. Excel will accept that you're typing a formula and after pressing enter; you will get your coveted excel formula result. In Case you don't type the equals sign first, at that point Excel will accept you are composing either a number or a content.

Following are a few stages that you have to pursue for entering a formula into the excel

- Go to the cell in which you need to enter a formula.

- Either type equal sign (=) or (+) or (- ) sign to disclose to Excel that you're entering a formula/

- Type remaining formula in the cell.

- Finally Press Enter to confirm the formula.

Take a simple excel formula with example, If you need to calculate entirety of two numbers i.e. 5 and 6 in cell A2 at that point how do you calculate. Let's follow the above steps:

- Go to the "A2" cell

- Type "="sign in cell A2

- At that point enter equation, Here you have do sum of 5 and 6 so formula will be "= 5 + 6

- When you finish your formula at that point Press "Enter". You will get your coveted outcome i.e. 11

Presently commonly as opposed to getting your coveted excel formula result, you will experience with an error in excel. Following are some excel formula errors looked by many excel users.

Figure out how to arrange, format and calculate information easily. Create skills to master excel tools, formulae and function. Analyze information from alternate points of view.

Errors in excel formulas

How often you are experienced with excel with errors? It's a disappointing knowledge when excel gives an error. For the most part there are two kind of excel formula error happens in excel first is #VALUE And #NAME. This will occur if the formula you've typed is invalid.

#VALUE Error

This means you have entered an equation that was value, however Excel couldn't figure a valid results from your formula.

Read

• Microsoft word
• How to use MS word

Reasons for #VALUE Error

- Including cells that contain a non-numerical value.

- Error with formula

- Non-numerical value

This excel formula error is normally experienced when the formula isn't organized accurately or contains different errors as seen in the example below

How to Correct #VALUE Error

Rather than using calculation operators, use a function, for example, SUM, PRODUCT, or QUOTIENT to play out an  arithmetic operation. Ensure that including cell does not contain a non-numerical value.

#NAME Error

#NAME error happens when Excel doesn't identify text in a formula. Look at following picture. In the event that we need to calculate excel formulas for sum of number of student then what we do? we just insert SUM equation at that point select range and press enter. Be that as it may, in the event that we you enter formula  SUM and select range, press enter. Excel gives a #NAME error. Because you enter wrong formula.

How to Correct #NAME Error

- Ensure formula is correctly entered

- Make sure reference marks are added and they are balanced from left and right.

- Replacing a colon (:) in a range reference. For e.g. SUM(A1A10) should be COUNT(A1:A10)

Some Basic Arithmetic Excel Formulas

Arithmetic formulas  are by a wide margin the most well-known kind of formula. It mainly involve mathematical operators like Addition, Subtraction , Multiplication, Division etc to perform calculations. Look at the following table.

Top 10 Basic Excel Formulas That You Need To Know

Don’t waste any more hours in Microsoft Excel performance things manually.

Excel formulas decrease the the measure of time you spend in Excel and increment the certainty of your data and your reports.

Name of Formulas	Formula	Description
SUM	=SUM ( Number1, Number2, … )	Include all numbers inside range came about into sum of all numbers.
AVERAGE	=AVERAGE(number1, [number2],…)	Calculate average numbers in a range
MAX	=MAX( Number1, Number2, …  )	find largest number in specific range
MIN	=MIN( Number1, Number2, … )	Calculate smallest number in specific range
TODAY	=TODAY()	Returns the current date
UPPER	=UPPER(text)	Converts text to uppercase.
LOWER	=LOWER(text)	Converts text into lowercase.
Countif	=COUNTIF(range, criteria)	This function counts the number of cells within a range that meet a single test that you specify.
counta	= COUNTA(value1, [value2], …)	This function counts the number of cells.
ABS	= ABS(number)	ABS function returns a value of the same type that is passed to it specifying the complete value of a number.

Recommended Excel  Formulas Training:

If you just simply searching on Google for advance excel training in Chandigarh you may get long list of excel training courses. Anyway you may get confounded by referring such a large number of excel resources. I might want to propose you go for  Advance excel training. Online courses are vastly improved than a share of the costly classroom training courses since they give time adaptability and cost effectiveness.