Outcomes
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.
Contents
- 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.
