It is simply basic upon relief about the function and features of the excel. But then again, how many function does this program makes to make out the advantage in using this in almost everything this program designed for  Reports, accounting, calculating, making grades and much much more...
In this article, here is the table  list of features that make your excel experience even better...
Function

Description

DATE

Returns the serial number of a
particular date.

DAY

Converts a serial number to a day of
the month.

DAYS360

Calculates the number of days between two dates, based on a 360day
year.

HOUR

Converts a serial number to an hour.

MINUTE

Converts a serial number to a minute.

MONTH

Converts a serial number to a month.

NETWORKDAYS

Returns the number of whole workdays
between two dates.

NOW

Returns the serial number of the
current date and time.

SECOND

Converts a serial number to a second.

TIME

Returns the serial number of a
particular time.

TODAY

Returns the serial number of today’s
date.

WEEKDAY

Converts a serial number to a day of
the week.

WEEKNUM

Returns the week number in the year.

WORKDAY

Returns the serial number of the date before or after a
specifiednumber of workdays.

YEAR

Converts a serial number to a year.

YEARFRAC

Returns the year fraction representing the number of whole
daysbetween start_date and end_date.

II.
Functions
Used in Lookup Formulas
Function

Description

CHOOSE

Returns a specific value from a list
of values supplied as arguments.

HLOOKUP

Horizontal lookup. Searches for a value in the top row of a table and
returns avalue in the same column from a row you specify in the table.

IF

Returns one value if a condition you specify is TRUE, and returns
another value if the condition is FALSE.

IFERROR

If the first argument returns an error, the second argument is
evaluated andreturned. If the first argument does not return an error, then
it is evaluated andreturned.

INDEX

Returns a value (or the reference to a
value) from within a table or range.

LOOKUP

Returns a value either from a onerow or onecolumn range. Another
form of theLOOKUP function works like VLOOKUP but is restricted to returning
a value fromthe last column of a range.

MATCH

Returns the relative position of an
item in a range that matches a specified value.

OFFSET

Returns a reference to a range that is a specified number of rows and
columnsfrom a cell or range of cells.

VLOOKUP

Vertical lookup. Searches for a value in the first column of a table
and returns avalue in the same row from a column you specify in the table.

III.
Counting
and Summing Functions
Function

Description

COUNT

Returns the number of cells that
contain a numeric value.

COUNTA

Returns the number of nonblank cells. This function counts cells that
contain values, text, or logical values (TRUE orFALSE).

COUNTBLANK

Returns the number of blank cells.

COUNTIF

Returns the number of cells that meet
a specified criterion.

COUNTIFS

Returns the number of cells that meet
multiple criteria.

DCOUNT

Counts the number of records that meet specified criteria; used with
aworksheet database.

DCOUNTA

Counts the number of nonblank records that meet specified criteria;
usedwith a worksheet database.

DSUM

Returns the sum of a column of values that meet specified criteria;
usedwith a worksheet database.

FREQUENCY

Calculates how often values occur within a range of values and
returns avertical array of numbers. Used only in a multicell array formula.

SUBTOTAL

When used with a first argument of 2, 3, 102, or 103, returns a count
ofcells that comprise a subtotal; when used with a first argument of 9 or
109,returns the sum of cells that comprise a subtotal.

SUM

Returns the sum of its arguments.

SUMIF

Returns the sum of cells that meet a
specified criterion.

SUMIFS

Returns the sum of cells that meet
multiple criteria.

SUMPRODUCT

Multiplies corresponding cells in two or more ranges and returns the
sum of those products.

IV.
Logical
Category Functions
Function

Description

AND

Returns TRUE if all its arguments are
TRUE.

FALSE

Returns the logical value FALSE.

IF

Specifies a logical test to perform.

IFERROR

Returns a different result if the first argument evaluates to an
error.

NOT

Reverses the logic of its argument.

OR

Returns TRUE if any argument is TRUE.

TRUE

Returns the logical value TRUE.

V.
Text
Category Functions
Function

Description

CHAR

Returns the character specified by the code number.

CLEAN

Removes all nonprintable characters from text.

CONCATENATE

Joins several text items into one text item.

DOLLAR

Converts a number to text, using currency format. It takes two
arguments: the number to convert and the number of decimal places to display.
The DOLLAR function uses the regional currency symbol

EXACT

Checks to see whether two text values are identical.

FIND

Finds one text value within another (casesensitive).

FIXED

Formats a number as text with a fixed number of decimals.

LEFT

Returns the leftmost characters from a text value.

LEN

Returns the number of characters in a text string.

LOWER

Converts text to lowercase.

MID

Returns a specific number of characters from a text string, starting
at the position you specify.

PROPER

Capitalizes the first letter in each word of a text value.

REPLACE

Replaces characters within text. Use this function when you know the
position of the text to be replaced but not the actual text.

REPT

Repeats text a given number of times.

RIGHT

Returns the rightmost characters from a text value.

SEARCH

Finds one text value within another (not case sensitive).

SUBSTITUTE

Substitutes new text for old text in a text string. Use this function
when you know the character(s) to be replaced but not the position.

T

Returns the text referred to by value.

TEXT

Formats a number and converts it to text.

TRIM

Removes excess spaces from text.

UPPER

Converts text to uppercase.

VALUE

Converts a text argument to a number.

This table shows you different features that the excel has. It usually applies in the formula tab in the program.Watch instead the video below for more details involving excel formulas and functions...
________________________________________________
Updates:
There is another article involving excel programs here. Link will be provided here...
0 comments:
Post a Comment