Expired Tender Rwanda ICB TOT Ref. 93611037

Training on Advanced Microsoft Excel Tender in Rwanda - 93611037

Tender notice from Rwanda, published on 13 Dec 2023.

Executive Summary

The FEDERATION HANDICAP INTERNATIONAL (HI) has issued a Tender notice for the procurement of a Training on Advanced Microsoft Excel for Efficiency in the Rwanda. This Tender notice was published on 13 Dec 2023 and is scheduled to close on 31 Dec 2023, with an estimated Tender value of Refer Document. Interested bidders can access detailed Tender information, eligibility criteria, and complete bidding documents by referencing TOT Ref No. 93611037, while the tender notice number is RFQ/2023/13 (Re advert) and Register on the platform.

Key facts

Summary
Training on Advanced Microsoft Excel for Efficiency
TOT Ref. No.
93611037
Document Ref. No.
RFQ/2023/13 (Re advert)
Country
Rwanda
Notice type
Tender
Competition
ICB
Publication date
13 Dec 2023
Bid deadline
31 Dec 2023
EMD
Refer Document
Tender value
Refer Document
Purchaser ownership
Public
Financier
Self Financed

Purchaser details

Purchaser contact is for registered users

Login to see details

Tender details

Quotation are invited for Training on Advanced Microsoft Excel for Efficiency
HANDICAP INTERNATIONAL FEDERATION (HI), operating under the name Humanity & Inclusion a not-for-profit association governed by the French Act of July, 1st, 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.
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:
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.

Advanced data Sorting options case-sensitive sorting, cell color & and font color sorting, sorting based on condition formatting, & and the custom sorting list.

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

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.

Formula Auditing & Evaluation - to enable proofreading & and understanding of parts of a formula.

Trace precedents and dependents.

What If Analysis tools (Goal Seek, Scenario Manager & Data tables)

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.
Location: Kigali
Deadline: Sunday, 31/12/2023 17:00

Documents

Tender Notice
Login to view

Rwanda Public Procurement Intelligence

Frequently asked questions

The bid deadline for Training on Advanced Microsoft Excel for Efficiency was 31 Dec 2023. Bidding is closed.

This tender has been issued by FEDERATION HANDICAP INTERNATIONAL (HI) in Rwanda.

The tender value is not disclosed; please refer to the tender document. EMD / bid security details are provided in the tender document.

This tender is Self Financed

The tender notice and related documents are listed in the Documents section above. Select a document to view or download it. Please log in or register to access the documents. If you cannot find additional documents in the Documents section, please log in to your account and Send Document Request from your account section.

The TendersOnTime reference is 93611037. The purchaser document reference is RFQ/2023/13 (Re advert).

Browse other tenders from Rwanda or search by relevant keywords and CPV classification.