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.
Thank you very much.
I am satisfied.Teaching system is clear and very easy to understand.
I am happy this caurse
I am very happy, Free cuorse big opportunity.
Yes i am so glad to tell it is the best ever platform where i learn many of the features in ms excel and also sir who given a practical knowledge and the way sir explaining is good one thank you learn vern.
The course is very informative but questions asked in quiz section is totally different from what is taught in the video lectures. Please teach those things also which are asked in quiz.
VRUSHALI AJAYRAO GURAD
Diwakar Singh Chauhan
nice teaching language and easy to understand.
I have completed my excel course and my other 3 courses are in process. This is greate plate form to learn any course the teachers are well trained and qualified. Thank you and love you all from PAK.