Basic Excel Materials: Perbedaan revisi
 
(21 revisi antara oleh pengguna yang sama tidak ditampilkan)
Baris 1: Baris 1:
 
<h2>Trainer Materials</h2>
 
<h2>Trainer Materials</h2>
 +
 
<h3>Basic Excel</h3>
 
<h3>Basic Excel</h3>
−
<h4>Powerpoints<\h4>
 
  
−
*[[Media:1-Data-Management_Prinsip-Pengelolaan-data-part1.ppt.pptx|1. Data Management (Part1)]]
+
<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: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-Part1.pptx|2. Basic Excel Skills (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>
+
<h4>Spreadsheets</h4>
  
−
*[[Media:Contoh1.xlsx|Contoh1.xlsx]]</li>
+
*[[Media:Contoh1.xlsx|Contoh1.xlsx]]
−
*[[Media:DAFF_AI_SERO_REVISED.xlsx|DAFF_AI_SERO_REVISED.xlsx]]</li>
+
*[[Media:DAFF_AI_SERO_REVISED.xlsx|DAFF_AI_SERO_REVISED.xlsx]]
−
*AIpivotSERIES</li>
+
*AIpivotSERIES
−
**[[Media:AIpivot1.xlsx|AIpivot1.xlsx]]</li>
+
**[[Media:AIpivot1.xlsx|AIpivot1.xlsx]]
−
**[[Media:AIpivot2.xlsx|AIpivot2.xlsx]]</li>
+
**[[Media:AIpivot2.xlsx|AIpivot2.xlsx]]
−
**[[Media:AIpivot3.xlsx|AIpivot3.xlsx]]</li>
+
**[[Media:AIpivot3.xlsx|AIpivot3.xlsx]]
−
**[[Media:AIpivot4.xlsx|AIpivot4.xlsx]]</li>
+
**[[Media:AIpivot4.xlsx|AIpivot4.xlsx]]
−
**[[Media:AIpivot5.xlsx|AIpivot5.xlsx]]</li>
+
**[[Media:AIpivot5.xlsx|AIpivot5.xlsx]]
−
**[[Media:AIpivot6.xlsx|AIpivot6.xlsx]]</li>
+
**[[Media:AIpivot6.xlsx|AIpivot6.xlsx]]
  
 
<h3>Intermediate Excel</h3>
 
<h3>Intermediate Excel</h3>
  
−
*[[Media:Evaluating a worksheet|Evaluating a worksheet]]</li>
+
<h4>Powerpoints</h4>
−
*[[Media:Data-analysis-HOMEWORK-exercise.pptx|Data-analysis-HOMEWORK-exercise.pptx]]</li>
+
 
−
*[[Media:Data-laporan-petugas-HOMEWORK.xls|Data-laporan-petugas-HOMEWORK.xls]]</li>
+
*[[Media:Intermediate_Excel_CHARTS1_IND.pptx|Intermediate_Excel_CHARTS1_IND.pptx]]
−
*[[Media:Data-laporan-petugas-DATA FILE FOR HOMEWORK.xls|Data-laporan-petugas-DATA FILE FOR HOMEWORK.xls]]</li>
+
*[[Media:Intermediate_Excel_CHARTS2_IND.pptx|Intermediate_Excel_CHARTS2_IND.pptx]]
−
*[[Media:ConditonalFormatexample-completed.xlsx|ConditonalFormatexample-completed.xlsx]]</li>
+
*[[Media:Intermediate_Excel_CHARTS3_IND.pptx|Intermediate_Excel_CHARTS3_IND.pptx]]
−
*[[Media:GPSEx.xlsx|GPSEx.xlsx]]</li>
+
*[[Media:Intermediate_Excel_Formulae_IND.pptx|Intermediate_Excel_Formulae_IND.pptx]]
−
*[[Media:GPS-example-completed.xlsx|GPS-example-completed.xlsx]]</li>
+
*[[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>
  
−
<h2Participants' files</h2>
 
 
<h3>Basic Excel</h3>
 
<h3>Basic Excel</h3>
 +
 
<h4>Spreadsheets</h4>
 
<h4>Spreadsheets</h4>
  
Baris 44: Baris 66:
 
*[[Media:AIpivot.xlsx|AIpivot.xlsx]]
 
*[[Media:AIpivot.xlsx|AIpivot.xlsx]]
 
*[[Media:DAFF_AI_SERO.xlsx|DAFF_AI_SERO.xlsx]]
 
*[[Media:DAFF_AI_SERO.xlsx|DAFF_AI_SERO.xlsx]]
−
*[[Media:faostatindo.xlsx|faostatindo.xlsx]]
+
*[[Media:faostatindo.xlsx|Faostatindo.xlsx]]
 
*[[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>
+
<h4>Handouts</h4>
  
−
*[[Media:IntExcelFormulae.zip|Intermediate Excel Formulae materials]]
+
*[[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

Trainer Materials

Basic Excel

Powerpoints

Spreadsheets

Intermediate Excel

Powerpoints


Handouts

Spreadsheets

Participant Materials

Basic Excel

Spreadsheets

Intermediate Excel

Handouts

Diperoleh dari "http://wiki.isikhnas.com/index.php?title=Basic_Excel_Materials&oldid=3808"