Microsoft excel is a powerful spreadsheet that is easy to use and allows you to store, manipulate, analyse and visualize data. It also supports data bases, graphic and presentation features. It is a powerful research tool that needs minimum of teaching. It not only makes statistics enjoyable, it also brings live to numerical work.

This course gives practical experience in the use of Microsoft Excel for data summary, presentation and for other basic statistical work. It concentrates on areas where Excel really can excel, such as array functions. We look at data entry and management, pivot tables, and graphics

DURATION

3 days.

WHO SHOULD ATTEND

Practitioners in the area of Agriculture extension who include: NGO extension workers, National and County government employers from various ministries and departments and government authorities directly and indirectly involved in Agriculture extension work, Policy makers and officials from the private sector and farmers amongst others.

COURSE OBJECTIVES

Upon completion of the course, participants will be able to turn their general Excel capabilities into skills in the use of Excel for data processing and basic statistical applications.

TOPICS TO BE COVERED

Structured tables
Data entry and validation
Learning formula fundamentals
Creating formulas and their automatic application
Using references & named ranges
Using special text functions for Agriculture extension related applications
Using logical functions to get desirable results
Using pivot table and charts
Create a PivotTable Framework
Good statistical graphics
Conditional operations and array functions
Data summary and analysis; pros and cons of the Analysis Toolpak
Lookup function for Agriculture extension usage
Protecting your data forms from invalid data entry
Recording MACROS & automating Work
Hiding and protecting formulas

Visit our website for more details.

How to participate

Tailor make your course.
Register as an individual.
Register as a group.
Become one of our partners.
Purchase software’s
Frequently Asked Questions (FAQ’s)

View related courses

Advanced Servers for ODK (Local and Cloud Installation) Course
Agriculture, Innovation, and Technology Course
Basic Skills in Javascript, CSS, HTML Course
Cost-Benefit Analysis Using Microsoft Excel Course
Introduction to VBA Programming Course

The most popular courses

Crop Biotechnology Course
Health Education and Promotion Course
Designing and Conducting Surveys for M&E Course
Implementation of ICT in Education with Moodle Course
Human Rights Leadership Development
GIS and Remote Sensing in Mining and Exploration Course
Negotiation Skills for Support Officers Course

View course catalogue in ICT4D and Mobile Technologies Institute

For any registration of 3 or more participants, we offer a discount of up to 25%.

Click here now to register

For further inquiries email [email protected] or contact us on Tel: +254 715 077 817,

+254 731240802

ACCOMMODATION

Accommodation is arranged upon request. For reservations contact the Training Officer Email:[email protected]. Mob: +254 715 077 817

PAYMENT

Payment should be transferred to IRES account through bank on or before C.O.B.11th June 2018

Send proof of payment to [email protected]

Reviews

Be the first to write a review about this course.

Write a Review

Indepth Research Services (IRES) is a global institutional capacity building, technical and management consultancy firm with its head office in Nairobi, Kenya.

IRES offers technical and management consultancy services as well as education and training services designed for individuals’ and groups from organizations working in public, not for profit and private sectors.

IRES Kenya has identified itself with a niche market that largely comprises of Government ministries, departments and agencies (MDA’s) and UN agencies, Non-Governmental Organizations, from Africa, Europe, Asia, Middle-East and the Caribbean. We have also served academic institutions, international research organizations, financial institutions and private companies from across the globe. As at 2018 we offer our services in more than 15 locations globally.

Our technical and management consultancy services are in the areas of Agriculture, Education, Energy, Oil and gas, Health, Environment and natural resources, ICT for development, spatial planning, Governance, Management and leadership, communication, transport, revenue management, marketing development and environment among others.
Our education and training services are aimed helping individuals improve their professional knowledge, competence, skill, and effectiveness and enable the institutions to get the best out of their workforce. This is achieved through conducting high impact professional diploma and certificate courses, short courses, conferences, workshops and seminars. ...

View Complete Profile

Agriculture Educational Technology Database & Information Systems