Bructech Academy
Courses Live Academy Store Mentorship About Contact Log In Sign Up Free

Shopping Cart

0 items

Your cart is empty

Add courses or products to get started on your learning journey.

Browse Courses
Data Analysis

DATA ANALYSIS WITH EXCEL

Learn how to analyze real-world data using Microsoft Excel — from organizing raw datasets to building dashboards that tell a clear story. Data is everywhere, but raw data alone means nothing without the ability to interpret it. In this course, you'll learn how to use Microsoft Excel.

1 students all English

Created by Daniel Agboje

Last updated Jun 2026

DATA ANALYSIS WITH EXCEL
₦5,000 ₦15,000 67% off
Login to Purchase
  • 3 hours on-demand video
  • 54 lessons
  • Certificate of completion
  • Full lifetime access

Course Description

Data is everywhere, but raw data alone means nothing without the ability to interpret it. In this course, you'll learn how to use Microsoft Excel as a powerful data analysis tool — not just for calculations, but for uncovering patterns, drawing insights, and presenting findings in a way that drives decisions. Starting from the basics of data organization and cleaning, you'll progressively work through Excel's most important analysis features: formulas, functions, pivot tables, charts, and dashboards. Every concept is taught using practical Nigerian business datasets so you can immediately relate what you're learning to real-world scenarios. Whether you're a student, a business owner, a job seeker, or a professional looking to add a high-demand skill to your CV, this course gives you a structured, hands-on path to becoming confident with data in Excel. No prior experience is required — just a willingness to learn and practice. By the end of this course, you won't just know how to use Excel — you'll know how to think with data.

What You'll Learn

Organize and clean messy raw data into structured, analysis-ready tables
Use essential Excel formulas and functions (SUM, IF, VLOOKUP, COUNTIF, etc.) for data calculations
Sort, filter, and query datasets to extract specific insights
Build and customize Pivot Tables to summarize large volumes of data
Create professional charts and graphs that communicate data visually
Design an interactive Excel dashboard that presents key business metrics at a glance
Apply data analysis skills to real Nigerian business scenarios
Make data-driven recommendations based on findings from their analysis

Requirements

  • A laptop or desktop computer (Windows or Mac)
  • Microsoft Excel 2016 or later (Microsoft 365 recommended)
  • No prior knowledge of data analysis needed
  • Basic computer literacy (ability to open files, type, and navigate folders)
  • Willingness to practice with the provided datasets

Course Curriculum

9 sections · 54 lectures · 180 min total
  • Welcome video Preview 04:10
  • 1.1 Installing and Setting Up Excel Properly 03:00
  • 1.2 Excel Interface Tour — Ribbon, Sheets, Formula Bar 04:10
  • 1.3 Essential Keyboard Shortcuts Every Analyst Must Know 05:00
  • 1.4 Introducing Our Two Projects — Mega Mart & TechBridge 06:00
  • 2.1 Data Types in Excel — Text, Numbers, Dates, Currency 04:10
  • 2.2 Importing Data from a CSV File 04:10
  • 2.3 Importing Data from Another Excel Workbook 05:00
  • 2.4 First Look at the Mega Mart Sales Dataset 04:20
  • 2.5 First Look at the TechBridge Nigeria HR Dataset 04:20
  • 3.1 Why Clean Data Matters
  • 3.2 Finding and Removing Duplicate Records 03:20
  • 3.3 Handling Blank and Missing Cells 06:00
  • 3.4 TRIM, UPPER, LOWER, PROPER 10:00
  • 3.5 Find & Replace for Bulk Corrections 10:00
  • 3.6 Fixing Date Format Problems in Excel 10:00
  • 3.7 Hands-On — Cleaning the Mega Mart Sales Dataset 11:00
  • 3.8 Hands-On — Cleaning the TechBridge Nigeria HR Dataset 10:00
  • 4.1 SUM, AVERAGE, COUNT, MAX, MIN 09:10
  • 4.2 COUNTA vs COUNT 04:00
  • 4.3 IF Statements 06:00
  • 4.4 COUNTIF & COUNTIFS 07:00
  • 4.5 SUMIF & SUMIFS 09:00
  • 4.6 AVERAGEIF — Averaging with Conditions 05:00
  • 4.7 VLOOKUP — Finding Data Across Tables 15:00
  • 4.8 Date Functions 05:00
  • 5.1 Sorting Data — Single-Level and Multi-Level 06:00
  • 5.2 AutoFilter — Filtering Your Dataset Instantly 05:00
  • 5.3 Freeze Panes — Keeping Headers Visible 04:20
  • Creating Your First Pivot Table from Scratch
  • Grouping Data by Month, Quarter and Year
  • Calculated Fields — Adding Custom Computations
  • Pivot Table Styles and Professional Formatting
  • Slicers — Making Your Pivot Table Interactive
  • Project 1 — Full Pivot Analysis for Mega Mart Sales
  • Choosing the Right Chart Type for Your Data
  • Column and Bar Charts — Comparisons
  • Line Charts — Trends Over Time
  • Pie and Doughnut Charts — Proportions
  • Combo Charts — Two Chart Types in One
  • Formatting Charts Professionally
  • Project 1 — Building All Mega Mart Sales Charts
  • Dashboard Design Principles for Analysts
  • Setting Up Your Dashboard Sheet
  • Adding KPI Summary Cards
  • Linking Charts and Pivot Tables to Your Dashboard
  • Adding Slicers to Control the Dashboard
  • Formatting, Colours and Final Touches
  • Project 1 — Complete Mega Mart Sales Dashboard
  • Writing Insights and Business Recommendations
  • Presenting Your Analysis Professionally
  • Building Your Data Analyst Portfolio in Nigeria
  • Freelancing as a Data Analyst on Upwork and Local Platforms
  • Getting a Data Analyst Job in Nigeria — What Companies Look For

Your Instructor

Daniel Agboje

Daniel Agboje is a visionary tech entrepreneur, ICT consultant, and the CEO of Bructech Nig Services. He is passionate about empowering individuals and businesses with digital skills, building innovative tech solutions, and driving real-world impact through technology, education, and automation.

1