Skip to main content
Data Analysis Using Excel
Data Analysis Using Excel
Training Activity Rate
عصام خويلة
Training activity Hours
Training activity Date
Training Activity Days
Start and End Time
17:00 - 20:00
Training Activity Classification
Basic Skills
Course Language
In class
Type of Training
short courses
Deadline for registration
Price For Jordanian
96 JOD
Price For Non Jordanian
180 US$

By the end of this training course, trainees will be able to :

-     Differentiate between data and information .

-     Identify data collection methods data cleaning.

-     Define conditions that must be applied to the cells.

-     Analyze data using functions.

-     Analyze data using analysis tools in Excel.

-    Apply data visualization

Target Group

-     All people interested in analyzing data using Excel, in addition to corporate analysts, decision-makers, and employees in general.


-     Introducing the Course.

-     Meaning of data analysis.

-     Data collection methods.

-     Make a form to collect data.

-     Methods and secrets of data cleaning.

-     Advanced data filtering.

-     Excel options.

-     Naming Ranges.

-     Data validation with list.

-     Data validation with number, date, and length of text.

-     Data validation with Function.

-     Dependent list.

-     Analyze data using conditional formatting.

-     Conditional formatting with Function.

-     Subtotal & Sum Product  Function.

-     Conditional counting and conditional Sum functions .

-     Advanced VLOOKUP and X Lookup Function.

-     Index & Match Function.

-     Logical functions.

-     Statistical functions.

-     Representing data using graphs.

-     Dynamic Chart.

-     Excel options.

-     Preparing reports.

-     File publishing options.

-     Preparing the file.

-     Protect worksheets and files.

This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.