Palce

Start Date

End Date

Number of Days

Program Name

Data Analysis Basics Using Excel

The concept of data analysis and its importance in business.

An overview of Microsoft Excel and its basic tools.

Managing data in Excel using smart tables.

Application examples of data analysis in practical life.

Organizing and cleaning data

Handle unordered data and correct errors.

Use advanced find and replace functions.

Clean data with Power Query.

Remove duplicates and sort data effectively.

Basics of Functions and Formulas

Introduction to mathematical and logical functions in Excel.

Use VLOOKUP, HLOOKUP, and XLOOKUP to search within data.

Apply conditional functions such as IF, COUNTIF, and SUMIF.

Combine functions for precise analyses.

Using Pivot Tables

Create pivot tables to summarize data.

Analyze trends and patterns using Pivot Charts.

Filter and sort data within pivot tables.

Link pivot tables to multiple data sources.

Data visualization using charts

Choose the appropriate chart for each type of data.

Customize charts and improve their appearance.

Use interactive charts.

Analyze trends using Sparkline Charts.

Basic Statistical Data Analysis

Automate analysis using What-If Analysis.

Use Solver to analyze scenarios.

Apply Goal Seek to solve financial equations.

Understand the impact of changes to data using Data Tables.

Working with external data sources

Import data from Excel, CSV, and Google Sheets.

Connect Excel to SQL databases.

Clean up data after importing using Power Query.

Automatically refresh external data within Excel.

Improve Productivity with Macros (VBA Basics)

Introduction to programming in Excel using VBA.

Record macros to automate repetitive processes.

Edit and customize code.

Implement automated data analysis projects.

Preparing Interactive Analytical Reports

Design powerful analytical reports in Excel.

Customize interactive reports using Slicers.

Create dynamic dashboards to display data.

Export reports to PDF and presentations.

Certificate

Upon full attendance of this training course, participants will receive an accredited certificate issued by Al Manhal Institute, which is licensed by the Abu Dhabi Center for Technical and Vocational Education and Training. This certificate is regionally recognized, providing holders with a competitive advantage both within their organizations and when seeking new career opportunities.

Program Name	Category	Date	Number of Days	Location	Price	Action

Schedule

Goals

Contents

Certificate

Subscribe to Our Newsletter

Customization

Security

No spam

Schedule

Goals

Contents

Certificate

Introduction to Data Analysis Using Excel

Goals

Contents

Data Analysis Basics Using Excel

Organizing and cleaning data

Basics of Functions and Formulas

Using Pivot Tables

Data visualization using charts

Basic Statistical Data Analysis

Working with external data sources

Improve Productivity with Macros (VBA Basics)

Preparing Interactive Analytical Reports

Certificate

Certificate

Extra Options

Data Analysis Basics Using Excel

Organizing and cleaning data

Basics of Functions and Formulas

Using Pivot Tables

Data visualization using charts

Basic Statistical Data Analysis

Working with external data sources

Improve Productivity with Macros (VBA Basics)

Preparing Interactive Analytical Reports