RFQ NO: 422 AM (24/25)
1. Executive Summary
SayPro hereby submits this proposal in response to the Request for a Service Provider to provide Advanced Microsoft Excel Training for six (6) officials from the Department of Forestry, Fisheries and the Environment (DFFE). SayPro is a recognized leader in professional skills development, offering certified training solutions aligned with South African government standards and global best practices. This training will empower officials with advanced Excel capabilities, enabling them to perform complex data analysis, reporting, modeling, and automation tasks efficiently.
2. Company Profile
SayPro is an accredited training provider offering a wide range of professional development programmes. We have delivered training to public and private entities across South Africa, focusing on digital literacy, project management, leadership, compliance, and more.
3. Understanding of the Requirement
The Department requires a focused Advanced Microsoft Excel training programme for six (6) officials to improve their data management, reporting, and analytical skills. The officials are expected to work with large datasets, perform financial and statistical analysis, and create automated tools for departmental operations.
4. Proposed Training Objectives
The primary objectives of the training are to:
- Equip participants with advanced Excel knowledge and techniques.
- Enhance data analysis, visualization, and reporting skills.
- Improve efficiency through automation using formulas, functions, pivot tables, and macros.
- Empower officials to support evidence-based decision-making using Excel tools.
5. Target Audience
- Six (6) officials from DFFE with intermediate Excel knowledge.
- Participants who require upskilling to use Excel for technical, environmental, or financial reporting.
6. Training Methodology
Our approach to training includes:
- Pre-training assessment to gauge participants’ current skill levels.
- Interactive workshops with hands-on exercises using real-world datasets.
- Blended learning delivery: In-person or online via MS Teams/Zoom, based on DFFE preference.
- Post-training evaluation and feedback report.
- Certificates of Completion provided to each participant.
7. Course Outline (Advanced Microsoft Excel)
| Module | Topics Covered |
|---|---|
| Module 1: Advanced Formulas & Functions | IFs, VLOOKUP, INDEX/MATCH, nested formulas, error handling |
| Module 2: Data Analysis Tools | Pivot Tables, Pivot Charts, Slicers, Grouping |
| Module 3: Data Visualization | Conditional formatting, chart creation, dashboards |
| Module 4: Data Management Techniques | Data validation, protection, named ranges, what-if analysis |
| Module 5: Automation with Macros | Recording macros, VBA introduction, automating repetitive tasks |
| Module 6: Power Query and Power Pivot | Data transformation and modeling |
| Module 7: Scenario & Goal Seek Analysis | Solver, goal seek, scenario manager |
| Module 8: Reporting & Collaboration | Creating professional reports, collaboration using shared workbooks |
8. Training Duration and Delivery Mode
- Duration: 3 days (21 hours)
- Mode: Face-to-face OR Online (depending on DFFE’s preference)
- Location: To be hosted at DFFE offices or a SayPro venue in Pretoria/Cape Town OR virtually.
9. Facilitator Profile
SayPro will deploy a Microsoft Certified Trainer (MCT) with:
- Over 8 years’ experience in Excel training.
- Expertise in training public sector professionals.
- Proven track record of delivering advanced Excel and data analytics training.
CVs of proposed facilitators will be shared upon request.
10. Assessment and Certification
- Formative assessments will be done through practical exercises.
- A post-training test will be conducted.
- Participants will receive SayPro Certificates of Completion and Assessment Reports.
11. Deliverables
- Advanced Excel training for 6 officials.
- Training material and manuals (soft copies and printed).
- Attendance register.
- Pre- and post-assessment reports.
- Certificates of completion.
- Training report summarizing outcomes and recommendations.
12. Pricing Schedule
| Item | Description | Quantity | Unit Price | Total |
|---|---|---|---|---|
| 1 | Training Fee (per person) | 6 | R 2,850.00 | R 17,100.00 |
| 2 | Training Manuals | 6 | Included | R 0.00 |
| 3 | Certificates | 6 | Included | R 0.00 |
| 4 | Final Report | 1 | Included | R 0.00 |
| Total (Excl. VAT) | R 17,100.00 | |||
| VAT (15%) | R 2,565.00 | |||
| Total (Incl. VAT) | R 19,665.00 |
Note: Costs are inclusive of facilitation, materials, assessments, admin, and reporting.
13. B-BBEE & Compliance Documentation
SayPro is a Level 1 B-BBEE Contributor and complies with all legislative requirements. We will attach the following documents:
- Valid B-BBEE Certificate
- Company Registration Documents (CIPC)
- Tax Clearance Certificate (Pin)
- Bank Confirmation Letter
- CVs of Facilitators
- Company Profile
- References and Past Experience
14. Conclusion
SayPro is confident in its ability to deliver a high-impact, advanced Microsoft Excel training programme tailored for the Department of Forestry, Fisheries and the Environment. We are committed to capacity building and digital empowerment within the public sector.
Leave a Reply