VENUE: JUBEK WOMEN UNION, Hai Neem, behind UAP Towers in Juba
HOW TO STUDY: Face to face with facilitator in Juba using projector and online assistance (pdf notes, videos, mp3 audios, online chat, SEMINAR and assignments).
Course Fee: USD 100 (payable in our bank account or cash)
**DATES: Wednesday 18th - Friday 20th September 2019
PROGRAM OF STUDY/TRAINING
Morning: 8am to 5pm
Weekends: Saturday (8am to 5pm) and Sunday (11am to 5pm)
Certificate: YES
Course Objectives
• To teach participants the advanced formulas, how to use which formula, editing of formulas and advanced data analysis
• To equip learners with data management knowledge, analysis of qualitative and quantitative statistics and reporting
• To elaborate on research process, data collection methods and making inferences
Advanced EXCEL: Course Outline
i. Introduction to sampling and data collection
ii. Entering data in excel sheets
iii. Preparing Data for Analysis
iv. Methods of Summarizing Data
v. Excel Statistic Functions (addition, multiplication, division, percentage, subtraction)
vi. Descriptive Statistics using Excel (mean, standard deviation, mode, variance etc)
vii. Inferential Statistics using Excel (hypothesis testing, covariace, ANOVA etc)
viii. Advanced Excel formulars (ranking, sumif,count,countA etc)
ix) Reporting
x) Charts e.g. graphs, pivot tables, piecharts, linesparks,historgram etc
xi) Protecting worksheets, workbooks, linking sheets,hiding cells/sheets etc
HOW TO APPLY
Download this form, fill and send to us immediately
Helites College Application Form.doc (69.5 KB)
Send it to: [email protected]
WHATSAPP US OR CALL: +254 717 593 312
IF NOT SUCCESSFUL
Come at Jubek Women Union on the training day and meet the trainers.
DISCOUNTS IS GIVEN FOR LARGE GROUPS OF FIVE STUDENTS