Microsoft Excel For Agriculture Professionals Course..
Details
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.
MODULES
Module 1:
- Structured tables
- Data entry and validation
- Learning formula fundamentals
- Creating formulas and their automatic application
- Using references & named ranges
Module 2:
- Using special text functions for Agriculture extension-related applications
- Using logical functions to get desirable results
Module 3:
- Using pivot tables 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
Module 4:
- Lookup function for Agriculture extension usage
Module 5:
- Protecting your data forms from invalid data entry
- Recording MACROS & automating Work
Module 6:
- Linking several worksheets
- Combining several workbooks to create a summary
Module 7:
- Securing and reviewing your worksheet
- Tracking changes and comments
- Hiding and protecting formulas
Lesson 8:
- Mini Project and Recap
CERTIFICATION
- Upon successful completion of this training, participants will be issued with a Macskills Training and Development Institute Certificate
TRAINING VENUE
- Training will be held at Macskills Training Centre. We also tailor make the training upon request at different locations across the world.
AIRPORT PICK UP AND ACCOMMONDATION
- Airport pick up and accommodation is arranged upon request
TERMS OF PAYMENT
- Payment should be made to Macskills Development Institute bank account before the start of the training and receipts sent
Schedules
Weekdays | 09:00 AM — 04:00 PM |
Weekdays | 09:00 AM — 04:00 PM |
Weekdays | 09:00 AM — 04:00 PM |
Weekdays | 09:00 AM — 04:00 PM |
Weekdays | 09:00 AM — 04:00 PM |
Weekdays | 09:00 AM — 04:00 PM |
Weekdays | 09:00 AM — 04:00 PM |
Weekdays | 09:00 AM — 04:00 PM |
No. of Days: | 10 |
Macskills is committed to the promotion of Excellence and Integrity in the practice of management.We strive to improve the quality and accessibility of the training by creating an environment that ensures successful learning from start to finish. Choosing an institution that supports your needs and understands your goals can be a challenge.
Over the years Macskills has been pivotal and has organized trainings for key development partners inZimbabwe, Malawi, Botswana, Namibia and Ghana, Nigeria, Sierra Leone, LiberiaKenya, Uganda, Congo,Somalia, Tanzania, Burundi and Rwanda, Djibouti and Chad.