
September Master Classes (1. The Consultancy Blueprint Master Class) (2. Advanced Resource Mobilization & Technical Grant Writing Masterclass) (Master Class 3. Data Analytics using Excel and Power Bi)(4. Book Sale)- Click Ad for registration details
Oro STAR Consultancy ServicesRemote / Unspecifiedformal/ professionalK0
Posted: 8/4/2026 • Closes: 9/3/2026
Job Description
September Master Classes for NGOs, SMEs, Individuals, Students and Corporates1. Master Class 1: The Consultancy Blueprint Master Class2. Master Class 2: Advanced Resource Mobilization & Technical Grant Writing Masterclass3. Master Class 3: Data Analytics using Excel and Power Bi 4. Book Sale: The Pundit of Strategic Resource MobilizationMaster Class 1: The Consultancy Blueprint Master ClassFrom Expert to Highly Paid ConsultantMaster Consulting, Win Contracts, Deliver Excellence & Build a Thriving Consulting Business.Course OverviewThis 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 participantTarget AudienceThis 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 1Becoming a Professional ConsultantWhat consulting really isTypes of consultantsDevelopment vs Corporate consultingIndependent vs Firm consultingEthics of consultingInternational consulting standardsCompetencies of successful consultantsModule 2Finding Consulting OpportunitiesUnderstanding the consulting marketUN consulting opportunitiesNGO consulting opportunitiesGovernment consultingCorporate consultingDevelopmentAidUNGMDevexReliefWebLinkedInConsultancy databasesBuilding opportunity pipelinesModule 3Building Your Consulting BrandDeveloping your nichePositioning yourself as an expertBuilding a consulting CVConsulting capability statementProfessional biographyPersonal brandingLinkedIn optimizationProfessional networkingModule 4Winning Consultancy AssignmentsUnderstandingExpressions of Interest (EOIs)Terms of Reference (TORs)Requests for Proposals (RFPs)Invitations to BidConsultancy evaluationsPreparingTechnical proposalsFinancial proposalsMethodologiesWork plansRisk management plansTeam compositionCommon proposal mistakesProposal evaluation criteriaModule 5Consultancy PricingDaily ratesInternational consulting ratesNGO consulting ratesUN consultancy ratesPricing modelsNegotiationFinancial sustainabilityModule 6Consultancy Project ManagementInception meetingsStakeholder engagementWorkplansDeliverablesQuality assuranceCommunicationRiskTimeModule 7Research & Consultancy MethodsNeeds assessmentsOrganizational assessmentsEvaluationsBaselinesEndlinesSurveysInterviewsFGDsKIIsData collectionReport writingModule 8Stakeholder EngagementWorking withGovernmentsNGOsUN AgenciesBoardsCommunitiesDonorsDevelopment PartnersManaging difficult clientsConflict resolutionProfessional communicationModule 9Writing Consultancy ReportsInception reportsProgress reportsEvaluation reportsStrategic plansPoliciesResearch reportsBoard papersPresentationsModule 10Strategy ConsultingStrategic PlansTheory of ChangeResults FrameworksBusiness PlansSustainability PlansResource Mobilization StrategiesModule 11Financial & Legal AspectsConsultancy contractsIntellectual propertyConfidentialityTax obligationsRecord keepingInvoicingProcurement rulesAnti-corruptionModule 12Building a Sustainable Consulting BusinessRegistering a consulting firmBusiness modelsMarketingProposal pipelinesStrategic partnershipsRepeat businessReferralsScaling internationallyPractical SessionsParticipants will develop:Professional Consulting CVCapability StatementLinkedIn ProfileTechnical ProposalFinancial ProposalConsulting MethodologyConsultancy BudgetInception ReportFinal Consultancy ReportPitch PresentationConsulting Business PlanCourse OutcomesBy 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 ProfileLinkedIn: 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_iosJoin via: https://chat.whatsapp.com/BVeRwYmzJzI2KOKWEcTfvd?mode=gi_tMaster Class 2Advanced Resource Mobilization & Technical Grants Writing MasterclassCourse OverviewThis 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 participantModule 1: Organizational Portfolio Review & Sustainability Analysis (3 Days)Organizational Environmental Scan for Sustainability· Internal and external analysis· Risk and opportunity mappingUnderstanding the Funding Gap· Current resource flows vs. organizational needs· Programmatic and operational funding shortfallsPackaging Pathways to Close the Funding Gap· Strategic positioning of programs· Aligning mission, impact, and financing optionsAdapting to the Current Donor Environment· Trends in global and in-country donor priorities· Shifts from traditional aid to catalytic financingThe Fundraising Survey (In-Country and Global)· Mapping donor interests and funding cycles· Using data to inform resource mobilization strategiesModule 2: Blended and Innovative FinancePublic–Private–Nonprofit Partnerships· Partnership models and value propositions· Risk-sharing and co-financing approachesThe Green Bonds Market as an Instrument for Organizational Resilience· Overview of green bonds· Opportunities for nonprofits and social enterprisesEndowment Funds· Establishment, governance, and management· Role of endowments in long-term sustainabilityThe Funding Mix· Diversifying revenue streams· Balancing grants, earned income, and innovative financeModule 3: Donor Engagement & Technical WritingFundraising Events· Strategic planning and return on investment· Donor cultivation through eventsDonor Communication· Messaging, storytelling, and relationship management· Reporting for trust and retentionPitch Decks and Other Organizational Collateral· Developing compelling pitch decks· Key materials for donor engagementProgram Design for Additionality, Accountability, and Transparency· Results-based design· Monitoring, evaluation, and learning considerationsModule 4: Technical Grant Writing· Concept Notes: 8-step structured approach· Program Proposals: 13-step development framework· Practical writing, review, and refinementAbout the TrainerLinkedIn: 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_iosJoin via: https://chat.whatsapp.com/HMOjcdSSn8qLkyXbWbK3xE?mode=gi_tMaster Class 3Data Analytics using Excel & Power BICourse OverviewThis 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 ExcelData Entry & Data Cleaning• Data formatting and organization• Text-to-Columns• Remove Duplicates• Data Validation• Handling missing and inconsistent dataExcel Formulas & Functions• SUM, AVERAGE, COUNT• IF, IFS, AND, OR• VLOOKUP, HLOOKUP• INDEX & MATCH• XLOOKUP• Text Functions• Date & Time Functions• Logical and Lookup FunctionsExcel Tables & Named Ranges• Creating Excel Tables• Structured References• Named Ranges• Dynamic Data Ranges• Best practices for managing datasetsModule 2: Intermediate Data AnalysisSorting & Filtering• Multi-level Sorting• Custom Sorting• Advanced Filtering• Dynamic FiltersConditional Formatting• Highlighting trends• Data bars and colour scales• Identifying duplicates• Detecting anomalies and thresholdsPivotTables & PivotCharts• Building PivotTables• Grouping data• Calculated Fields• Interactive PivotCharts• Dashboard-ready summariesStatistical Analysis• Descriptive Statistics• Correlation Analysis• Regression Basics• Z-Scores• Hypothesis Testing• Data interpretationModule 3: Microsoft Power BIIntroduction to Data Analytics• Data-driven decision making• Business Intelligence concepts• Data analytics lifecycle• Analytical thinkingGetting Started with Power BI• Power BI Desktop interface• Connecting to Excel, CSV, SQL and other data sources• Importing and managing datasets• Building your first reportData Cleaning, Transformation & Loading• Power Query Editor• Cleaning messy datasets• Handling missing values• Data transformation techniques• Merge and Append Queries• Data profilingDesigning Effective Data Models• Table relationships• Star Schema Design• Snowflake Schema• Normalization vs. Denormalization• Data modelling best practicesDAX (Data Analysis Expressions)• Calculated Columns• Measures• CALCULATE()• SUMX()• RELATED()• FILTER()• Time Intelligence Functions• Building reusable calculationsPerformance Optimization• Query Folding• Aggregations• Model Optimization• Reducing redundancy• Improving report performanceInteractive 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 CollaborationModule 4: Advanced Microsoft ExcelData Analysis ToolPak• Regression Analysis• ANOVA• t-Tests• Chi-Square Tests• ForecastingWhat-If Analysis• Goal Seek• Scenario Manager• Data Tables• Sensitivity AnalysisAdvanced Data Visualization• Bar Charts• Line Charts• Scatter Plots• Combo Charts• Sparklines• Dynamic Charts• Dashboard Design PrinciplesPower Query (Get & Transform)• Importing data from multiple sources• Cleaning datasets• Shaping data• Merging Queries• Appending Queries• Refresh AutomationPower Pivot• Building Data Models• Table Relationships• DAX Fundamentals• CALCULATE()• SUMX()• RELATED()• Creating scalable analytical modelsLearning OutcomesBy 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 IntelligenceJoin the WhatsApp Group:https://chat.whatsapp.com/D9d8b8pJJl5CKPpt5SDXdt?mode=gi_tBook Sale: The Pundit of Strategic Resource MobilizationNew Resource for Development Professionals: The Pundit of Strategic Resource MobilizationThe Pundit of Strategic Resource Mobilization: Connecting Vision to Resources for Greater Social and Humanitarian ImpactThis 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 impactDrawing 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
About the Role
- Category-
- Positions1
- ContactApply via app
More Active Jobs
Director Risk & Control
Standard Chartered
Lusaka, Zambia
Analyst – Problem Bank Management and Resolution
Bank of Zambia
Lusaka, Zambia
Deli Assistant
Choppies Zambia
Solwezi, Zambia
Supply Chain Specialist
Equpoint Properties Ltd
Lusaka
Zambia MEL Senior Specialist (Fixed-term)
One Acre Fund
Kabwe, Zambia