Using IF function

This picture shows how easy we can identify if a certain data passes a condition in MS Excel. In this picture, it shows that if the data in cell U7 is greater than 60, it is PASSED, otherwise it's FAILED. This is how we can make some complicated things simple. Instead of scanning and sorting it manually, you will just let the application do it for you. Amazing, huh?

Parts of MS Excel

Source: physics.uc.edu

This picture shows the different parts of MS Excel. You can see the office button, Quick access toolbar, Title bar, Formula bar, Close Button, Ribbon, Name box, Rows and Columns, Status bar, Worksheet tabs, View buttons, Zoom slider, Scroll bars, and the Active Cell.      

Functions in MS Excel

Mathematical Functions

SUM - Adds up all the values in a range

SUMIF - Adds all the values in a range that meet specific criteria

SUMIFS (2007 and 2010 only) - Adds values in a range based on multiple criteria

SUMPRODUCT - Sum a range of cells that meet multiple criteria

ROUND - Round a number to a specified number of digits

ROUNDUP - Round a number up to a specified number of digits

ROUNDDOWN - Round a number down to a specified number of digits

CEILING - Round a number up to a multiple of significance

FLOOR - Round a number down to a multiple of significance

Statistical Functions

COUNT - Counts all the values in a range

AVERAGE - Calculates the average number from a range of values

MAX - Finds the maximum value in a range

MIN - Finds the minimum value in a range

COUNTA - Counts all non-empty cells in a range

COUNTBLANK - Counts all blank cells in a range

COUNTIF - Counts all the cells in a range that meet specific critera

COUNTIFS (2007 and 2010 only) - Counts all the cells in a range that meet multiple criteria

AVERAGEIF (2007 and 2010 only) - Calculates the average of a range of values that meet specific criteria

AVERAGEIFS (2007 and 2010 only) - Calculates the average of a range of values that meet multiple criteria

LARGE - Return a value dependent upon its ranking in a range of values in descending order

SMALL - Return a value dependent upon its ranking in a range of values in ascending order

RANK - Returns the rank or position of a number within a range of numbers

These are just some of the functions in MS Excel. And by some, I mean some. Instead of using symbols over and over again, you just have to type the equal sign (=), type the desired function, and enclose the range of cells. 

Examples:

=SUM(A1:C1)

=AVERAGE(D2:E2)

MS Excel 2013

Photo source: http://en.wikipedia.org/wiki/File:Microsoft_Excel_2013_Default_Screen.png

 

 

 

 

 

 

 

 

 

 

 

 

 

This is what the default screen of MS Excel 2013 looks like when running in Windows 8.

MS Excel is one of the basic MS Office applications. It is very useful in banks, schools, and other companies or government offices. The use it to record the sales, accounts, and grades. It is a great help to them. they just have to know how to operate it. Instead of doing it manually, you just have to type it. Less effort, more accurate.