Most Useful Excel Functions

simplest and most used functions in Excel and which is used many times.

Basic Excel Introduction

Microsoft Excel is use for creating different types of reports related  to business, education, and private data. We can create the reports in a tabular manner and also we can present our report through graphics and charts.

 

The graphics and charts help us to understand our report in an easy way.

 

There are different types of formulas and functions also available in Excel, which help us to work quickly and solve the fundamentals using inbuilt functions.

 

The following common functions of Excel are the most-used:

• Financial functions
• Logical Functions
• Text Functions
• Date & Time functions
• Lookup Functions
• Math Functions

These help us to create various types of reports according to the requirement.

 

 

Presenting a report to show how to use formulas or functions,

 

“Mark-sheet”

List of functions which are used in Mark-sheet,

 

SUM

 

Used to get total subject marks.

 

MIN

 

Used to get minimum mark from all subjects.

 

MAX

 

Used to get maximum mark from all subjects.

 

AVERAGE

 

Used to get average from all subject marks, or it’s equal to percentage also.

 

IF

 

Used to check some conditions in the sheet.

 

 

Formulas of Mark-Sheet (Note:- Press enter after completion of formula)

 

For Total:- =sum(all subject selection)

For Min:- =min(all subject selection)

For Max:- =max(all subject selection)

For Average:- =average(all subject selection)

For Percentage:- =select total of subject marks*100/400(depend on subjects , in above mark-sheet there are 4 subject and the each subject exam mark is 100 so the total is 400.)

Result:- =if(select min mark>=35,”pass”,”fail”)

Grade =if(select average >75,”A”, if(select average >65,”B”, if(select average >55,”C”, if(select average >45,”D”))))

 

The bellw picture show the formulas which are used in mark-sheet

 

 

I have attached zip file of this example excel sheet with all functions and formulas so you can easily download and use it.

Summary

 

In this blog we learned Most Useful Excel Functions and Formulas

 

I hope that you found this tutorial easy to follow and understand.