معهد الدراسات المصرفية

المملكة الأردنية الهاشمية

(Advanced Excel)


المحاضر تاريخ البداية تاريخ النهاية توقيت البداية توقيت النهاية مكان الانعقاد عدد الساعات سجّل الآن
محمود عاطف القاسم
2018-11-11 2018-11-15 17:00 20:00 عمان 12

(Objectives / الأهداف)

:

- This Excel training course helps participants to discover the application's capabilities while working through exercises to create simple worksheets.

- Learn how to use (FX) Functions efficiently in work.

- Learn how you can automate common tasks.

- Learn new skills & techniques and how to solve your problem in multi different ways.


(Contents / المحتويات)

:

- SUMIF.

- SUMIFS.

- VLOOKUP.

- HLOOKUP.

- MATCH.

- VLOOKUP Using (Match Function) .

- IF.

- AND.

- IF (AND).

- COUNT.

- COUNTA.

- COUNTBLANK.

- COUNTIF.

- COUNTIFS.

- CONCATENATE.

- RIGHT.

- LEFT.

- MID.

- LEN.

- MIN.

- MAX.

- ROUND.

- ROUNDDOWN.

- ROUNDUP.

- TRIM.

  - TRUNC.

- MONTH.

- YEAR.

- NOW.

- TODAY.

- UPPER.

- LOWER.

- PROPER.

- Pivot Table.

- Conditional Formatting.

- Text to Columns.

- SORT (If Needed).

- FILTER (If Needed).



(Participants / المشاركون)

:

- Finance & accounting team.

- HR officers.

- ATM department employees.

- In general intermediate skilled employees in Ms. Excel.