Ms. Excel formula lesson 1

Excel_Course_by_Pushpraj_kr


In this lesson, we will learn about 5 different formulas and how to use a formula in ms excel,


Sum:- is used to calculate the total value as plus

Max:-  used to find maximum value from criteria

Min:-used to find maximum value from criteria

Average:- used to find average  value-form criteria

 

How to use the formula in Excel 

In excel before putting formula we need to put some special character like

=

+

_

Example:- press = then search your formula and Press tab then select criteria then Close Bracket  and Press Enter




 

you can use every given Formula from this lesson like max, min, average etc.