Basic Excel Materials: Perbedaan revisi
Baris 1: | Baris 1: | ||
<h2>Trainer Materials</h2> | <h2>Trainer Materials</h2> | ||
+ | |||
<h3>Basic Excel</h3> | <h3>Basic Excel</h3> | ||
− | <h4>Powerpoints< | + | |
+ | <h4>Powerpoints</h4> | ||
*[[Media:1-Data-Management_Prinsip-Pengelolaan-data-part1.ppt.pptx|1. Data Management (Part1)]] | *[[Media:1-Data-Management_Prinsip-Pengelolaan-data-part1.ppt.pptx|1. Data Management (Part1)]] | ||
Baris 12: | Baris 14: | ||
*[[Media:4-Useful-Outputs_Menyiapkan-Keluaran.pptx|4. Useful Outputs]] | *[[Media:4-Useful-Outputs_Menyiapkan-Keluaran.pptx|4. Useful Outputs]] | ||
− | <h4>Spreadsheets< | + | <h4>Spreadsheets</h4> |
*[[Media:Contoh1.xlsx|Contoh1.xlsx]]</li> | *[[Media:Contoh1.xlsx|Contoh1.xlsx]]</li> | ||
− | *[[Media:DAFF_AI_SERO_REVISED.xlsx|DAFF_AI_SERO_REVISED.xlsx]] | + | *[[Media:DAFF_AI_SERO_REVISED.xlsx|DAFF_AI_SERO_REVISED.xlsx]] |
− | *AIpivotSERIES | + | *AIpivotSERIES |
− | **[[Media:AIpivot1.xlsx|AIpivot1.xlsx]] | + | **[[Media:AIpivot1.xlsx|AIpivot1.xlsx]] |
− | **[[Media:AIpivot2.xlsx|AIpivot2.xlsx]] | + | **[[Media:AIpivot2.xlsx|AIpivot2.xlsx]] |
− | **[[Media:AIpivot3.xlsx|AIpivot3.xlsx]] | + | **[[Media:AIpivot3.xlsx|AIpivot3.xlsx]] |
− | **[[Media:AIpivot4.xlsx|AIpivot4.xlsx]] | + | **[[Media:AIpivot4.xlsx|AIpivot4.xlsx]] |
− | **[[Media:AIpivot5.xlsx|AIpivot5.xlsx]] | + | **[[Media:AIpivot5.xlsx|AIpivot5.xlsx]] |
− | **[[Media:AIpivot6.xlsx|AIpivot6.xlsx]] | + | **[[Media:AIpivot6.xlsx|AIpivot6.xlsx]] |
<h3>Intermediate Excel</h3> | <h3>Intermediate Excel</h3> | ||
− | *[[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: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]] |
− | *[[Media:ConditonalFormatexample-completed.xlsx|ConditonalFormatexample-completed.xlsx]] | + | *[[Media:ConditonalFormatexample-completed.xlsx|ConditonalFormatexample-completed.xlsx]] |
− | *[[Media:GPSEx.xlsx|GPSEx.xlsx]] | + | *[[Media:GPSEx.xlsx|GPSEx.xlsx]] |
− | *[[Media:GPS-example-completed.xlsx|GPS-example-completed.xlsx]] | + | *[[Media:GPS-example-completed.xlsx|GPS-example-completed.xlsx]] |
<h2Participants' files</h2> | <h2Participants' files</h2> |
Revisi per 16 Juni 2014 14.03
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
- Evaluating a worksheet
- Data-analysis-HOMEWORK-exercise.pptx
- Data-laporan-petugas-HOMEWORK.xls
- Data-laporan-petugas-DATA FILE FOR HOMEWORK.xls
- ConditonalFormatexample-completed.xlsx
- GPSEx.xlsx
- GPS-example-completed.xlsx
<h2Participants' files
Basic Excel
Spreadsheets
- SCAN1.png
- SCAN2.png
- SCAN3.png
- SCAN4.png
- AIpivot.xlsx
- DAFF_AI_SERO.xlsx
- faostatindo.xlsx
- faostatpivot.xlsx
- faostatpivot_ID.xlsx