COURSE OBJECTIVES

This course aims to equip participants with advanced skills in data analytics and visualization using Microsoft Excel. It focuses on developing practical abilities in data cleaning, transformation, and statistical analysis to prepare data for insightful exploration. Participants will learn to perform exploratory data analysis using PivotTables, create compelling data visualizations, and build interactive dashboards. Additionally, the course trains participants to automate data processing and reporting tasks using Power Query and advanced Excel formulas. By the end of the course, participants will be empowered to turn raw data into actionable insights that support informed and effective decision-making in their respective fields.

KEY TOPICS

• Excel Foundations for Advanced Analytics
• Data Cleaning and Transformation with Excel
• Descriptive and Statistical Analysis with Excel
• Exploratory Analysis with PivotTables with Excel
• Data Visualization Techniques with Excel
• Interactive Dashboards with Excel
• Automation and Reporting with Excel

LEARNING OUTCOMES

By the end of the course participants will be able to:

• By the end of this course, participants will be able to confidently clean, transform, and analyze complex datasets using Microsoft Excel. They will master the use of PivotTables for exploratory data analysis and apply various data visualization techniques to communicate insights effectively. Participants will also be skilled in designing interactive dashboards and automating reporting processes using Power Query and advanced formulas. These capabilities will enable them to turn raw data into clear, actionable insights that drive informed decision-making across diverse professional contexts

TARGET PARTICIPANTS

Data Analysts, BI Analyst, Data Engineers, Data Scientists and Data Managers; Business, Finance, Accounting, HR, and IT professionals; M&E Officers, Researchers, Project Managers and Entrepreneurs; University students, and anyone Interested in Data-driven Decision-Making

Offered By : Electronics and Telecommunication Engineering - Directorate of Public Services

OTHER DETAILS

Course Timeline 5 days
Starting at: 06/10/2025 , ends at: 10/10/2025
Cost: 750,000

Apply Cancel