Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

In your opinion, what are a few of the most useful functions in Excel? How do you use them?

In your opinion, what are a few of the most useful functions in Excel? How do you use them?

user-image
Question ajoutée par Shoaib ur Rehman , Cost Control Engineer , Infraroad Trading & Contracting
Date de publication: 2018/01/13
Firas Shahadi
par Firas Shahadi , Human Resources Director , SAUDI UNION

I think you should know functions in their categories.

like functions of text, date and time, database, search and lookup, range, math, ... etc.

for each category you should know the most used functions.

 

Thank you for the question

Cheers

Lielani Alzate
par Lielani Alzate , Secretary , New Mowasat Hospital

first you should know what are the useful function then you will know how to use it

Josette Rouphael
par Josette Rouphael , Intern , Khalil Fattal & Fils

sum , average , min , count

According to my opinion sum calculation is a great function of excel.

MUHAMMAD ASSAD KHAN
par MUHAMMAD ASSAD KHAN , Paid Internship , Hazara University , Mansehra

AVERAGE FUNCTION

PROJECT FUNCTIONS e.g NPV , PBP IRR ETC

SUM FUNCTION

SUBTRACT FORMULA

SPELLWORDS FUNCTION

IF FUNCTION

NESTED IF FUNCTION

VLOOKUP FUNTION

MULTIPLICATION FUNCTION

DIVISION FUNCTION

PERCENTAGE FUNCTION

DATE FUNCTION ETC

 

 

Alei Alyana Sauce
par Alei Alyana Sauce , Receptionist and secretary , Al Mirage Perfumes Factory LLC

Pivot is one. Makes sorting, creating reports and analyzing numerous data easy as pie.

Farhan Iftikhar
par Farhan Iftikhar , Sr. Proposals Engineer , Khaled Juffali Industrial Company

Vlookup ( to comparison of two columns in different worksheets or same worksheets)

Sumif (to sum the quantities using the condition for speicific column or row in a worksheet)

Conditional formatting (as the name indicates you want to check, used for comparison of two cells or columns or rows)

Concatenate ( to combine two or more cells)

Pivot Table ( to summarize larger worksheets in a summarized way to look into desired results)

Mahmoud sedeek taha ahmed elsharqwy
par Mahmoud sedeek taha ahmed elsharqwy , مدرس , المنصورة

The most useful functions in Exel are the function of graphs and mathematical equations

Sanjay Kadalimattathil Balakrishnan
par Sanjay Kadalimattathil Balakrishnan , Sr Estimator , Lamprell Energy ltd.

Vlookup, retrieves required value from a desired column which is related to the searched criteria which is avaliabel in another column. Eg. Column 1 has names, column 2 has ages of each names, If you need the age of a particular person in another cell it can be vlookuped.

Hlookup, same as above but this is to retrieve data of Rows instead of columns as above mentioned.

Defining cell name: By defining cell name we can easily retrieve the data in that particular cell if the name is unique. For eg if we put fuel value in one cell and changes the cell name a1 to Fuel when the value fo fuel is input. we go to another worksheet or any cells of the same file and put=Fuel, the cell will displays the value of the fuel.

Goal Seek: We can achieve a final target by changing one cell and with out disturbing a 100 cell. just in one go.

Text to columns: Downloaded dats from SAP, ERP or any other data bases some times have semicolumn or space etc to differentiate between each value and will be displayed in one cell of excel. This can be easily sorted based on the type of speperation used.

Utilisateur supprimé
par Utilisateur supprimé

perceptual map for positioning analysis, also the coefficient, range, forecasting, all data analysis method

Abdelhak Bensahraoui
par Abdelhak Bensahraoui , Tendering Engineer , Schneider Electric

It all depends on how and why you use Excel! But the essencial ones in my opinion are IFs, IFERROR, COUNT, COUNTIF(S), LOOKUPs, etc. Because these functions can ease any analysis you do on Excel.

More Questions Like This