MS Excel consists of 450 formulas feature pre installed in it.
Now we will see that how we can check that any particular function exist or not. For that we can search any function by its name and if it is existing, and it will be shown in the list that appears.
There are different functions like rank, which is used to give rank for particular selected cells.
When we want to count the number of cells in a range that are not empty, we use Count function, we can use it by typing '=count(__)'.
Now if we want to calculate median, we can use the medium function and select the cells for which we want to perform this function.
We can also insert function in Excel, we can do that by going into FORMULA'S tab and clicking on the insert function icon.
In MS Excel there are different functions which we can perform according to our requirement.
The other common functions in MS Excel are the following:
SUM: Adds up the numbers in a list of cells.
AVERAGE: Averages values, for example, to calculate the average of a list of numbers.
MAX: Finds the largest value in a list of numbers.
MIN: Finds the smallest value in a list of numbers.
IF: This function is used to do calculations based on conditions you specify, such as "IF cell A1 has a value greater than 5".
RIGHT, LEFT, and MID Function.
Despite the fact that every Excel feature has a use case, no one uses every Excel feature. After sifting through the 500+ functions, there are only about 100 or so actually useful features and functions for the majority of current knowledge workers.
Budgeting, creating graphs and charts, and storing and categorising data are the three most popular general purposes for spreadsheet software. Spreadsheet software is used in the corporate world to anticipate future performance, calculate taxes, do basic payroll, create charts, and compute revenues.
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
I'm very lucky because I have this app. I learned a lot from this app and will keep learning.
Thank you so much LearnVern.
best app for learning
This is very useful app by all courses in this app and thanks for learnvern