You Can Register on
26 April 2026
Course Info
Trainer/s
Training activity Hours
16
Training activity Date
2026-05-10 - 2026-05-13
Training Activity Days
Sunday
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
128JOD
Price For Non Jordanian
240US$
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