EXCEL Functions

Hi All,

In any organization, to maintain a regular growth, we needs different Reports on Daily, Weekly , Monthly or Yearly basis, to check / compare / judge, the organization workings & to prepare / maintain those reports, Microsoft Office - Specially Excel is the best tool, 

like In Telecom Domain, for KPI Improvement, Reports, we need lot of Excel.

So today, let’s discuss something about different Excel Functions, which enhance our ability to view, analyze & maintain the high performance of an organization.

Excel :- In Excel Everything is defined in ROW and COLUMN, & combination of both is termed as CELL.

In below image, (A,B,C,D,E) are Columns & (1,2,3,4,5,6) are Rows, 

& B(Column) 2(Row) i.e. B2 (in which selected is written) are termed as CELL. 

There are many different functions, which helps to work with Excel really very easy & normally function in Excel starts with “=” (equalto) Sign,

So lets start with some functions,

Excel Functions :-

Mathematics -

• SUM :-  Its used to ADD its arguments (values).
• AVERAGE :-  Its used to AVERAGE its arguments (values).
• MIN (Minimum Value) :-  Its used to get MINIMUM Value from given Values.
• MAX (Maximum Value) :-  Its used to get MAXIMUM Value from given Values.
• COUNT :-  Its used to get Total Count of given Values.
• PRODUCT :-  Returns Product of given Values.
• POWER :-  Returns POWER of given Value.

Database -

• LEFT: - Returns the leftmost characters from a Text Value.
• RIGHT: - Returns the Rightmost characters from a Text Value.
• MID: - Returns the specific number of characters from a text string.
• CONCATENATE: - Joins several text items into one text item.
• LOWER: - Converts text to lower-case.
• UPPER: - Converts text to upper-case.
• PROPER: - Capitalizes the first letter in each word of a text value

Date -

• TODAY: - Returns the Current Day Date, “=TODAY()” (formula without Inverted Commas).
• NOW: - Returns the Current Date & Time, “=NOW()”.

Vlookup :- This function helps to find out the specific item in the given database.

“=VLOOKUP(ItemToFind,RangeToLookIn,ColumnToPickFrom,SortedOrUnsorted)”

1. ItemToFind – finds the single item, as required, like A11 or A12 or A13 (below Image)
2. RangeToLookIn – it’s the range of data i.e Database, in which data needs to be found, like in below image - Database is from (A1 to D8).
3. ColumnToPickFrom – how far is the column from the LEFT MOST Column.
4. SortedOrUnsorted – Whether Columns headings are sorted, TRUE(1) for YES, FLASE(0) for NO.

Note in Vlookup – Item to be found from the given database, that item column should be LEFT MOST Column in Database.

As in below image, the database is from (A1 to D8), & we need to find the Person Values, which is in A11, A12 & A13, hence in database, the Person Column is the Left Most Column i.e. Column number 1. 

Hlookup :- Its same as Vlookup, but in this ROW-wise data selection is there & that row should be TOP MOST in entire database.

These above are the few Functions in Excel, there are lot more like Charts, Pivot Tables, etc. which makes working with Excel a real FUN...

Comments are most Welcomed.

ChEEEEERrrrrRssSS...
Telecom Tigers Team
telecomtigers@gmail.com
http://homepageforu.webs.com/