Microsoft Excel for Agriculture Professional Course
Details
Event: Microsoft Excel for Agriculture Professional Course
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 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.
WHO SHOULD ATTEND
Practitioners in the area of Agriculture extension 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
Outline
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
Lesson 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
Module 8:
- Mini Project and Recap
Schedules
Weekdays | 08:00 AM — 05:00 PM |
Weekdays | 08:00 AM — 05:00 PM |
No. of Days: | 10 |
Total Hours: | 80 |
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. ...