Data Analysis with Excel

Program Code: DAE

8 weeks Online Kumoyo Technologies Online

Program Overview

Master data analysis techniques using Microsoft Excel. Learn advanced formulas, pivot tables, Power Query, data visualization, and business analytics. This course transforms you from a basic Excel user to a data analysis professional.

Curriculum & Modules

Week 1: Excel Fundamentals

Excel interface and navigation
Essential shortcuts and productivity tips
Data entry and formatting techniques
Basic formulas (SUM, AVERAGE, COUNT, MIN, MAX)
Cell referencing (Relative, Absolute, Mixed)
Creating and formatting professional tables

Week 2: Intermediate Excel Functions

IF, AND, OR logical functions
VLOOKUP, HLOOKUP, XLOOKUP
INDEX and MATCH functions
Date and time functions
Text functions (LEFT, RIGHT, MID, CONCATENATE)
Data validation for error control

Week 3: Advanced Functions

SUMIFS, COUNTIFS, AVERAGEIFS
SUMPRODUCT function
INDIRECT and OFFSET
Nested functions
Array formulas
Advanced error handling

Week 4: Data Analysis with Pivot Tables

Creating pivot tables from data
Customizing pivot table layouts
Slicers and timelines
Calculated fields and items
Pivot charts
Power Pivot for large datasets

Week 5: Power Query for Data Transformation

Introduction to Power Query
Importing data from multiple sources
Data cleaning and transformation
Merging and appending queries
Creating custom columns
Automating data refresh

Week 6: Data Visualization

Creating professional charts
Advanced chart types (Waterfall, Gantt, Histogram)
Conditional formatting for data insights
Sparklines
Dashboard design principles
Creating interactive dashboards

Week 7: Business Analytics

What-if analysis (Goal Seek, Scenario Manager)
Regression analysis
Forecasting and trend analysis
Financial analysis techniques
Business metrics and KPIs
Automating reports with macros

Week 8: Final Project

Complete business analytics project
Build a comprehensive dashboard
Presentation and review

Entry Requirements

Basic computer literacy. Microsoft Excel 2016 or later recommended (or Google Sheets). Laptop/Desktop with internet connection.

Learning Outcomes

Excel interface and navigation

Essential shortcuts and productivity tips

Data entry and formatting techniques

Basic formulas (SUM, AVERAGE, COUNT, MIN, MAX)

Cell referencing (Relative, Absolute, Mixed)

Creating and formatting professional tables

IF, AND, OR logical functions

VLOOKUP, HLOOKUP, XLOOKUP

INDEX and MATCH functions

Date and time functions

Text functions (LEFT, RIGHT, MID, CONCATENATE)

Data validation for error control

SUMIFS, COUNTIFS, AVERAGEIFS

SUMPRODUCT function

INDIRECT and OFFSET

Nested functions

Array formulas

Advanced error handling

Creating pivot tables from data

Customizing pivot table layouts

Slicers and timelines

Calculated fields and items

Pivot charts

Power Pivot for large datasets

Introduction to Power Query

Importing data from multiple sources

Data cleaning and transformation

Merging and appending queries

Creating custom columns

Automating data refresh

Creating professional charts

Advanced chart types (Waterfall, Gantt, Histogram)

Conditional formatting for data insights

Sparklines

Dashboard design principles

Creating interactive dashboards

What-if analysis (Goal Seek, Scenario Manager)

Regression analysis

Forecasting and trend analysis

Financial analysis techniques

Business metrics and KPIs

Automating reports with macros

Complete business analytics project

Build a comprehensive dashboard

Presentation and review

Program Fees

Course Fee

ZMW 3,000.00

One-time payment

Application Fee ZMW 30.00

Total Investment:

ZMW 3,030.00

All inclusive

Certification

Kumoyo Technologies

Apply Now Request More Info Back to Programs

8
weeks

8
Modules

Hands-on
Practical