1. Introduction

HANDICAP INTERNATIONAL FEDERATION (HI), operating under the name Humanity & Inclusion a not-for-profit association governed by the French Act of July, 1^st, 1901, domiciled at “138, avenue des Frères Lumière – 69371 Lyon cedex 08, France” and registered in Rwanda under RGB with the registration number TIN No 100600244, Kicukiro sector, Kicukiro District, Ville de Kigali, P.O. Box 747 KIGALI.

2. Preamble

Similar Jobs in Rwanda
Learn more about Federation Handicap International (HI)
Federation Handicap International (HI) jobs in Rwanda

• HI is an independent international aid organization working in situations of poverty and exclusion, conflict and disaster,
• HI works alongside persons with disabilities and vulnerable persons; its action and testimony are focused on responding to their essential needs, their living conditions,
• HI is committed to promoting the respect of their dignity and their fundamental rights
• To that end, HI retains service providers who are reputed for their skills in their field of activity,
• HI and the Service provider have agreed to work together in a working relationship devoid of any form of hierarchical subordination. 

We kindly request you to submit your application for Training on Advanced Microsoft Excel. 

Applications may be submitted on or before 19^th November 2023 at 5:00 pm to the following email address: dao@rwanda.hi.org.

It shall remain your responsibility to ensure that your quotation will reach the address above on or before the deadline.

Applications that are received by Humanity Inclusion after the deadline indicated above, for whatever reason, shall not be considered for evaluation. If you are submitting your quotation by email, kindly ensure that they are signed and in the .pdf format, and free from any virus or corrupted files.

Please take note of the following requirements and conditions pertaining to providing the abovementioned service. 

3. Objective of the training

The objective of this training is to strengthen the technical capacity of the staff in data analysis and financial reporting techniques using Microsoft Excel.

The proposed training should cover the following eight topics: 

1. Advanced Excel Keyboard shortcuts, including:

• Ribbon navigation.
• Navigating & and formatting cells, columns, and rows.
• Pivot keyboard shortcuts.
• Function keys.
• Data conversion.
• Other frequently used shortcuts.
• Advanced Copy/Paste Special commands.

2. Advanced data Sorting optionse., case-sensitive sorting, cell color & and font color sorting, sorting based on condition formatting, & and the custom sorting list.
3. Advanced formatting techniques (including but not limited to)

• Transformation of text to columns
• Group, ungroup, and subtotals
• Advanced filtering to extract unique lists, filtering using criteria & wildcard characters.
• Conditional formatting
• Data Validation
• Lock cells, protect sheets and workbooks
• Absolute, Relative & Mixed Cell Referencing 

4. Advanced Formulas and Functions (Nested functions), including;

• IF, AND NOT & OR.
• ROUNDDOWN, ROUNDUP, ROUND.
• SUBTOTAL.
• SUMIFS & SUMPRODUCT
• COUNT, COUNTIFS.
• AVERAGE, AVERAGEIFS.
• LEN. h) LEFT, RIGHT, MID.
• NOW, TODAY, TIME, DATEDIF, MONTH, DAY, WEEKDAY, YEAR.
• INDEX, MATCH.
• VLOOKUP, HLOOKUP, and XLOOKUP.

5. Formula Auditing & Evaluation – to enable proofreading & and understanding of parts of a formula.
6. Trace precedents and dependents.
7. What If Analysis tools (Goal Seek, Scenario Manager & Data tables)
8. Advanced Data Analysis and Visualization:

• Analyzing data using Pivot Tables.
• Using slicers to filter data through pivot tables.
• Charts, Graphs & Visualizations in Excel.
• Linking Excel sheets and workbooks.

4. Approach, and Methodology 

The Service Provider(s) / Consulting Firm will be required to develop sessions based on this RFQ. The services to be provided by the Service Provider(s) / Consulting Firm will include, but not be limited to the following:

• Development of a Workshop approach, annotated agenda, and materials.
• Entry meeting with HI team to present the training package
• Facilitating the training at an established venue.
• Prepare and refine minutes of the Training as required to ensure these accurately reflect the actual training exercise
• Provide recommendations and document lessons learned and best practices
• Provide training materials and certificates 

5. Requirements for Experience and Qualifications

• Master’s degree in advanced computing or information technology or a related field
• Solid professional experience of at least 5 (five) years in Excel capacity building, data management
• Expertise in teaching advanced Excel
• Proven experience in training organizational agents
• Good knowledge of adult training
• Excellent proficiency in both French and English.
• Flexibility and ability to adjust to change circumstances and needs.

6. Documents to be included when submitting the proposals

Interested service providers (individuals or companies) are invited to submit their technical and financial proposals for this assignment. The technical proposal shall include:

• The CV of the candidate;
• A proposed methodology for how the training program will be developed, how the lessons will be planned and delivered
• Certification or documentation indicating the applicant’s teaching skills;
• Any other information that the Consultant finds relevant
• Registration certificate ( RDB or RGB) if applicable
• Tax clearance for RRA and RSSB if applicable
• Payment by EBM if applicable
• Good completion certificates (3) for similar training in NGOs, Government institutions
• Payment conditions
• Validity of the offer
• Bank details (Account name, account number and bank name)
• Signed Declaration of acknowledgment of policies, ethics and adhesion to the HI code of conduct.

7. Eligibility

In order to be considered for award, firm/individual must be currently legally operating in Rwanda and able to do the training in both French and English.

8. Financial Proposal

Give us your financial proposal either per hour, Module or level depending on how you charge.

9. Evaluation criteria

HI will award a contract resulting from this solicitation to the responsible firm/individual whose proposal will be the best value for HI, price, and other factors considered. The following factors shall be used to evaluate offers:

• Expertise and experience in undertaking the service delivery to meet the HI ’s requirements.
• Administrative evaluation.
• Financial evaluation.
• Ability to do the training in both English and French languages.

10. Terms and Conditions

Disclaimers

• HI reserves the right to modify by written notice the terms of this solicitation at any time in its sole discretion. HI may cancel the solicitation at any time.
• HI may reject any or all proposals received.
• Issuance of solicitation does not constitute award commitment by HI.
• HI reserves the right to disqualify any proposal based on company/individual’s failure to follow solicitation instructions.
• HI will not compensate companies for their response to the solicitation.
• HI reserves the right to issue an award based on initial evaluation of applications without further discussion.
• HI may contact companies/individuals to confirm the contact person, address, and that the proposal was submitted for this solicitation.
• HI may contact listed past performance references without notice to the companies/ individuals. HI also reserves the right to contact other past performance information sources that the companies/ individuals did not list in the proposal.
• By submitting a proposal, the companies/ individual confirms he/she understand the terms and conditions.
• Information pertaining to and obtained from the companies/ individuals as a result of participation in this solicitation is confidential. The companies/ individuals consent to the disclosure of the documents submitted by them to the reviewers involved in the selection process. Please note that all reviewers are bound by non-disclosure agreements.

 11. Submission Instructions

The applications must be prepared in English and received at the address specified below by 19^th November 2023 at 5:00 pm, Rwanda Standard Time and please make sure that the submission is titled with the exact same solicitation reference number stated above.

Submissions must be forwarded in electronic format only in PDF to dao@rwanda.hi.org . Companies/individuals must not submit zipped files. Those pages requiring original manual signatures should be scanned and sent in PDF format as an email attachment. Please reference the RFQ Number and RFQ Name in the e-mail subject line.

Thank you and we look forward to receiving your proposal. 

Mélanie GEISER

Country manager