Basic Excel Materials: Perbedaan revisi
(25 revisi antara oleh pengguna yang sama tidak ditampilkan) | |||
Baris 1: | Baris 1: | ||
− | <h2> | + | <h2>Trainer Materials</h2> |
+ | |||
<h3>Basic Excel</h3> | <h3>Basic Excel</h3> | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | <h2> | + | <h4>Powerpoints</h4> |
+ | |||
+ | *[[Media:1-Data-Management_Prinsip-Pengelolaan-data-part1.pptx|1. Data Management (Part1)]] | ||
+ | *[[Media:1-Data-Management_Prinsip-Pengelolaan-data-part2.pptx|1. Data Management (Part2)]] | ||
+ | *[[Media:2-Basic-Excel-skills_Keterampilan-dasar-excel-Part1.pptx|2. Basic Excel Skills (Part1)]] | ||
+ | *[[Media:2-Basic-Excel-skills_Keterampilan-dasar-excel-Part2.pptx|2. Basic Excel Skills (Part2)]] | ||
+ | *[[Media:2-Basic-Excel-skills_Keterampilan-dasar-excel-Part3.pptx|2. Basic Excel Skills (Part3)]] | ||
+ | *[[Media:3-Cleaning-Messy-Data_Merapikan-Data-yang-Berantakan-Part1.pptx|3. Cleaning Messy Data (Part1)]] | ||
+ | *[[Media:3-Cleaning-Messy-Data_Merapikan-Data-yang-Berantakan-Part2.pptx|3. Cleaning Messy Data (Part2)]] | ||
+ | *[[Media:4-Useful-Outputs_Menyiapkan-Keluaran.pptx|4. Useful Outputs]] | ||
+ | |||
+ | <h4>Spreadsheets</h4> | ||
+ | |||
+ | *[[Media:Contoh1.xlsx|Contoh1.xlsx]] | ||
+ | *[[Media:DAFF_AI_SERO_REVISED.xlsx|DAFF_AI_SERO_REVISED.xlsx]] | ||
+ | *AIpivotSERIES | ||
+ | **[[Media:AIpivot1.xlsx|AIpivot1.xlsx]] | ||
+ | **[[Media:AIpivot2.xlsx|AIpivot2.xlsx]] | ||
+ | **[[Media:AIpivot3.xlsx|AIpivot3.xlsx]] | ||
+ | **[[Media:AIpivot4.xlsx|AIpivot4.xlsx]] | ||
+ | **[[Media:AIpivot5.xlsx|AIpivot5.xlsx]] | ||
+ | **[[Media:AIpivot6.xlsx|AIpivot6.xlsx]] | ||
+ | |||
+ | <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]] | ||
+ | *[[Media:Data analysis HOMEWORK exercise.pptx|Data analysis HOMEWORK exercise.pptx]] | ||
+ | |||
+ | |||
+ | <h4>Handouts</h4> | ||
+ | |||
+ | *[[Media:Evaluating a spreadsheet.docx|Evaluating a spreadsheet.docx]] | ||
+ | *[[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 DATA FOR HOMEWORK.xls|Data laporan petugas DATA FILE FOR HOMEWORK.xls]] | ||
+ | *[[Media:ConditonalFormatexample-completed.xlsx|ConditonalFormatexample-completed.xlsx]] | ||
+ | *[[Media:GPSEx.xlsx|GPSEx.xlsx]] | ||
+ | *[[Media:GPS-example-completed.xlsx|GPS-example-completed.xlsx]] | ||
+ | |||
+ | <h2>Participant Materials</h2> | ||
+ | |||
<h3>Basic Excel</h3> | <h3>Basic Excel</h3> | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | </ | + | <h4>Spreadsheets</h4> |
− | </ | + | |
+ | *[[Media:SCAN1.png|SCAN1.png]] | ||
+ | *[[Media:SCAN2.png|SCAN2.png]] | ||
+ | *[[Media:SCAN3.png|SCAN3.png]] | ||
+ | *[[Media:SCAN4.png|SCAN4.png]] | ||
+ | *[[Media:AIpivot.xlsx|AIpivot.xlsx]] | ||
+ | *[[Media:DAFF_AI_SERO.xlsx|DAFF_AI_SERO.xlsx]] | ||
+ | *[[Media:faostatindo.xlsx|Faostatindo.xlsx]] | ||
+ | *[[Media:faostatpivot.xlsx|faostatpivot.xlsx]] | ||
+ | *[[Media:faostatpivot_ID.xlsx|faostatpivot_ID.xlsx]] | ||
+ | |||
+ | <h3>Intermediate Excel</h3> | ||
+ | |||
+ | <h4>Handouts</h4> | ||
+ | |||
+ | *[[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 terkini pada 17 Juni 2014 15.27
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
Intermediate Excel
Powerpoints
- Intermediate_Excel_CHARTS1_IND.pptx
- Intermediate_Excel_CHARTS2_IND.pptx
- Intermediate_Excel_CHARTS3_IND.pptx
- Intermediate_Excel_Formulae_IND.pptx
- Data analysis HOMEWORK exercise.pptx
Handouts
- Evaluating a spreadsheet.docx
- 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