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