Belajar Fungsi-fungsi Excel

Fungsi- Fungsi di Excel

1 SUM 26 PPMT
2 SUMIF 27 PV
3 SUMIFS 28 NPV
4 SUMPRODUCT 29 VLOOKUP
5 SUBTOTAL 30 HLOOKUP
6 ROUDUP 31 LOOKUP
7 ROUDDOWN 32 INDEX
8 CEILING 33 MATCH
9 ABS 34 CHOOSE
10 IF 35 AVERAGE
11 AND 36 COUNT&COUNTA
12 OR 37 MAX
13 DATE 38 MIN
14 DAY 39 LEFT
15 DAYS360 40 LEN
16 EOMONTH 41 UPPER
17 HOUR 42 LOWER
18 MONTH 43 PROPER
19 NOW 44 MID
20 TODAY 45 RIGHT
21 YEAR 46 VALUE
22 CUMIPMT 47 REPT
23 FV 48 ISERROR
24 PMT 49 ISNUMPER
25 IPMT 50 INTEXT

(Download Fungsi-Fungsi excel)

Download Latihan 1
Kasus 1 - Kasus 2 - Kasus 3 - Kasus 4 - Kasus 5 - Kasus 6 - Kasus 7 - Kasus 8 - Kasus 9 - Kasus 10 - Kasus 11 - Kasus 12 - Kasus 13

Download Latihan 2

Download Latihan 3
Kasus 1abc - Kasus 2 - Kasus 3ab