ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

Any easy guide to learn excel functions & formulas

user-image
تم إضافة السؤال من قبل مستخدم محذوف‎
تاريخ النشر: 2013/06/05
Nasir Munir
من قبل 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
من قبل 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
من قبل 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
من قبل 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
من قبل 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
من قبل 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

المزيد من الأسئلة المماثلة