Schedule

Palce	Start Date	End Date	Number of Days

Place

Start Date

End Date

Days

Place

Start Date

End Date

Days

Place

Start Date

End Date

Days

Schedule

Palce	Start Date	End Date	Number of Days

Place

Start Date

End Date

Days

Place

Start Date

End Date

Days

Place

Start Date

End Date

Days

Schedule

Palce	Start Date	End Date	Number of Days
Dubai	December 14, 2025	December 18, 2025	5

Palce	Start Date	End Date	Number of Days

Place

Start Date

End Date

Days

Place

Start Date

End Date

Days

Place

Start Date

End Date

Days

Goals

Understanding the concept of interactive dashboards and their importance in government institutions.

Learn how to clean and analyze data using Excel.

Create dynamic reports based on live data.

Design advanced charts and graphs that support decision making.

Using Pivot Tables and Power Query to analyze data effectively.

Automate data refresh to create continuously updated reports.

Share reports and dashboards in a professional way

Developing customized dashboards for various government sectors.

Introduction to Interactive Dashboards

The concept of interactive dashboards and their importance.

Using Excel Dashboards in analyzing government performance.

The difference between traditional reports and interactive reports.

Examples of dashboards used in the public sector.

Organizing and preparing data for analysis

Clean government data and prepare it for analysis.

Remove duplicate values and correct missing data.

Use Power Query to transform raw data.

Improve the efficiency of handling big data within Excel.

Using Pivot Tables

Choose the appropriate chart types for each report.

Customize charts and add illustrative elements.

Use Sparklines and Conditional Formatting.

Build dynamic charts that change based on inputs.

Data Analysis Using Power Query

Import data from Excel, CSV, and SQL.

Combine different data sources into a single report.

Clean data and perform advanced calculations.

Transform raw data into usable information.

Automating Reports Using Advanced Functions

Use conditional functions such as IF and VLOOKUP.

Apply dynamic functions such as XLOOKUP and FILTER.

Build analytical equations to create performance summaries.

Automate data refresh within dashboards.

Designing Interactive Dashboards

Planning and building the dashboard structure.

Adding interactive buttons and dynamic slides.

Improving the user experience within reports.

Designing government dashboards that support decision-making.

Trend Analysis Using Excel

Analyze performance across different time periods.

Predict the future using Trend Analysis.

Analyze time data using Moving Averages.

Set priorities based on available data.

Export and share reports in professional ways

Export reports to PDF, PowerPoint, and Excel.

Share dashboards via OneDrive and SharePoint.

Use Power BI with Excel for advanced analysis.

Prepare interactive reports to present to senior management.

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

Create Interactive Excel Dashboards

Schedule

Goals

Contents

Introduction to Interactive Dashboards

Organizing and preparing data for analysis

Using Pivot Tables

Data Analysis Using Power Query

Automating Reports Using Advanced Functions

Designing Interactive Dashboards

Trend Analysis Using Excel

Export and share reports in professional ways

Certificate

Certificate

Extra Options

Introduction to Interactive Dashboards

Organizing and preparing data for analysis

Using Pivot Tables

Data Analysis Using Power Query

Automating Reports Using Advanced Functions

Designing Interactive Dashboards

Trend Analysis Using Excel

Export and share reports in professional ways