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