يبدأ التسجيل:
26 April 2026
معلومات عامة
المدرب / المدربون
عدد الساعات التدريبية
16
فترة الإنعقاد
2026-05-10 - 2026-05-13
أيام النشاط التدريبي
Sunday
التوقيت
16:00 - 20:00
لغة النشاط التدريبي
إنجليزي
المنهجية
وجاهي
نوع التدريب
دورات قصيرة
آخر موعد للتسجيل
Sunday, 10 May 2026, 5:00 PM
السعر للأردني
128JOD
السعر لغير الأردني
240US$
الوصف العام
This course aims to introduce the advanced level of data analysis and dashboards, set of detailed procedures to be followed in the treatment of data analysis using excel functions to prepare reports and the suitable spread sheets in the right way.
المخرجات
To provide participants with an in-depth knowledge with different types of excel functions and applications that are needed to prepare spreadsheets.
Course Video
المحتويات
1. Concepts and data analysis and dashboards
2. Tips and tricks
3. XLOOK & LOOKUP, VLOOKUP, HLOOKUP, for business/Finance/Accounting
4. Manage rules
5. Data validation
6. Get & transform data
7. Queries and connection
8. Data types
9. Scenario analysis
10. Sensitivity analysis
11.Goal seeking & back solving
12. Preparation of reports
13. Laying out the pivot table
14. Modifying the pivot table
15. Pivot table examples
16. Grouping pivot table items
17.Creating a calculated field or calculated item
18. Referencing cells within a pivot table – GETPIVOTDATA
19. Producing a report with a pivot table
20. Pivot charts power
21. Power Query
الفئة المستهدفة
This program is a designed for all administrative, Accountants, financials, Engineers and Executive secretariat