Description

Total Contact period: 13.5 hours

Module 1: Excel Fundamentals and Week 1: 4.5 hours of Lecture time

Lesson 1.1: Welcome to Excel - Interface Tour

• Excel interface overview with Nigerian business context
• Ribbon, tabs, and workspace navigation
• Creating and saving workbooks
• Practice: Create your first budget spreadsheet

Lesson 1.2: Basic Data Entry & Navigation

• Entering text, numbers, and dates
• Cell selection techniques and shortcuts
• Moving around large spreadsheets efficiently
• Practice: Employee database with Nigerian names

Lesson 1.3: Understanding Cells, Rows & Columns

• Cell references (A1, B2, etc.)
• Inserting and deleting rows/columns
• Adjusting column width and row height
• Practice: Format a simple invoice template

Lesson 1.4: Basic Formatting & Presentation

• Font styles, colors, and borders
• Number formatting (Naira currency, percentages)
• Alignment and text wrapping
• Practice: Format a monthly expense report

Lesson 1.5: Printing & Page Setup

• Print preview and page breaks
• Headers and footers
• Scaling and orientation
• Practice: Print-ready financial statement

Module 2: Basic Calculations and Week 2: 4.5 hours of Lecture time

Lesson 2.1: Your First Formulas

• Understanding formulas vs values
• Basic arithmetic operators (+, -, *, /)
• Order of operations in Excel
• Practice: Calculate monthly salary breakdown

Lesson 2.2: Essential Functions - SUM & AVERAGE

• SUM function for totals
• AVERAGE for mean calculations
• Using function wizard
• Practice: Sales performance summary

Lesson 2.3: COUNT Functions

• COUNT, COUNTA, COUNTBLANK
• When to use each function
• Practice: Employee attendance tracker

Lesson 2.4: MIN, MAX & Basic Statistics

• Finding minimum and maximum values
• Basic statistical analysis
• Practice: Product pricing analysis

Lesson 2.5: Copying Formulas & Relative References

• How Excel adjusts formulas when copied
• Fill-down and fill-right techniques
• Understanding relative cell references
• Practice: Monthly budget calculations

Module 3: Data Management Basics and Week 3: 4.5 hours of Lecture time

Lesson 3.1: Sorting Your Data (20 min)

• Single-column sorting (A-Z, Z-A)
• Multi-column sorting
• Custom sort orders
• Practice: Customer list organization

Lesson 3.2: Basic Filtering

• AutoFilter setup and usage
• Text and number filters
• Date filtering techniques
• Practice: Sales data filtering by region

Lesson 3.3: Data Validation Basics

• Creating dropdown lists
• Setting up data validation rules
• Error alerts and input messages
• Practice: Employee information form

Lesson 3.4: Basic Charts & Graphs

• Column charts for comparisons
• Pie charts for proportions
• Line charts for trends
• Practice: Monthly sales visualization

Lesson 3.5: Find & Replace + Basic Cleanup

• Finding and replacing data
• Basic data cleanup techniques
• Practice: Clean customer database

Course 1 Final Project and Week 4: Students to submit finished project

• Create a complete small business monthly report
• Includes: revenue, expenses, profit calculation, basic charts
• Uses all learned skills in practical context