Scribd
Upload
15 views5 pages

Mastering Basic Excel Formulas

Uploaded by

dhruvmanchanda2010
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
15 views5 pages

Mastering Basic Excel Formulas

Uploaded by

dhruvmanchanda2010
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd

Mastering Basic

Excel Formulas
by Dhruv Manchanda
Introduction to Excel Formulas

What are Excel Formulas?


• Excel formulas are tools for performing calculations.
• They can perform basic operations like addition, subtraction,
multiplication, and division.
• Formulas in Excel always begin with the equal sign.
Understanding Basic Excel
Formulas
• The SUM Formula
• The SUM formula is used to add up values.
• It simplifies the process of adding large amounts of data.
• The AVERAGE Formula
• The AVERAGE formula calculates the average of a range of values.
• It is useful in finding the mean value of data.
• The COUNTA Formula
• The COUNTA formula counts the number of cells that are not empty.
• It helps in determining the size of data, including non-numeric data.
More Basic Excel Formulas

• The IF Formula
• The IF formula performs a logical test and returns one value for a TRUE
result, and another for a FALSE result.
• It is useful in decision making within data analysis.
• The TRIM Formula
• The TRIM formula removes extra spaces from text.
• It is useful in cleaning up data.
• The MAX & MIN Formulas
• The MAX formula finds the highest value in a range of cells.
• The MIN formula finds the lowest value in a range of cells.
THANK YOU

You might also like