ms excel formulas pdf: So, the question is why use excel formulas, here is the answer, the excel formula has the key to the wonders of an excel spreadsheet, without knowing those formulas excel cannot be used at its optimum capacity.

So here is a list of why you should get skilled in excel formulas:

1. Important for most of the jobs: in era of digital economy, excel holds 90% of the job market.
2. Repeating transactions-it will calculate the repeated transactional by itself using formulas with 100% accuracy.
3. Increasing your skill worth in the market makes you more compatible.
4. Makes you more productive as you can work with lesser efforts with good skill of formulas.
5. Your work is more accurate and faster if you know how to arrange formulas in such a way that you get the most out of it.
6. Skilling in excel formulas helps you skim through the data by combining them with conditional formatting, you will be able to “see” important trends, relationships, etc.

Contents

• Title –ms excel formulas pdf
• Format- PDF
• Size-  mb
• Pages- 116
• Language- English

There are two things in excel that can be used, that is formula and function,

1. Formulas

In Excel, a formula is an expression that operates on values in a range of cells or a cell. For example, =A1+A2+A3, which finds the sum of the range of values from cell A1 to cell A3.

1. Functions

Functions are predefined formulas in Excel. They eliminate laborious manual entry of formulas while giving them human-friendly names. For example: =SUM(A1:A3). The function sums all the values from A1 to A3.

### Functions Used In Excel

1. Text Functions
2. Math & Trig Functions
3. Lookup & Reference Function
4. Statistical Functions
5. Financial Function
6. Date & Time Functions
7. Logical Function

### Microsoft excel formulas list

 Name of Formulas Formula Description SUM =SUM ( Number1, Number2, … ) Add all numbers within range resulted into the sum of all numbers AVERAGE =AVERAGE(number1, [number2],…) Calculate average numbers in a range MAX =MAX( Number1, Number2, … ) Calculate or find the largest number in a specific range MIN =MIN( Number1, Number2, … ) Calculate or find the smallest number in a 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 criterion that you specify. counta = COUNTA(value1, [value2], …) This function counts the number of cells that are not empty in a range. ABS = ABS(number) ABS function returns a value of the same type that is passed to it, specifying the absolute value of a number.