المخرجات
To provide participants with an in-depth knowledge with different types of excel functions and applications that are needed to prepare spread sheets.
الفئة المستهدفة
This programme is designed for all administrative, Accountants, financials and secretarial employees
المحتويات
- • Concepts and data analysis and dashboards
• Tips and tricks
• Manage rules
• Data validation
• Combine values from multiple ranges into one new range
• Remove duplication
• Text to columns
• Analysis toolpack
• Statistical analysis: function
• Get & transform data
• Queries and connection
• Data types
• Sort & filter
• Forecast
• Using file manager, define name & create from selection in excel to prepare spread sheets
• Scenario analysis
• Goal seeking & back solving
• Functions: ABS, If, Sum if, Round, Round Up, Round Down, And, If and, Or , If or , Match, Index, Index Match, Sum product, Int , Mod , Average If, If Error, aggregate
• VLOOKUP, HLOOKUP, XLOOK & LOOKUP for Business/Finance/Accounting tasks
• Preparation of reports
• Conditional formatting formulas
• Using excel in prepare financial statements: Statement of financial position, Statement of comprehensive income and Statement of cash flows
• Financial statements and ratios
• Excel & visual basic application (VBA)
• Recording Macros
• Excel functions in calculating depreciations: SLN, DB, DDB, SYD
• Break–even point
• 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
• Pivot power
• Query
• Loan amortization scheduled
نوع التدريب
دورات قصيرة
التقييم
عدد الساعات
16
فترة الانعقاد
2026/03/22 - 2026/03/25
أيام النشاط التدريبي
أحد- اثنين- ثلاثاء- اربعاء
التوقيت
20:00 - 16:00
تصنيفات النشاط التدريبي
التكنولوجيا المالية والإبتكار
المنهجية
وجاهي
المدينة
عمان
اخر موعد للتسجيل
2026/03/22
السعر للأردني
128 دينار اردني
السعر لغير الأردني
240 دولار امريكي
* سيتم منح المؤسسات خصومات للمجموعات