Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What excel function you usually use in your day-to-day activities?

user-image
Question added by Mike Emerson Pasaron , Safety Officer , Arabian Petrochemical Co. (PETROKEMYA)
Date Posted: 2013/06/09
Lubna Al-Sharif
by Lubna Al-Sharif , Medical Laboratory Technician , Nablus Specailized Hospital

I agree with all mentioned formulas above, especially vlookup.
According to my daily data search and auto-self training on excel works, I used the following formulas for their corresponding uses:
1- SHIFT+F3 to insert any required function
2- SHIFT+F10 to use shortcut menu functions
3- column or raw selection by CTRL or SHIFT + space-bar, respectively.
4- SHIFT+F2 to add comments.
5- CTRL+F11 to open new worksheet
6- AVERAGE, SUM.
COUNT, COUNTIF, MIN and MAX for calculations.
6- DSTDEVB for standard deviation in statistical estimations..

Mahmoud Mohamed Nagib
by Mahmoud Mohamed Nagib , Planning Engineer , Egyptian Maintenance Company (EMC)

vlookup

Mohammed Mhanna
by Mohammed Mhanna , Cnc Programmer Furniture Designer , Safeen Company

SUM , COUNTIF , AVERAGE , INDEX , VLOOKUP

Ryasat Ali
by Ryasat Ali , Oracle Consultant , Atlas Honda Limited (Asghar & Sons)

Commonly the Sum() is used in excel.

Muhammad Asif Jajja
by Muhammad Asif Jajja , Accountant , Pakistan Veterinary Medical Council

M-S Excel is most useful Application for an accountant, I usually use almost all the functions in my day to day activities

Gavin Sequeira
by Gavin Sequeira , Executive Assistant to Chairman / Data Analyst , Binatone Lifestyle Pvt. Ltd.

Countif, Vlookup, Index Match, Sumproduct, Date functions..

manaf almas
by manaf almas , Auditor , DAR AL NUZUM PUBLIC ACCOUNTANTS

vlookup,pivot table.filter,sort and calculation functions

sugi imam muslim
by sugi imam muslim , Cashier , SIG

SUM , COUNTIF , AVERAGE , INDEX , VLOOKUP

عدنان سميح محمد شحادة
by عدنان سميح محمد شحادة , رئيس قلم(مدير) , مجلس القضاء الاعلى

count if

mohammad israphil
by mohammad israphil , Control Instrument Technician , IMECO

I am using Exel function for Making calibration report for plant instrument

Elshazali All Babiker Ajab
by Elshazali All Babiker Ajab , Senior Human Resources Assistant , United Nations World Food Programme

VLook Up

More Questions Like This