Outcomes
To provide participants with an in-depth knowledge with different types of excel functions and applications that are needed to prepare spread sheets.
Target Group
This programme is designed for all administrative, Accountants, financials and secretarial employees
Contents
- • 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
Type of Traning
Short Course
Training Activity Rate
Training activity Hours
16
Training activity Date
22/03/2026 - 25/03/2026
Training Activity Days
Sun- Mon- Tue- Wed
Start and End Time
16:00 - 20:00
Training Activity Classification
Fintech and Innovation
Methodology
In class
City
Amman
Deadline for registration
22/03/2026
Price For Jordanian
128 JOD
Price For Non Jordanian
240 US$
* Will be given discounts for groups