تجاوز إلى المحتوى الرئيسي
MS Excel in Business intelligence
MS Excel in Business intelligence
التقييم
المدرب/ون
حسن منصور
عدد الساعات
14
فترة الانعقاد
-
أيام النشاط التدريبي
الاثنين
الثلاثاء
الاربعاء
الخميس
التوقيت
16:30 - 20:00
تصنيفات النشاط التدريبي
المهارات الأساسية
لغة النشاط التدريبي
انجليزي
المنهجية
وجاهي
المدينة
عمان
نوع التدريب
دورات قصيرة
اخر موعد للتسجيل
السعر للأردني
112 JOD
السعر لغير الأردني
280 US$
المخرجات

By the end of this training course, trainees will be able to :

- Apply different types of MS Excel functions and applications that are needed to prepare spread sheets.                 

الفئة المستهدفة

-        All administrative, accountants, financials and secretariat employees.

المحتويات

-     Concepts and the basics of the Excel applications:

-     Tips and tricks.

-     Absolute and relative references .

-     R1C1 reference style.

-     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 and LOOKUP for Business/Finance/Accounting tasks.

-     Preparation of reports.

-     Conditional formatting formulas using Excel .

-     Manage rules in excel .

-     Data validation in Excel.

-     Combine values from multiple ranges into one new range.

-     Remove duplication.

-     Text to columns.

-     Using file manager, define name and create from selection in excel to prepare spread sheets .

-     Scenario analysis.

-     Goal seeking and back solving.

-     Using excel to prepare financial statements: Statement of financial position, Statement of comprehensive income and Statement of cash flows. 

-     Financial statements and ratios .

-     Excel and visual basic application (VBA) .

-     Recording Macros.

-     Excel functions in calculating depreciations: SLN, DB, DDB, SYD.

-     Break–even point in Excel .

-     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.

-     Practical exercises.

This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.