Description

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

Lesson 1.1: Chart of Accounts Setup

• Structuring account codes and names
• Account categorization (Assets, Liabilities, Equity)
• Nigerian accounting standards considerations
• Practice: SME chart of accounts template

Lesson 1.2: Journal Entry Templates

• Creating standardized journal entry formats
• Date, reference, and description standards
• Debit/credit validation formulas
• Practice: Monthly journal entry log

Lesson 1.3: Trial Balance Automation

• Linking accounts to trial balance
• Automated balance calculations
• Error checking and validation
• Practice: Automated trial balance from journal entries

Lesson 1.4: Financial Statement Templates

• Income statement structure and formulas
• Balance sheet layout and linking
• Cash flow statement basics
• Practice: Basic financial statements package

Lesson 1.5: Month-End Closing Procedures

• Standardized closing checklist
• Accruals and deferrals tracking
• Documentation requirements
• Practice: Month-end closing worksheet

Module 2: Advanced Accounting Functions and Week 2: 4.5 hours of Lecture time

Lesson 2.1: Advanced VLOOKUP for Accounting

• Account code lookups
• Multi-criteria lookups with helper columns
• IFERROR for clean account matching
• Practice: Automated account classification

Lesson 2.2: SUMIF & SUMIFS for Account Analysis

• Summing by account categories
• Multiple criteria summations
• Date range summations for periods
• Practice: Departmental expense analysis

Lesson 2.3: Depreciation Calculations

• Straight-line depreciation formulas
• Declining balance methods
• MACRS depreciation schedules
• Practice: Fixed asset register with depreciation

Lesson 2.4: Loan & Interest Calculations

• PMT function for loan payments
• IPMT and PPMT for principal/interest breakdown
• Amortization schedule creation
• Practice: Business loan amortization table

Lesson 2.5: Tax Calculations (Nigerian Context)

• VAT calculations and tracking
• Withholding tax computations
• PAYE calculations for payroll
• Practice: Nigerian tax computation worksheet

Lesson 2.6: Bank Reconciliation Tools

• Bank statement import and formatting
• Reconciliation formulas and checks
• Outstanding items tracking
• Practice: Automated bank reconciliation

Module 3: Management Reporting and Week 3: 4.5 hours of Lecture time

Lesson 3.1: Budget vs Actual Analysis

• Variance calculation formulas
• Percentage variance analysis
• Conditional formatting for variances
• Practice: Monthly budget performance report

Lesson 3.2: Cash Flow Forecasting

• Cash flow projection formulas
• Rolling 13-week cash flow
• Scenario analysis setup
• Practice: 6-month cash flow forecast

Lesson 3.3: Key Performance Indicators (KPIs)

• Financial ratio calculations
• Automated KPI dashboards
• Trend analysis and visualization
• Practice: Executive dashboard creation

Lesson 3.4: Cost Center Reporting

• Department-wise expense allocation
• Cost center profitability analysis
• Transfer pricing calculations
• Practice: Multi-department P&L

Lesson 3.5: Payroll Processing

• Salary calculation templates
• Tax and deduction formulas
• Payslip automation
• Practice: Monthly payroll processing sheet

Module 4: Compliance & Controls and Week 4: 4.5 hours of Lecture time

Lesson 4.1: Audit Trail Creation

• Version control systems
• Change tracking methods
• Documentation standards
• Practice: Audit-ready workbook setup

Lesson 4.2: Data Validation for Accuracy

• Input controls and validation rules
• Error prevention techniques
• Formula protection methods
• Practice: Error-proof data entry forms

Lesson 4.3: Backup & Security Procedures

• File protection and passwords
• Backup automation
• Version management
• Practice: Secure accounting workbook

Lesson 4.4: Nigerian Regulatory Reporting

• CAC annual returns preparation
• FIRS tax return formats
• CBN regulatory reports (for applicable entities)
• Practice: Regulatory report templates

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

• Complete accounting system for small Nigerian business
• Full month accounting cycle from transactions to financial statements
• Includes all regulatory and management reports