Basic Excel Materials: Perbedaan revisi
| Baris 27: | Baris 27: | ||
<h2>Trainer Materials</h2> | <h2>Trainer Materials</h2> | ||
| + | |||
<h3>Intermediate Excel</h3> | <h3>Intermediate Excel</h3> | ||
| + | |||
| + | <h4>Powerpoints</h4> | ||
| + | |||
| + | *[[Media:Intermediate_Excel_CHARTS1_IND.pptx|Intermediate Excel_CHARTS1_IND.pptx]] | ||
| + | *[[Media:Intermediate_Excel_CHARTS2_IND.pptx|Intermediate Excel_CHARTS2_IND.pptx]] | ||
| + | *[[Media:Intermediate_Excel_CHARTS3_IND.pptx|Intermediate Excel_CHARTS3_IND.pptx]] | ||
| + | *[[Media:Intermediate_Excel_Formulae_IND.pptx|Intermediate_Excel_Formulae_IND.pptx]] | ||
| + | |||
| + | <h4>Handouts</h4> | ||
*[[Media:Evaluating a worksheet|Evaluating a worksheet]] | *[[Media:Evaluating a worksheet|Evaluating a worksheet]] | ||
*[[Media:Data-analysis-HOMEWORK-exercise.pptx|Data-analysis-HOMEWORK-exercise.pptx]] | *[[Media:Data-analysis-HOMEWORK-exercise.pptx|Data-analysis-HOMEWORK-exercise.pptx]] | ||
| + | *[[Media:Which chart to use.pdf|Which chart to use.pdf]] | ||
| + | *[[Media:HANDOUT Intermediate_Excel_CHARTS1_IND.pdf|HANDOUT Intermediate Excel_CHARTS1_IND.pdf]] | ||
| + | *[[Media:HANDOUT Intermediate_Excel_CHARTS2_IND.pdf|HANDOUT Intermediate Excel_CHARTS2_IND.pdf]] | ||
| + | *[[Media:HANDOUT Intermediate_Excel_CHARTS3_IND.pdf|HANDOUT Intermediate Excel_CHARTS3_IND.pdf]] | ||
| + | *[[Media:HANDOUT Intermediate_Excel_Formulae_IND.pdf|HANDOUT intermediate_Excel_Formulae_IND.pdf]] | ||
| + | |||
| + | <h4>Spreadsheets</h4> | ||
| + | |||
*[[Media:Data-laporan-petugas-HOMEWORK.xls|Data-laporan-petugas-HOMEWORK.xls]] | *[[Media:Data-laporan-petugas-HOMEWORK.xls|Data-laporan-petugas-HOMEWORK.xls]] | ||
*[[Media:Data-laporan-petugas-DATA FILE FOR HOMEWORK.xls|Data-laporan-petugas-DATA FILE FOR HOMEWORK.xls]] | *[[Media:Data-laporan-petugas-DATA FILE FOR HOMEWORK.xls|Data-laporan-petugas-DATA FILE FOR HOMEWORK.xls]] | ||
| Baris 52: | Baris 70: | ||
*[[Media:faostatpivot.xlsx|faostatpivot.xlsx]] | *[[Media:faostatpivot.xlsx|faostatpivot.xlsx]] | ||
*[[Media:faostatpivot_ID.xlsx|faostatpivot_ID.xlsx]] | *[[Media:faostatpivot_ID.xlsx|faostatpivot_ID.xlsx]] | ||
| − | |||
<h3>Intermediate Excel</h3> | <h3>Intermediate Excel</h3> | ||
| − | *[[Media: | + | *[[Media:Which chart to use.pdf|Which chart to use.pdf]] |
| + | *[[Media:HANDOUT Intermediate_Excel_CHARTS1_IND.pdf|HANDOUT Intermediate Excel_CHARTS1_IND.pdf]] | ||
| + | *[[Media:HANDOUT Intermediate_Excel_CHARTS2_IND.pdf|HANDOUT Intermediate Excel_CHARTS2_IND.pdf]] | ||
| + | *[[Media:HANDOUT Intermediate_Excel_CHARTS3_IND.pdf|HANDOUT Intermediate Excel_CHARTS3_IND.pdf]] | ||
| + | *[[Media:HANDOUT Intermediate_Excel_Formulae_IND.pdf|HANDOUT Intermediate_Excel_Formulae_IND.pdf]] | ||
Revisi per 17 Juni 2014 13.39
Daftar isi
Trainer Materials
Basic Excel
Powerpoints
- 1. Data Management (Part1)
- 1. Data Management (Part2)
- 2. Basic Excel Skills (Part1)
- 2. Basic Excel Skills (Part2)
- 2. Basic Excel Skills (Part3)
- 3. Cleaning Messy Data (Part1)
- 3. Cleaning Messy Data (Part2)
- 4. Useful Outputs
Spreadsheets
- Contoh1.xlsx
- DAFF_AI_SERO_REVISED.xlsx
- AIpivotSERIES
Trainer Materials
Intermediate Excel
Powerpoints
- Intermediate Excel_CHARTS1_IND.pptx
- Intermediate Excel_CHARTS2_IND.pptx
- Intermediate Excel_CHARTS3_IND.pptx
- Intermediate_Excel_Formulae_IND.pptx
Handouts
- Evaluating a worksheet
- Data-analysis-HOMEWORK-exercise.pptx
- Which chart to use.pdf
- HANDOUT Intermediate Excel_CHARTS1_IND.pdf
- HANDOUT Intermediate Excel_CHARTS2_IND.pdf
- HANDOUT Intermediate Excel_CHARTS3_IND.pdf
- HANDOUT intermediate_Excel_Formulae_IND.pdf
Spreadsheets
- Data-laporan-petugas-HOMEWORK.xls
- Data-laporan-petugas-DATA FILE FOR HOMEWORK.xls
- ConditonalFormatexample-completed.xlsx
- GPSEx.xlsx
- GPS-example-completed.xlsx
Participant Materials
Basic Excel
Spreadsheets
- SCAN1.png
- SCAN2.png
- SCAN3.png
- SCAN4.png
- AIpivot.xlsx
- DAFF_AI_SERO.xlsx
- faostatindo.xlsx
- faostatpivot.xlsx
- faostatpivot_ID.xlsx
