Basic Excel Materials: Perbedaan revisi
Baris 39: | Baris 39: | ||
<li>[[Media:AIpivot5.xlsx|AIpivot5.xlsx]]</li> | <li>[[Media:AIpivot5.xlsx|AIpivot5.xlsx]]</li> | ||
<li>[[Media:AIpivot6.xlsx|AIpivot6.xlsx]]</li> | <li>[[Media:AIpivot6.xlsx|AIpivot6.xlsx]]</li> | ||
+ | |||
+ | <h3>Intermediate Excel</h3> | ||
+ | <h4>Participants’ files</h4> | ||
+ | <li>[[Media:IntExcelFormulae.zip|IntExcelFormulae.zip]]</li> | ||
+ | |||
+ | <h4>Trainers’ files</h4> | ||
+ | <ul> | ||
+ | <li>[[Media:Evaluating a worksheet|Evaluating a worksheet]]</li> | ||
+ | <li>[[Media:Data-analysis-HOMEWORK-exercise.pptx|Data-analysis-HOMEWORK-exercise.pptx]]</li> | ||
+ | <li>[[Media:Data-laporan-petugas-HOMEWORK.xls|Data-laporan-petugas-HOMEWORK.xls]]</li> | ||
+ | <li>[[Media:Data-laporan-petugas-DATA FILE FOR HOMEWORK.xls|Data-laporan-petugas-DATA FILE FOR HOMEWORK.xls]]</li> | ||
+ | <li>[[Media:ConditonalFormatexample-completed.xlsx|ConditonalFormatexample-completed.xlsx]]</li> | ||
+ | <li>[[Media:GPSEx.xlsx|GPSEx.xlsx]]</li> | ||
+ | <li>[[Media:GPS-example-completed.xlsx|GPS-example-completed.xlsx]]</li> | ||
+ | |||
</ul> | </ul> | ||
</ul> | </ul> |
Revisi per 16 Juni 2014 13.42
Daftar isi
PowerPoints
Basic Excel
Bahasa Indonesia
- 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
Basic Excel
Participants' files
- SCAN1.png
- SCAN2.png
- SCAN3.png
- SCAN4.png
- AIpivot.xlsx
- DAFF_AI_SERO.xlsx
- faostatindo.xlsx
- faostatpivot.xlsx
- faostatpivot_ID.xlsx
Trainers' files
- Contoh1.xlsx
- DAFF_AI_SERO_REVISED.xlsx
- AIpivotSERIES
- AIpivot1.xlsx
- AIpivot2.xlsx
- AIpivot3.xlsx
- AIpivot4.xlsx
- AIpivot5.xlsx
- AIpivot6.xlsx
- IntExcelFormulae.zip