Contact Us
معلومات عامة
المدرب / المدربون
عدد الساعات التدريبية
16
فترة الإنعقاد
2026-01-11 - 2026-01-14
أيام النشاط التدريبي
Sunday
التوقيت
16:00 - 20:00
لغة النشاط التدريبي
إنجليزي
المنهجية
وجاهي
نوع التدريب
دورات قصيرة
آخر موعد للتسجيل
Thursday, 8 January 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 spread sheets.
Course Video
المحتويات
- Concepts and data analysis and dashboards
- Tips and tricks
- XLOOK & LOOKUP, VLOOKUP, HLOOKUP, for business/Finance/Accounting.
- Manage rules.
- Data validation.
- Get & transform data
- Queries and connection
- Data types
- Scenario analysis
- Sensitivity analysis
- Goal seeking & back solving
- Preparation of reports
- Laying out the pivot table
- Modifying the pivot table
- Pivot table examples
- Grouping pivot table items
- Creating a calculated field or calculated item
- Referencing cells within a pivot table – GETPIVOTDATA
- Producing a report with a pivot table
- Pivot charts power
- Power Query
- Power Pivot
الفئة المستهدفة
This program is a designed for all administrative, Accountants, financials, Engineers and Executive secretariat