Consultancy Services for the Provision of Advanced Excel Training Programme

• Country: Zimbabwe
• Summary: Consultancy Services for the Provision of Advanced Excel Training Programme
• ZWT Ref No: 16393304
• Deadline: 21 Sep 2017
• Financier: Other Funding Agencies
• Purchaser Ownership: -
• Tender Value: Refer Document
• Notice Type: Tender
• Document Ref. No.: ACBF/EOI/057/17/NRF
• Purchaser's Detail:

Purchaser : AFRICAN CAPACITY BUILDING FOUNDATION (ACBF)
2 Fairbairn Drive Mount Pleasant Harare Attn: Director, Finance and Administration Tel: (+263-4) 304663, 332002 Cell: +263 772 185 308 - 10
Email :tender@acbf-pact.org

• Description:
• Expression of Interest are invited for Consultancy Services for the Provision of Advanced Excel Training Programme. 1. PROJECT TITLE The African Capacity Building Foundation (ACBF) heavily relays on the availability and use of information and communication technologies (ICT) to support its strategic objectives and day to day operations. The Foundation uses the latest Microsoft Office productivity tool, Office365 cloud, with installed Microsoft Excel 2016 application. We aim to equip our staff in Finance with expert know-how on the use of advanced data analysis, formulas and other data manipulation, analytical and presentation features within the Microsoft Excel 2016. Accordingly, the Foundation seeks the service of an accredited Microsoft Excel 2016 training providers to conduct advanced capacity building training for at least 15 staff members over a period of 1 day. The training shall be conducted at the ACBF premises in Harare, Zimbabwe. 2. OBJECTIVES OF THE ASSIGNMENT The objective of this training programme is to acquire new knowledge and capacity to efficiently utilize the advanced data manipulation, statistical and analytical and information presentation features in Microsoft Excel 2016. Among others, the training programme shall cover the following areas or topics: · Use of advanced formulas for data manipulation, statistical and analytical purpose such as Financial, Logical, Lookup & Reference, and Math & trigonometry, statistical forecasting, as well as troubleshooting invalid data and formula errors; · Use of Financial Analysis functions such as VLOOKUP, HLOOKUP, CHOOSE, Index, match, dynamic totals, IF with AND / OR, OFFSET, CELL, COUNTA and MID functions; · Use of advanced features, Pivottable, PivotChart, & Analysis ToolPak add-ins; · User of advanced charts, such as column, line, stacked, waterfall, doughnut and pie series, gauge chart & combined charts; · Importing and working on external data, including Text & CSV data, data validation, grouping, consolidation, use of PowerPivot and Power Query add-in; · Application of Macros in Excel, such as Recording, troubleshooting and executing macros; · Special Formatting, e.g. Conditional Formatting, Formatting with sections and grouping. 3. SCOPE OF PROJECT The training programme includes the following key duties and responsibilities, these are: · Develop a customized training materials (manuals) in soft copies · Develop learning outcomes of the training · Provide a practical and engaging hands-on-training at ACBF premises · Pre/post training assessment of learners’ ability to use advanced Excel 2016 features and functions · Setup sample datasets and add-ins that are required for the training programme · Provide certificate to learners upon successful completion of the training The Foundation will provide a training room with wireless internet connectivity. Each participant will have a laptop running Microsoft Windows 7 operating system or later with Microsoft Excel 2016 professional. 4. BIDDERS’ QUALIFICATION REQUIREMENTS To be considered as a responsive bidder, the prospective training service provider must meet the following minimum criteria: · A registered and accredited firm with a valid commercial license to provide IT trainings; · A firm with at least three years of experience in conducting advanced Excel training; · The proposed trainer to conduct the training must be a Microsoft certified trainer for Excel 2016. · Experience working with international and regional organizations on similar assignment is an added advantage.
• Documents:

 Tender Notice