September Master Classes for NGOs, SMEs, Individuals, Students and Corporates

1.      Master Class 1: The Consultancy Blueprint Master Class

2.      Master Class 2: Advanced Resource Mobilization & Technical Grant Writing Masterclass

3.      Master Class 3: Data Analytics using Excel and Power Bi

4.      Book Sale: The Pundit of Strategic Resource Mobilization

Master Class 1: The Consultancy Blueprint Master Class

From Expert to Highly Paid Consultant

Master Consulting, Win Contracts, Deliver Excellence & Build a Thriving Consulting Business.

Course Overview

This is a practical, career-transforming programme designed for professionals who want to become successful independent consultants or strengthen their consulting practice. Participants will learn how to position themselves as experts, identify consulting opportunities, develop winning technical and financial proposals, negotiate contracts, deliver high-quality consultancy assignments, manage clients professionally, and build a profitable consulting business. The course combines international consulting standards with real-world experience from humanitarian, development, government, NGO, and private sector consulting assignments.

Course Delivery, Certification & Fees

·        Training Dates: 1/09-2026-25/09/2026

·        Delivery Mode: Live virtual sessions via Zoom: (Session recordings provided to all participants)

·        Certification:Certificate of Completion

·        Course Fee:ZMW 2,550 per participant

Target Audience

This programme is designed for development professionals, NGO managers, monitoring and evaluation (M&E) specialists, researchers, programme and project managers, engineers, public health professionals, financial experts, human resource practitioners, environmental specialists, university lecturers, freelancers, retirees, and other professionals seeking to transition into consulting or establish successful independent consulting practices. It is equally suitable for individuals looking to strengthen their consulting competencies, expand their client base, secure consultancy assignments with governments, NGOs, UN agencies, development partners, and the private sector, or build sustainable consulting businesses.

Module 1

Becoming a Professional Consultant

• What consulting really is
• Types of consultants
• Development vs Corporate consulting
• Independent vs Firm consulting
• Ethics of consulting
• International consulting standards
• Competencies of successful consultants

Module 2

Finding Consulting Opportunities

• Understanding the consulting market
• UN consulting opportunities
• NGO consulting opportunities
• Government consulting
• Corporate consulting
• DevelopmentAid
• UNGM
• Devex
• ReliefWeb
• LinkedIn
• Consultancy databases
• Building opportunity pipelines

Module 3

Building Your Consulting Brand

• Developing your niche
• Positioning yourself as an expert
• Building a consulting CV
• Consulting capability statement
• Professional biography
• Personal branding
• LinkedIn optimization
• Professional networking

Module 4

Winning Consultancy Assignments

Understanding

• Expressions of Interest (EOIs)
• Terms of Reference (TORs)
• Requests for Proposals (RFPs)
• Invitations to Bid
• Consultancy evaluations

Preparing

• Technical proposals
• Financial proposals
• Methodologies
• Work plans
• Risk management plans
• Team composition
• Common proposal mistakes
• Proposal evaluation criteria

Module 5

Consultancy Pricing

• Daily rates
• International consulting rates
• NGO consulting rates
• UN consultancy rates
• Pricing models
• Negotiation
• Financial sustainability

Module 6

Consultancy Project Management

• Inception meetings
• Stakeholder engagement
• Workplans
• Deliverables
• Quality assurance
• Communication
• Risk
• Time

Module 7

Research & Consultancy Methods

• Needs assessments
• Organizational assessments
• Evaluations
• Baselines
• Endlines
• Surveys
• Interviews
• FGDs
• KIIs
• Data collection
• Report writing

Module 8

Stakeholder Engagement

Working with

• Governments
• NGOs
• UN Agencies
• Boards
• Communities
• Donors
• Development Partners
• Managing difficult clients
• Conflict resolution
• Professional communication

Module 9

Writing Consultancy Reports

• Inception reports
• Progress reports
• Evaluation reports
• Strategic plans
• Policies
• Research reports
• Board papers
• Presentations

Module 10

Strategy Consulting

• Strategic Plans
• Theory of Change
• Results Frameworks
• Business Plans
• Sustainability Plans
• Resource Mobilization Strategies

Module 11

Financial & Legal Aspects

• Consultancy contracts
• Intellectual property
• Confidentiality
• Tax obligations
• Record keeping
• Invoicing
• Procurement rules
• Anti-corruption

Module 12

Building a Sustainable Consulting Business

• Registering a consulting firm
• Business models
• Marketing
• Proposal pipelines
• Strategic partnerships
• Repeat business
• Referrals
• Scaling internationally

Practical Sessions

Participants will develop:

• Professional Consulting CV
• Capability Statement
• LinkedIn Profile
• Technical Proposal
• Financial Proposal
• Consulting Methodology
• Consultancy Budget
• Inception Report
• Final Consultancy Report
• Pitch Presentation
• Consulting Business Plan

Course Outcomes

By the end of the programme, participants will be able to:

