COURSE OBJECTIVES

To equip participants with advanced skills in data analytics and visualization using Microsoft Excel. Through hands-on exercises, participants will master data cleaning, transformation, statistical analysis, data visualization, dynamic dashboards and automated reporting using Power Query, PivotTables and advanced formulas, so they can turn raw data into actionable insights for informed decision-making

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:

• Apply advanced Excel functions and formulas to analytical tasks.
• Clean, transform and consolidate raw data using Power Query.
• Perform descriptive and statistical analysis on datasets.
• Explore and summarize data efficiently using PivotTables.
• Create effective charts and visualizations that communicate insights.
• Design interactive, dynamic dashboards for decision-making.
• Automate recurring reports and workflows in Excel

TARGET PARTICIPANTS

Data Analysts, BI Analysts, Data Engineers, Data Scientists and Data Managers Business, Finance, Accounting, Marketing, HR and Taxation Professionals Health, M&E and IT Professionals Students and Graduates interested in Data Analytics Anyone interested in data-driven decision-making

Offered By : Directorate of Public Services - College of Information and Communications Technology

OTHER DETAILS

Cost: 850,000

Currently Not Accepting Applications
Cancel