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

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

Excel to Excel (MS Excel Skills & Techniques)


المحاضر تاريخ البداية تاريخ النهاية توقيت البداية توقيت النهاية مكان الانعقاد عدد الساعات سجّل الآن
محمود عاطف القاسم
2018-02-25 2018-02-28 16:30 20:00 عمان 14

(Objectives / الأهداف)

:

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

- Discover the application's capabilities while working through exercises to create simple worksheets.

- Use (FX) Functions efficiently in work.

- Automate common tasks.

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


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

:

- Pasting using paste special.

- Inserting rows, columns and cells.

- Using the undo and redo feature.

- Using the format painter to copy a cells format.

- Using formatting.

- The basics of excel formulas.

- Using some of excel's most common functions.

- Excel cell comments.

- Excel find & replace.

- Sorting data in excel.

- Use auto filter.

- Pivot table.

- Data validation.

- Text to columns.

- Intermediate excel formulas.

- Excel autosum function/formula.



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

:

- Finance & accounting teams, and HR officers and admins whom have at least basics of MS. Excel.