Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

Any easy guide to learn excel functions & formulas

user-image
Question added by Deleted user
Date Posted: 2013/06/05
Nasir Munir
by Nasir Munir , typist , Data Entry

Being primarily designed as a spreadsheet program, Microsoft Excel is extremely powerful and versatile when it comes to calculating numbers or solving math and engineering problems. It enables you to total or average a column of numbers in the blink of an eye. Apart from that, you can compute a compound interest and weighted average, get the optimal budget for your advertising campaign, minimize the shipment costs or make the optimal work schedule for your employees. All this is done by entering formulas in cells.

Ahmad Hani Joher Da'na
by Ahmad Hani Joher Da'na , المالية , الغرفة التجارية الصناعية للمحافظة الخليل

he more you use, the more you get expert.
Simply, try to perform multiple and complex assignments involving different formulae and functio

Mike Emerson Pasaron
by Mike Emerson Pasaron , Safety Officer , Arabian Petrochemical Co. (PETROKEMYA)

Start with the basics, usually basic formulas involving operands, =1+1, =1*1, or =A1*B2.
Next proceed with simple formulas involving ranges: summation: =SUM(A1:A8), Average: =AVERAGE(A1:A8), Minimum =MIN(), Maximum =MAX(), etc.
Then try learning simple IF statements =IF(condition,if value if true, if value if false) or if you prefer to proceed to lookups, start with =VLOOKUP() Study at your own pace, and don't proceed with the next topic unless you completely understand the fundamentals or the logic of the formula.
Learning formulas are like learning languages, start with the basics, and see how you can translate and tell Excel what you want to do

Abdal Hussain
by Abdal Hussain , Accounts Officer , PAKLITE ELECTRICAL INDUSTRIES (PVT.) LTD.

Simple Use it maximum In your work and any farmula which you required from any futher help so contact without any hasitation Thanks A Love

Muhammad Faheem
by Muhammad Faheem , Consultant- Accounts, Audit & Taxation , Basim Associates

The more you use, the more you get expert.
Simply, try to perform multiple and complex assignments involving different formulae and functions.

Mohamed Abd elkhalek Aly
by Mohamed Abd elkhalek Aly , Document Controll Coordinator & Operation Manager Assistant , Egysacom

try to download the excel bible and learn the simple functions at first and step by step while ur excel usage u will learn more and create more formulas

More Questions Like This