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

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

"Advanced Excel 2016"


المحاضر تاريخ البداية تاريخ النهاية توقيت البداية توقيت النهاية مكان الانعقاد عدد الساعات سجّل الآن
محمود عاطف القاسم
2019-06-23 2019-06-26 16:30 20:00 عمان 14

(Objectives / الأهداف)

:

By the end of this training course, participants will be able to :

- Discover the application's capabilities .

- Use (FX) Functions efficiently in work.

- Automate common tasks.

- Aplly 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.