Course Info
Trainer/s
Training activity Hours
16
Training activity Date
2026-05-10 - 2026-05-13
Training Activity Days
Sunday, Monday, Tuesday, Wednesday
Start and End Time
16:00 - 20:00
Training Activity Language
English
Methodology
In class
Type of Training
Short courses
Deadline for registration
Sunday, 10 May 2026, 5:00 PM
Price For Jordanian
128 JOD
Price For Non Jordanian
240 US$
Description
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.
Outcomes
To provide participants with an in-depth knowledge with different types of excel functions and applications that are needed to prepare spreadsheets.
Course Video
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
Target Group
This program is a designed for all administrative, Accountants, financials, Engineers and Executive secretariat