Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

Which is the most used Function of MS EXCEL i.e Vlookup, Hlookup etc for organization ?

user-image
Question added by Sushanta Khanal , Cash Supervisor/ Asst. Accountant , Majid Al Futtaim
Date Posted: 2013/12/13
Zafar Iqbal
by Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor

Vlookup

Mamdouh AlSharif
by Mamdouh AlSharif , Freelance Data Manager, Manipulator and Analyst , Freelance

data sorting and filtering ;)

Shahnawaz Alam Shahnawaz
by Shahnawaz Alam Shahnawaz , Database Specialist , Intigral

Depend upon nature of your work in your organization. There are approx200 functions as per my experince pelase see below functions which are mostly use.

 

Sum

sumif

sumifs

count

counta

countif

countifs

average

averagea

averageif

averageifa

vlookup

hlookup

if

index

match

iferror

text

and

or

len

left

right

uper

lower

proper

substitute

 

 

Rajesh K
by Rajesh K , ISP Manager , CENPAC NET INC

1.Sorting2. filtering3. Vlookup4.PIVOT

Ahmed Ajjour
by Ahmed Ajjour , Civil Engineering Consultant , unicef

Sum average and filter

Hazem AbdelAziz
by Hazem AbdelAziz , IT Support Manager , Cerner

Sum - Vlookup

OUGGAD mohamed
by OUGGAD mohamed , Budget Planning & Reporting Manager , Groupement Sonatrach-Eni

I think Vlookup

 

Atif Tanveer
by Atif Tanveer , Decision Support Specialist , Hamilton Health Science

@sum()

FITAH MOHAMED
by FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials

Vlook up & Sumif 

Muhammad Jahanzaib Khan
by Muhammad Jahanzaib Khan , Accountant , Mairaj Uddin Traders

people mostly use Vlookup

More Questions Like This