Outcomes
تزويد المشاركين بالمعارف والمهارات المتوسطة والمتقدمة اللازمـة لاستخدام MS Excel بما فيها طرق اعداد وبناء المعادلات والمقارنات والجداول المحوريةPivot Table واستخراج البيانات الازمة لاتخاذ القرارات.
Target Group
الموظفون والمدراء بأقسام البنك المختلفة ودوائر الائتمان والماليةوالمهتمون بتطوير مهاراتهم في اكسل.
Contents
1. Introduction to Excel Advance.
2. Naming Cells and Range.
• Setting up Range Names
• Scoping a Range Name
• Using the Range Name Manager
• Using Names in Formulas
• Rules for naming cells and ranges.
• Creating named ranges automatically based on cell values.
• Deleting named cells/ranges.
3. Paste Special
4. Advanced Paste Special
5. Working with Tables:
• Use Tables.
• Create a Table from Existing Data.
• Change the Table Name.
• Change the Table Style.
• Change Table Style Options.
• Create a Total Row.
• Insert/Delete Table Rows/Columns.
• Select Parts of a Table, Move a Table.
6. Outlining and subtotals
• Creating subtotals.
• Outlining.
7. Data Validation
• Using the Data Validation feature.
• Finding Invalid Data.
8. Filtering
• Filtering Data.
• Using AutoFilter and Removing AutoFilter.
• Using AutoFilter with Top 10.
• Creating a Custom AutoFilter.
• Filtering with a Single Comparison Criterion.
• Filtering with Two Comparison Criteria.
9. FORMATTING & DISPLAY TECHNIQUES
• Creating custom number formats.
• Freezing the top row.
• Freezing the first column.
• Freezing the top row and the first column at the same time.
• Using Split.
• Hiding and un-hiding rows.
• Hiding and un-hiding columns.
• Hiding and un-hiding worksheets.
• Remove Duplicates.
• Text to Columns.
10. Date & Time Function.
11. Logical Function.
• IF.
• SUMIF.
• SUMIFS.
• IF NUMBER
• IFERROR.
• AND / OR.
• COUNT.
• COUNTIF.
• COUNTIFS.
12. Sorting
13. Lookup& Reference Function.
• VLOOKUP.
• Match.
• Index.
• XLOOPUP
14. Cell References
15. Trace Precedents / Dependents.
16. Evaluate Formula.
17. Protecting Worksheet / Worksheet Content / Cells.
18. Consolidate data.
19. Conditional Formatting
20. Left /Right/ Mid Functions.
21. Go to / Special.
22. Evaluation Formula.
23. PivotTable.
Type of Traning
Short Course
Training Activity Rate
Training activity Hours
15
Training activity Date
12/07/2026 - 16/07/2026
Training Activity Days
Sun- Mon- Tue- Wed- Thu
Start and End Time
17:00 - 20:00
Break Time
18:20 - 18:40
Training Activity Classification
Basic Skills
Language
Arabic
Methodology
In class
City
Amman
Deadline for registration
12/02/2026
Price For Jordanian
120 JOD
Price For Non Jordanian
225 US$
* Will be given discounts for groups