Excel Formula: Basics to Advanced
Are you heard Best 19 Excel Formula: Basics to Advanced like PERCENT, ADDITION, MULTIPLICATION, AVERAGE, IF , COUNTIF, VLOOKUP, HLOOKUP I don’t know but if you are a beginner and you did no listen about any Excel formula, then don’t worry about excel formula. We explaining you Best 19 Excel Formula: Basics to Advanced in this Post.
What is the work of Excel Formula
Basically Excel Formula are mathematical expressions of functions of formulas which is used in Microsoft Excel to calculate or perform calculations manipulate date and automate tasks. These formulas can range from simple arithmetic operations to complex functions that analyze, summarize, and extract insights from data.
In present time, Excel is popular in every field for doing calculation and keep large data in just one single sheet. Most important feature of excel, you can edit you data according to your need, and save it for always. There are several formula for fast calculation, you just need to enter the number and get your answer but for this you need to apply such type of formula that you wants in your result.
Basic formula You Just Need to Use Excel
firstly, you know the basic formula for using Excel application like Cut, Copy, Paste Arrow keys(left, right, up, down), Tab, Shift+ Tab, Home, Ctrl+ Home, Ctrl+ Arrow keys, Ctrl+ End, Shift+ Arrow keys
| Shortcut keys | Action Performed |
|---|---|
| Ctrl+ A | use for select all content/data |
| Ctrl+ C | use for copy to all selected content/data |
| Ctrl+ V | use for paste copy/cut content/data |
| Ctrl+ B | use for bold all selected content/data |
| Ctrl+ N | for new page |
| Ctrl+ P | for print |
| Ctrl+ X | for cut the select content/data |
| Ctrl+ S | Save |
| Ctrl+ O | Save as |
| Alt+ f2 | Open |
| Arrow keys (left, right, up, down) | Move one cell up, down, left or right |
| Tab | Move one cell to right in a worksheet |
| Shift+ Tab | Move the previous cell in the worksheet (or) previous option in a dialog box |
| Home | Move the beginning of a row in a worksheet |
| Ctrl+ Home | Moves to the beginning of the worksheet |
| Ctrl+ Arrow keys | Moves to the edge of the current data region |
| Ctrl+ End | Moves to last cell on the worksheet, |
| Shift+ Arrow keys | Extends the selection of cells by one cell |
Use of These Basic Excel Formula in Details
Excel Formula for Worksheet
| Function | Purpose |
|---|---|
| DIVISION | Division two or more numbers |
| SUBSTRACT | Substract two or more numbers |
| ADDITION | Adds two or more numbers together. |
| MULTIPLICATION | Multiplies two or more numbers together. |
| AVERAGE | Calculates the average (mean) of a range of numbers. |
| PERCENT | Calculates the percentage of a given number or value. |
| SR. NO. | Use for generating automatic serial numbers |
| AGGREGATE | Use for finding average between Two or more number |
| ADDRESS | |
| IF | Makes a decision based on a condition, returning one value if true and another if false. |
| COUNTIF | Counts the number of cells in a range that meet a specified condition. |
| VLOOKUP | Searches for a value in the first column of a range and returns a value in the same row from another column. |
| HLOOKUP | Searches for a value in the first row of a range and returns a value in the same column from another row. |
| COUNT NO. | Use for count the number of cells |
| MAX | Find maximum value in given numbers list |
| MIN | Find minimum value in given numbers list |
| DATE | Use for represents date format |
| DATEVALUE | For change date format |
| DAY | Use formula for finding day on any date |
| DAYS | Use for finding no. of day between two date |
| DAY360 | Use for finding no. of day between two date |
| TEXT | It is use for multiple purpose(convert no. to text, Display dates in a specified format and more..) |
Use of These Excel Formula for Worksheet in Details
Now we discuss all these Excel Formula with examples which clear your doubt with Excel Formula.
DIVISION
In division function, as you know that division is just reverse of multiplication. In Excel we just use formula like mathematics and applied this formula in all cells we got our result. You know the basic formula of division. Which is ” =(one no./other no.)
SUBSTRACT
ADDITION
Now you think how to add two or more numbers in just one second. For SUM, we use this formula “=SUM(E1:E10)“. Here, the formula start from equal SUM bracket and now we select cells first to cell last. And, we get our result for addition.
MULTIPLICATION
AVERAGE
In average, if you study mathematics than you know that how to find average similarly in excel we just apply the average formula in a cells like mathematics then we got result for getting result in all cells, just apply the formula in all cells. Formula is “=AVERAGE(FIRST NUMBER : LAST NUMBER)“
PERCENT
For finding percentage, in Excel find percentage just like mathematics we just apply the formula and get. Now, we know how to apply formula in Excel for finding percentage we use example like a marksheet. First you know the total gain number and after it divided by total number and multiply by 100. Formula is” = (gain number/ total number* 100)“
SR. NO
Now, we talk about SR number or Serial Number. What is SR number, you know SR number is number which is describe how many items listed in all list. In Excel, there are many sR formula but we used a formula that is valuable. In this formula, if you delete any entry from the seat then your SR number don’t disturb. SR number formula is “=row()-1“. Now you think why we used (-1) in this formula. In this formula minus one show that we create SR number from second sales. If you c start SR number from third cells then you must use minus 2. Similarly for starting SR number for 10th cell we must use minus 9.
AGGREGATE
Now we talk about aggregate function, this function use for multipurpose like for sum, count , maximum, average, minimum etc. Formula is “=AGGREGATE(function_num, options, ref1, ref2, ref3,….)“.
ADDRESS
ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])
Here is a breakdown of the arguments:
- row_num: The row number to use in the cell reference.
- column_num: The column number to use in the cell reference.
- abs_num (optional): The type of reference to return.
- 1 or omitted: Absolute (e.g., $A$1)
- 2: Absolute row; relative column (e.g., A$1)
- 3: Relative row; absolute column (e.g., $A1)
- 4: Relative (e.g., A1)
IF
uploding…..
COUNTIF
uploding…..
VLOOKUP
uploding…..
HLOOKUP
uploding…..
COUNT NO
uploding…..
MAX
uploding…..
MIN
uploding…..
DATE
uploding…..
DATEVALUE
DAY
uploding…..
DAYS
uploding…..
DAY360
uploding…..
TEXT
We use text function in Excel for finding the name of day by date. Simply, we create a date table and apply this formula “=TEXT(date Cell,”DDDD”) and press inter.
May you like: Fighter: Hrithik Roshan fighter movie (2024), Downlod &Watch Best Review