Now we will see that how we can use formula in multiple worksheets
Suppose if you want to enter the total salary of any one person in a
particular sheet, whose different salaries are written in different sheets,
so for that we will simple use our usual formula method.
We will write equal to (=) in the cell where we want the total salary to be
written and then proceed by selecting the cells from different sheets where
the persons salaries are written.
This will give us the total salary of that particular person from different
sheets together to our required cell.
Now if we have many different rows to calculate then and we can just simply
use 'Sum' function for getting the total salary.
To get 'Sum' function we can simply press 'Alt+=' key from our keyboard,
and after that select every cell from different sheets to get the total
To view that which formula we used, we can just simply use 'Show Formulas'
option from FORMULAS tab.
A formula in Excel is an expression that works with values in a range of cells or a single cell. For example, =A1+A2+A3 calculates the sum of the values in cells A1 through A3. An argument of a function is a value that must be supplied to obtain the function's outcome in mathematics.
A formula is a set of instructions that tells the computer how to perform a mathematical operation on a given value. Formulas are most commonly employed in spreadsheet programmes like Microsoft Excel when it comes to computer software.
In your worksheet, you can create a basic formula to add, subtract, multiply, or divide data. Click the cell in which you wish to enter the formula on the worksheet. Type = (equal sign) followed by the constants and operators you want to use in the calculation (up to 8192 characters).
Worksheet formulas are built-in functions that are typed into a cell as part of a formula. When learning Excel, these are the most basic functions.
Formulas are not limited to just numbers; they can also be used with text and dates. For example, you could write a formula that calculates the number of days between two dates or counts how many times a word appears in an entire document.
Very good 👍👍
I learned a lot of formulas and functions through this lecture in free of cost. Thanks
Please give us an assignment or workbook to download and practice Excel after watching videos.
MORI PARTH RAMESHBHAI
IT'S VERY GOOD AND USEFULL APLICATION WHERE WE CAN LEARN MANY COURSE AND MAKE CARRIER FREE OF COST . HOW CAN I APPRICIATE YOU I DON'T HAVE ANY WORDS REALLY IT'S VERY USEFUL FOR WHO CAN DO JOB LIKE ME
In this video they have mentioned like 2.1% increase in the salary how it can be above 1 lakhs , it should be 52000+2.1%+52000 which seems to be 53092 so, it's my feels as per the question they have
this is very help for excel study .thanks
I M VERY IMPRESSED SIR, THIS KNOWLEDGE IS VERY UISEFULL SIR
THANK YOU SO MUCH SIR