Clean and organize messy spreadsheet data.
School of Data & AIData & AIBeginner to Intermediate
Excel for Data Analytics
Turn raw spreadsheets into clean analysis, useful reports, and business-ready insights.
Learn the Excel skills data analysts use to clean messy data, apply formulas, summarize records with pivot tables, build charts, and prepare reports that help people make better decisions.
Duration
6 weeks - 5–8 hours /week
Project
Clean and organize messy spreadsheet data.
Support
Mentorship and review options available
Overview
A practical Short Course built around a visible project.
Master the Excel skills used by data analysts to clean, organize, calculate, summarize, visualize, and report business data with confidence.
Use essential Excel formulas for analysis and reporting.
Apply lookup functions to connect and enrich datasets.
Build pivot tables for fast business summaries.
Create charts that reveal trends and performance changes.
Analyze sales, finance, customer, marketing, and operations data.
Identify patterns, outliers, gaps, and opportunities.
Build clean spreadsheet reports and simple dashboards.
Present Excel analysis in a way business users can understand.
Create portfolio-ready Excel analytics projects.
Course roadmap
What you will work through.
The sequence below is specific to this course. It shows the phases, modules, lessons, and page outlines that move you toward Clean and organize messy spreadsheet data..
1Phase 1 - Excel Foundations for AnalystsBuild the foundation for professional spreadsheet analytics: workflow, navigation, data entry, formatting, structure, and workbook design.1 modules4 lessons1–2 weeks
Module 1: Working with Data in ExcelLearn spreadsheet analytics, Excel navigation, reliable data entry, structured tables, validation, and professional workbook design.4 lessons
Lesson 1: Introduction to Spreadsheet AnalyticsUnderstand spreadsheet analytics, where Excel fits in the analyst workflow, and how analysts use workbooks to support decisions.75 minarticle5 pages
Welcome and Learning Objectives
Start the course and understand why Excel still matters for data analytics.
8 min
What Spreadsheet Analytics Is
Define spreadsheet analytics in practical business terms.
15 min
Common Business Use Cases
Show where Excel appears in real business work.
18 min
The Analyst Workflow
Teach the workflow students will repeat throughout the course.
18 min
Exercise - Sales Dataset Discovery Lab
Students explore a sales dataset and write first observations.
16 min
Lesson 2: Excel Interface and NavigationLearn the Excel workspace, workbook structure, sheets, navigation habits, and shortcuts that make analysis faster.70 minarticle4 pages
Welcome and Learning Objectives
Introduce the Excel interface and navigation habits.
8 min
Workbook and Worksheet Basics
Explain the basic objects students use in Excel.
15 min
Navigation and Shortcuts
Teach practical navigation habits.
20 min
Exercise - Workbook Navigation Challenge
Students practice navigating a multi-sheet workbook.
27 min
Lesson 3: Data Entry and FormattingLearn how data types, formatting, tables, and validation affect the quality of spreadsheet analysis.75 minarticle4 pages
Welcome and Learning Objectives
Introduce reliable data entry and formatting.
8 min
Data Types and Formatting
Explain how Excel data types affect analysis.
20 min
Tables and Data Validation
Introduce Excel tables and validation rules.
20 min
Exercise - Structured Dataset Build
Students create a clean dataset structure.
27 min
Lesson 4: Professional Spreadsheet DesignLearn layout principles, naming conventions, and documentation habits that make workbooks easier to trust and maintain.75 minarticle4 pages
Welcome and Learning Objectives
Introduce professional workbook design.
8 min
Workbook Layout Principles
Teach workbook organization.
20 min
Naming and Documentation
Explain naming conventions and documentation.
18 min
Exercise - Spreadsheet Rescue
Students redesign a poorly structured spreadsheet.
29 min
2Phase 2 - Core Analytical FunctionsBuild confidence with formulas and functions used in business reporting and data preparation.1 modules6 lessons2 weeks
Module 1: Formulas and FunctionsUse core formulas, logical functions, text/date functions, and lookup techniques for analysis.6 lessons
Lesson 1: Formula FundamentalsLearn references, relative references, absolute references, and basic calculations.55 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
27 min
Practice Activity
Apply the lesson through a guided exercise.
20 min
Lesson 2: Logical FunctionsUse IF, IFS, AND, and OR to encode business rules in Excel.60 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
30 min
Practice Activity
Apply the lesson through a guided exercise.
22 min
Lesson 3: Text FunctionsUse text functions to clean and prepare customer or product data.55 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
27 min
Practice Activity
Apply the lesson through a guided exercise.
20 min
Lesson 4: Date and Time FunctionsUse date and time functions for subscription and operational reporting.55 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
27 min
Practice Activity
Apply the lesson through a guided exercise.
20 min
Lesson 5: Lookup FunctionsUse lookup functions to match records and enrich reporting datasets.65 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
32 min
Practice Activity
Apply the lesson through a guided exercise.
25 min
Lesson 6: Mini Project 1 - Sales Reporting WorkbookBuild a sales reporting workbook using formulas, lookups, and structured calculations.80 minarticle2 pages
Project Brief
Explain the project scenario and expected output.
20 min
Review Checklist
Checklist for project quality.
20 min
3Phase 3 - Data Cleaning and PreparationLearn how to identify dirty data, clean it, validate it, and prepare it for analysis.1 modules5 lessons1–2 weeks
Module 1: Data Quality ManagementBuild practical data cleaning and quality management habits in Excel.5 lessons
Lesson 1: Understanding Dirty DataIdentify missing values, duplicates, inconsistencies, and the risks they create.50 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
25 min
Practice Activity
Apply the lesson through a guided exercise.
17 min
Lesson 2: Cleaning TechniquesApply practical cleanup techniques to customer and operational data.60 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
30 min
Practice Activity
Apply the lesson through a guided exercise.
22 min
Lesson 3: Data ValidationUse validation rules, dropdowns, and error prevention techniques.55 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
27 min
Practice Activity
Apply the lesson through a guided exercise.
20 min
Lesson 4: Data TransformationTransform datasets by splitting, combining, and restructuring fields.60 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
30 min
Practice Activity
Apply the lesson through a guided exercise.
22 min
Lesson 5: Mini Project 2 - Customer Data Cleanup ProjectClean a messy customer dataset and produce a data quality report.80 minarticle2 pages
Project Brief
Explain the project scenario and expected output.
20 min
Review Checklist
Checklist for project quality.
20 min
4Phase 4 - Analytical Thinking with ExcelUse Excel to analyze business data through filtering, formatting, descriptive statistics, trends, and scenarios.1 modules5 lessons1–2 weeks
Module 1: Data AnalysisMove from cleaned data to practical analysis and business interpretation.5 lessons
Lesson 1: Sorting and FilteringUse filters and sorting to investigate business performance.50 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
25 min
Practice Activity
Apply the lesson through a guided exercise.
17 min
Lesson 2: Conditional FormattingUse visual indicators to highlight trends, exceptions, and risks.50 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
25 min
Practice Activity
Apply the lesson through a guided exercise.
17 min
Lesson 3: Descriptive StatisticsUse basic statistics to summarize sales and performance data.55 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
27 min
Practice Activity
Apply the lesson through a guided exercise.
20 min
Lesson 4: Trend AnalysisAnalyze growth rates, comparisons, and time-based performance.60 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
30 min
Practice Activity
Apply the lesson through a guided exercise.
22 min
Lesson 5: Scenario AnalysisUse what-if analysis, Goal Seek, and scenarios for business forecasting.60 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
30 min
Practice Activity
Apply the lesson through a guided exercise.
22 min
5Phase 5 - Pivot Tables and ReportingBuild professional reporting workflows with pivot tables, pivot charts, slicers, timelines, and interactive dashboards.1 modules5 lessons1–2 weeks
Module 1: Professional ReportingUse pivot tables and interactive reporting tools to summarize business data.5 lessons
Lesson 1: Pivot Tables FundamentalsCreate pivot tables for summarization, grouping, and reporting.60 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
30 min
Practice Activity
Apply the lesson through a guided exercise.
22 min
Lesson 2: Advanced Pivot TablesUse calculated fields and multi-level analysis for deeper reporting.60 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
30 min
Practice Activity
Apply the lesson through a guided exercise.
22 min
Lesson 3: Pivot ChartsTurn pivot summaries into visual executive reports.55 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
27 min
Practice Activity
Apply the lesson through a guided exercise.
20 min
Lesson 4: Interactive ReportingUse slicers, timelines, and filters to make reports interactive.60 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
30 min
Practice Activity
Apply the lesson through a guided exercise.
22 min
Lesson 5: Milestone Project - Business Performance DashboardBuild an interactive dashboard for business performance monitoring.100 minarticle2 pages
Project Brief
Explain the project scenario and expected output.
20 min
Review Checklist
Checklist for project quality.
20 min
6Phase 6 - Business Dashboards and StorytellingCreate clear visuals, design dashboards, and communicate insights to stakeholders.1 modules4 lessons1–2 weeks
Module 1: Data VisualizationUse charts, dashboard design, and storytelling to communicate business insights.4 lessons
Lesson 1: Choosing the Right ChartSelect appropriate charts for different business questions.50 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
25 min
Practice Activity
Apply the lesson through a guided exercise.
17 min
Lesson 2: Dashboard Design PrinciplesDesign dashboards with layout, hierarchy, simplicity, and clarity.60 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
30 min
Practice Activity
Apply the lesson through a guided exercise.
22 min
Lesson 3: Data StorytellingCommunicate insights, risks, opportunities, and recommendations.55 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
27 min
Practice Activity
Apply the lesson through a guided exercise.
20 min
Lesson 4: Building Executive DashboardsBuild KPI, operational, and management reporting dashboards.80 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
40 min
Practice Activity
Apply the lesson through a guided exercise.
32 min
7Phase 7 - Productivity and AutomationImprove speed, consistency, and repeatability with productivity techniques, macros, and reusable templates.1 modules3 lessons1 week
Module 1: Working EfficientlyAutomate repetitive work and create reusable reporting assets.3 lessons
Lesson 1: Advanced Productivity TechniquesUse keyboard shortcuts, named ranges, and dynamic formulas to work faster and reduce errors.50 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
25 min
Practice Activity
Apply the lesson through a guided exercise.
17 min
Lesson 2: Introduction to AutomationUnderstand recorded macros and workflow automation concepts.60 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
30 min
Practice Activity
Apply the lesson through a guided exercise.
22 min
Lesson 3: Reusable Reporting TemplatesBuild templates that can be reused for weekly or monthly reporting.60 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
30 min
Practice Activity
Apply the lesson through a guided exercise.
22 min
8Phase 8 - Capstone, Graduation and PortfolioComplete an executive analytics dashboard capstone and package portfolio-ready Excel work.1 modules2 lessons1 week
Module 1: Executive Business Analytics CapstoneStudents complete an industry-based capstone project and prepare their portfolio outcome.2 lessons
Lesson 1: Final Capstone - Executive Business Analytics DashboardBuild a professional Excel analytics dashboard for one selected industry.140 minarticle2 pages
Project Brief
Explain the project scenario and expected output.
20 min
Review Checklist
Checklist for project quality.
20 min
Lesson 2: Graduation Requirements and Portfolio OutcomeClarify completion requirements and expected portfolio outputs.45 minarticle1 pages
Requirements and Portfolio Checklist
Summarize graduation requirements and portfolio assets.
45 min
Tools and skills
Build skill with the tools used in the work.
Clean and organize messy spreadsheet data.Use essential Excel formulas for analysis and reporting.Apply lookup functions to connect and enrich datasets.Build pivot tables for fast business summaries.Create charts that reveal trends and performance changes.Analyze sales, finance, customer, marketing, and operations data.Identify patterns, outliers, gaps, and opportunities.Build clean spreadsheet reports and simple dashboards.Present Excel analysis in a way business users can understand.Create portfolio-ready Excel analytics projects.
Projects and exercises
- Clean and organize messy spreadsheet data.
- Structured exercises
- Portfolio practice
Resources included
- Course resources
- Project guidance
- Learners building practical tech skills
- A willingness to practice consistently
Career relevance
Excel for Data Analytics supports practical career readiness.
Support options
Choose the level of feedback that matches your pace.
Compare the project, price, and feedback level before choosing the support option that fits your pace.
Self-Paced Only
₦50,000
Upfront Payment
₦50,000due today
- ₦50,000 at enrollment
Pay once or split into fixed installments.
Access starts after your first confirmed payment.
Related Professional Diploma
View Professional DiplomaData Analytics
Become a practical data analyst who can clean, analyze, visualize, and communicate business data using Excel, SQL, Python, Power BI, and real-world analytics projects.
FAQ
Questions about this Short Course.
Short Course answers about scope, projects, support, and next steps.
Yes. Excel remains one of the most widely used tools for business reporting, quick analysis, data cleaning, and decision support.
Related Short Courses
View all Short CoursesContinue building connected skills.
School of Data & AIData AnalyticsIntermediate
Power BI for Business Intelligence
Build interactive dashboards and business reports that make performance clear.
Learn to connect, clean, model, measure, visualize, and present business data using Power BI.
From₦85,000
8 weeks - 6-8 hours/week
Connect Power BI to different data sources.
Project included
Mentor review available
School of Data & AIData AnalyticsBeginner to Intermediate
SQL for Data Analytics
Query databases, join tables, summarize records, and uncover business insights with SQL.
Learn the SQL skills data analysts use to extract, filter, join, group, and analyze data from relational databases.
From₦65,000
7 weeks - 6-8 hours/week
Understand tables, columns, rows, keys, and relationships.
Project included
Mentor review available
Related Professional Diploma
Data Engineering
School of Data & AIData AnalyticsBeginner to Intermediate
Python for Data Analytics
Clean, explore, analyze, automate, and visualize data with Python.
Learn Python for real analytics work: data cleaning, exploration, transformation, automation, and visual insight generation.
From₦85,000
8 weeks - 6-8 hours/week
Write Python code for data analysis tasks.
Project included
Mentor review available
Short Course enrolment
Start with Excel for Data Analytics.
Learn how to clean, analyze, summarize, and present business data in Excel so you can move from ordinary spreadsheet use to practical analytics and reporting work.