Afriex Development Institute

MICROSOFT EXCEL FOR AGRICULTURE PROFESSIONALS COURSE

INTRODUCTION

Microsoft Excel is a powerful spreadsheet that is easy to use and allows you to store, manipulate, analyze and visualize data. It also supports databases, graphics and presentation features. It is a powerful research tool that needs a minimum of teaching. It not only makes statistics enjoyable; it also brings life 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

10 days.

TARGET AUDIENCE

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, Policymakers and officials from the private sector and farmers amongst others

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

Lesson 1:

v  Structured tables

v  Data entry and validation

v  Learning formula fundamentals

v  Creating formulas and their automatic application

v  Using references & named ranges

Lesson 2:

v  Using special text functions for Agriculture extension-related applications

v  Using logical functions to get desirable results

Lesson 3:

v  Using pivot tables and charts

v  Create a PivotTable Framework

v  Good statistical graphics

v  Conditional operations and array functions

v  Data summary and analysis; pros and cons of the Analysis Toolpak

Lesson 4:

v  Lookup function for Agriculture extension usage

Lesson 5:

v  Protecting your data forms from invalid data entry

v  Recording MACROS & automating Work

Lesson 6:

v  Linking several worksheets

v  Combining several workbooks to create a summary

Lesson 7:

v  Securing and reviewing your worksheet

v  Tracking changes and comments

v  Hiding and protecting formulas

Lesson 8:

v  Mini Project and Recap

REQUIREMENTS

Participants should be reasonably proficient in English. Applicants must live up to Afriex Training Ltd admission criteria.

METHODOLOGY

This course will utilize a variety of proven adult learning techniques to ensure maximum understanding, comprehension and retention of the information presented

TRAINING VENUE, LOGISTICS AND PAYMENT

v  Training is residential and will be held at Afriex Training Centre.

v  The course fee covers the course tuition, training materials, two break refreshments, lunch, and study visits.

v  Accommodation and airport transfer are arranged upon request by the participant.

v  This training can also be tailor made for your institution upon request. You can have it delivered in our training Centre or at a convenient location.

v  For further inquiries, please contact us on training@afriextraining.org

v  Payment should be made to Afriex Training Limited bank account before the start of the training and receipts sent to training@afriextraining.org

v  Upon successful completion of this training, participants will be issued with an Afriex Training Ltd certificate.