• Position themselves as professional consultants.
• Identify and secure consulting opportunities.
• Prepare winning technical and financial proposals.
• Price consultancy services competitively.
• Deliver consultancy assignments professionally.
• Produce high-quality consultancy reports.
• Build long-term client relationships.
• Establish and grow a sustainable consulting practice.

Trainer Profile

LinkedIn: https://www.linkedin.com/in/dr-emmanuel-sakala-post-doctorate-sml-dba-dual-mbas-mscpm-009117bb?utm_source=share_via&utm_content=profile&utm_medium=member_ios

Join via: https://chat.whatsapp.com/BVeRwYmzJzI2KOKWEcTfvd?mode=gi_t

Master Class 2

Advanced Resource Mobilization & Technical Grants Writing Masterclass

Course Overview

This course equips organizations with practical tools to mobilize catalytic resources, adapt to shifting donor environments, and strengthen technical grant-writing capacity. Participants will explore innovative financing mechanisms, donor engagement strategies, and structured approaches to closing funding gaps while ensuring accountability, transparency, and sustainability.

Course Delivery, Certification & Fees

·        Training Dates: 1/09-20/09/2026

·        Delivery Mode: Live virtual sessions via Zoom: (Session recordings provided to all participants)

·        Certification:Certificate of Completion

·        Course Fee:ZMW 2,000 per participant

Module 1: Organizational Portfolio Review & Sustainability Analysis (3 Days)

Organizational Environmental Scan for Sustainability

·        Internal and external analysis

·        Risk and opportunity mapping

Understanding the Funding Gap

·        Current resource flows vs. organizational needs

·        Programmatic and operational funding shortfalls

Packaging Pathways to Close the Funding Gap

·        Strategic positioning of programs

·        Aligning mission, impact, and financing options

Adapting to the Current Donor Environment

·        Trends in global and in-country donor priorities

·        Shifts from traditional aid to catalytic financing

The Fundraising Survey (In-Country and Global)

·        Mapping donor interests and funding cycles

·        Using data to inform resource mobilization strategies

Module 2: Blended and Innovative Finance

Public–Private–Nonprofit Partnerships

·        Partnership models and value propositions

·        Risk-sharing and co-financing approaches

The Green Bonds Market as an Instrument for Organizational Resilience

·        Overview of green bonds

·        Opportunities for nonprofits and social enterprises

Endowment Funds

·        Establishment, governance, and management

·        Role of endowments in long-term sustainability

The Funding Mix

·        Diversifying revenue streams

·        Balancing grants, earned income, and innovative finance

Module 3: Donor Engagement & Technical Writing

Fundraising Events

·        Strategic planning and return on investment

·        Donor cultivation through events

Donor Communication

·        Messaging, storytelling, and relationship management

·        Reporting for trust and retention

Pitch Decks and Other Organizational Collateral

·        Developing compelling pitch decks

·        Key materials for donor engagement

Program Design for Additionality, Accountability, and Transparency

·        Results-based design

·        Monitoring, evaluation, and learning considerations

Module 4: Technical Grant Writing

·        Concept Notes: 8-step structured approach

·        Program Proposals: 13-step development framework

·        Practical writing, review, and refinement

About the Trainer

LinkedIn: https://www.linkedin.com/in/dr-emmanuel-sakala-post-doctorate-sml-dba-dual-mbas-mscpm-009117bb?utm_source=share_via&utm_content=profile&utm_medium=member_ios

Join via: https://chat.whatsapp.com/HMOjcdSSn8qLkyXbWbK3xE?mode=gi_t

Master Class 3

Data Analytics using Excel & Power BI

Course Overview

This practical, hands-on course equips participants with essential data analytics skills using Microsoft Excel and Microsoft Power BI. Participants will learn to collect, clean, transform, analyze, visualize, and interpret data to support evidence-based decision-making. The programme combines advanced Excel analytics with modern Business Intelligence (BI) techniques, enabling learners to create interactive dashboards, automate reporting processes, and generate actionable insights for organizations, businesses, NGOs, and development programmes.

Course Delivery, Certification & Fees

• Training Dates: 1/09/2026 – 24/09/2026

• Delivery Mode: Live Virtual Sessions via Zoom (All sessions are recorded and shared with participants for lifetime access.)

• Training Schedule: Evening Classes (19:00–21:00 CAT)

• Practical Sessions: Real-world datasets, exercises, assignments and guided projects

• Certification: Certificate of Completion

• Course Fee: ZMW 2,000 per participant (Payable in two instalments of ZMW 1,000 each.)

Module 1: Core Microsoft Excel

Data Entry & Data Cleaning

• Data formatting and organization

• Text-to-Columns

• Remove Duplicates

• Data Validation

• Handling missing and inconsistent data

Excel Formulas & Functions

• SUM, AVERAGE, COUNT

• IF, IFS, AND, OR

• VLOOKUP, HLOOKUP

• INDEX & MATCH

• XLOOKUP

• Text Functions

• Date & Time Functions

• Logical and Lookup Functions

Excel Tables & Named Ranges

• Creating Excel Tables

• Structured References

