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
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.
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.