Contact Us
Course Info
Trainer/s
Training activity Hours
16
Training activity Date
2026-01-11 - 2026-01-14
Training Activity Days
Sunday
Start and End Time
16:00 - 20:00
Training Activity Language
Bilingual
Methodology
In class
Type of Training
Short courses
Deadline for registration
Thursday, 8 January 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 spread sheets.
Course Video
Contents
- Concepts and data analysis and dashboards
- Tips and tricks
- XLOOK & LOOKUP, VLOOKUP, HLOOKUP, for business/Finance/Accounting.
- Manage rules.
- Data validation.
- Get & transform data
- Queries and connection
- Data types
- Scenario analysis
- Sensitivity analysis
- Goal seeking & back solving
- Preparation of reports
- 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
- Power Query
- Power Pivot
Target Group
This program is a designed for all administrative, Accountants, financials, Engineers and Executive secretariat