Microsoft Excel Training: Lookup, Statistical and Math Functions (Part 4)
Explore “Lookup, Statistical and Math Functions” in this Microsoft Excel Training lesson. Part 4 of the five-part series brings together the source material and lesson topics. Use the contents links to find a section, read the notes, and consult the complete original teaching slides below.
Lesson topics
- Formula:-
- Statistical functions
- Math functions
- Lecture Three
- Power functions
Contents
REQUEST THE COMPLETE DOCUMENT ON WHATSAPP
Read the original source document
Microsoft Excel Training: original teaching slides for this study series.
Formula:-
=if(logical_text,value_if_true,value_if_false). It is used to get a result in a cell according to the given condition.
Formula:-
=sum(value1,value2,………….). It is used to make the sum or additions of the numbers of any two or more cells.
Lookup and reference functions
Lookup and reference functions
Formula:-
=vlookup(lookup_value,table_array,col_ index_num…..). it is used to make a link between two different sheets or two different workbook.
Statistical functions
Statistical functions
Formula:-
=count(value1,value2,…………). It is used to count the cells out of the cells in which a number is written.
Formula:-
=counta(value1,value2,………………). It is used to count the unblanked cells or the cells in which some contents is written out of the selected cells.
Formula:-
=countblank(Range). It is used to count the blank cells out of the selected cells. If we press only spacebar in any cell, then this cell be counted as unblanked cell. COUNTBLANK
Math functions
Math functions
REQUEST THE COMPLETE DOCUMENT ON WHATSAPP
Lecture Three
Lecture Three
Power functions
Power functions
Formula:-
=countif(Range,Criteria) it is used to count the number of cells according to a given condition in the selected cells. If we give condition that =countif(A1:A9,”>=10”) Then , it count the cells which have its >=10.
Formula:-
=sumif(Range,Criteria,sum_range) It is used to make the sum of numbers according to the given condition.
Review questions and answers
What are the key points about Formula:-?
=if(logical_text,value_if_true,value_if_false). It is used to get a result in a cell according to the given condition.
More lessons from this document
- Microsoft Excel Training — Part 1
- Microsoft Excel Training — Part 2
- Microsoft Excel Training — Part 3
- Microsoft Excel Training — Part 4
- Microsoft Excel Training — Part 5
Conclusion
The important points in Important Concepts should be reviewed alongside the definitions, examples and comparisons given above. Continue with the other four articles to cover the rest of the source material.