• Named Ranges

• Dynamic Data Ranges

• Best practices for managing datasets

Module 2: Intermediate Data Analysis

Sorting & Filtering

• Multi-level Sorting

• Custom Sorting

• Advanced Filtering

• Dynamic Filters

Conditional Formatting

• Highlighting trends

• Data bars and colour scales

• Identifying duplicates

• Detecting anomalies and thresholds

PivotTables & PivotCharts

• Building PivotTables

• Grouping data

• Calculated Fields

• Interactive PivotCharts

• Dashboard-ready summaries

Statistical Analysis

• Descriptive Statistics

• Correlation Analysis

• Regression Basics

• Z-Scores

• Hypothesis Testing

• Data interpretation

Module 3: Microsoft Power BI

Introduction to Data Analytics

• Data-driven decision making

• Business Intelligence concepts

• Data analytics lifecycle

• Analytical thinking

Getting Started with Power BI

• Power BI Desktop interface

• Connecting to Excel, CSV, SQL and other data sources

• Importing and managing datasets

• Building your first report

Data Cleaning, Transformation & Loading

• Power Query Editor

• Cleaning messy datasets

• Handling missing values

• Data transformation techniques

• Merge and Append Queries

• Data profiling

Designing Effective Data Models

• Table relationships

• Star Schema Design

• Snowflake Schema

• Normalization vs. Denormalization

• Data modelling best practices

DAX (Data Analysis Expressions)

• Calculated Columns

• Measures

• CALCULATE()

• SUMX()

• RELATED()

• FILTER()

• Time Intelligence Functions

• Building reusable calculations

Performance Optimization

• Query Folding

• Aggregations

• Model Optimization

• Reducing redundancy

• Improving report performance

Interactive Reports & Dashboards

• Creating professional visuals

• KPIs and Scorecards

• Maps and Charts

• Slicers and Filters

• Drill-through Reports

• Publishing to Power BI Service

• Dashboard Sharing and Collaboration

Module 4: Advanced Microsoft Excel

Data Analysis ToolPak

• Regression Analysis

• ANOVA

• t-Tests

• Chi-Square Tests

• Forecasting

What-If Analysis

• Goal Seek

• Scenario Manager

• Data Tables

• Sensitivity Analysis

Advanced Data Visualization

• Bar Charts

• Line Charts

• Scatter Plots

• Combo Charts

• Sparklines

• Dynamic Charts

• Dashboard Design Principles

Power Query (Get & Transform)

• Importing data from multiple sources

• Cleaning datasets

• Shaping data

• Merging Queries

• Appending Queries

• Refresh Automation

Power Pivot

• Building Data Models

• Table Relationships

• DAX Fundamentals

• CALCULATE()

• SUMX()

• RELATED()

• Creating scalable analytical models

Learning Outcomes

By the end of this programme, participants will be able to:

• Master Microsoft Excel from beginner to advanced level.

• Clean, transform and prepare data for analysis.

• Perform statistical and business data analysis.

• Build PivotTables, PivotCharts and dynamic dashboards.

• Develop interactive Power BI reports and dashboards.

• Create robust data models using Power Query and Power Pivot.

• Write DAX formulas to solve analytical problems.

• Produce professional reports for management and donors.

• Automate reporting processes and improve productivity.

• Apply data analytics techniques to support evidence-based decision making.

Who Should Attend?

This course is ideal for:

• Monitoring, Evaluation, Accountability & Learning (MEAL/M&E) Professionals

• Project Managers

• Programme Officers

• Finance & Accounting Professionals

• Data Analysts

• Researchers

• Human Resource Professionals

• NGO & Development Practitioners

• Students & Graduates

• Consultants

• Business Professionals

• Anyone interested in Data Analytics and Business Intelligence

Join the WhatsApp Group:

https://chat.whatsapp.com/D9d8b8pJJl5CKPpt5SDXdt?mode=gi_t

Book Sale: The Pundit of Strategic Resource Mobilization

New Resource for Development Professionals: The Pundit of Strategic Resource Mobilization

The Pundit of Strategic Resource Mobilization: Connecting Vision to Resources for Greater Social and Humanitarian Impact

This practical guide supports NGOs, CSOs, programme managers, fundraising professionals, and development practitioners to strengthen their ability to:

✅ Build effective resource mobilization strategies

✅ Identify and engage strategic donors and partners

✅ Develop stronger funding proposals

✅ Navigate the changing development financing landscape

✅ Transform ideas into sustainable impact

Drawing from over 13 years of experience in development, humanitarian, conservation, and partnership leadership across Africa, this book captures practical lessons from real-world fundraising and institutional engagement.

📚 Get your copy today

💰 ZMW 500 per copy (350 Soft Copy)

📩 [esakala64@gmail.com]

📱 +260 961 984650 | +260 976 699057 (Both lines are on WhatsApp)

Let’s move beyond fundraising to building strategic investments for lasting social impact.

#ResourceMobilization #Fundraising #NGOLeadership #Development #Partnerships #SocialImpact #Africa