BASIC

• BASIC
• IF & IFS
• IF AND & OR
• IF TIME
• IF LEFT MID RIGHT
• LATIHAN IF & IFS
• SUM & SUMIF
• SUMIFS & IFERROR
• COUNT, COUNTA, & COUNTIF
• COUNTIFS
• VLOOKUP
• HLOOKUP
• LEFT, MID, & RIGHT
• SUMIFS, AVERAGEIF, & COUNTIFS
• GRAFIK

INTERMEDIATE

• TEXT FUNCTION
• SORT
• FILTER
• DATA VALIDATION
• FUNGSI LOOKUP LANJUTAN
• PIVOT TABLE
• LATIHAN SOAL INTERMEDIATE

ADVANCE

• ADVANCE FILTER
• LATIHAN SOAL ADVANCE
• TEXT TO COLUMN
• FREEZE PANES