Kata Sambutan
.........................................................................
Kata Pengantar
.........................................................................
Daftar Isi ................................................................................
BAB 1 PENGENALAN EXCEL
............................................................... 1
1.1. Excel
.......................................................................................................1
1.2. Apa Yang Baru Di Excel?
...............................................................2
1.3. Membuka Excel
.................................................................................3
1.4. Workbook
............................................................................................6
1.5. Worksheet
..........................................................................................7
1.6. Sel
...........................................................................................................7
BAB 2 PENGENALAN RUMUS (FORMULAS) ....................... 9
2.1. Apa Itu Formula? ....................................................................9
2.2. Operator Formula
................................................................10
2.2.1. Operator Aritmatika
........................................................10
2.2.2. Operator Perbandingan
..................................................11
2.2.3. Operator Teks
....................................................................11
2.2.4. Operator Referensi
.........................................................12
2.3. Penggunaan Formula ........................................................12
2.3.1. Referensi Sel Relatif
................................................................14
2.3.2. Referensi Sel Semi Absolut
....................................................16
2.3.3. Referensi Sel Absolut
..............................................................18
2.4. Mengedit Formula
........................................................................20
2.5. Menghapus Formula
...................................................................22
2.6. Pesan Kesalahan Formula
........................................................23
2.7. Formula Array
...................................................................................24
2.7.1. Mengapa Menggunakan Rumus Array?
..............................24
2.7.2. Sintak Rumus Array
....................................................................25
2.7.3. Memasukkan Rumus Array
...................................................25
2.7.4. Membuat Rumus Array Sel Tunggal
....................................26
2.7.5. Membuat Rumus Array Multi Sel
.........................................28
2.8. Konstanta Array
..............................................................................31
2.8.1. Membuat Konstanta Satu Dimensi
......................................32
2.8.2. Membuat Konstanta Dua Dimensi
.......................................34
2.8.3. Menggunakan Konstanta Dalam Rumus
.............................36
2.9. Kelemahan Rumus Array
...............................................................38
BAB 3 PENGENALAN FUNGSI (FUNCTIONS)
.............................. 39
3.1. Apa Itu Fungsi?
................................................................................39
3.2. Argumen Dalam Fungsi
....................................................................40
3.3. Penggunaan Fungsi
..........................................................................41
3.4. Fungsi AutoSum
..............................................................................45
3.5. Fungsi Financial ................................................................................45
3.6. Fungsi Logical
..................................................................................45
3.7. Fungsi Text
.......................................................................................46
3.8. Fungsi Date & Time
...........................................................................46
3.9. Fungsi Lookup & Reference
..............................................................46
3.10. Fungsi Math & Trig ............................................................................46
3.11. Fungsi Statistical
.................................................................................47
3.12. Fungsi Engineering
............................................................................47
3.13. Fungsi Information
............................................................................47
3.14. Fungsi Web
.........................................................................................47
BAB 4 FUNGSI AUTOSUM
................................................................ 48
4.1. Fungsi Sum
..........................................................................................48
4.2. Fungsi Average
....................................................................................51
4.3. Fungsi Max
..........................................................................................54
4.4. Fungsi Min ..........................................................................................56
BAB 5 FUNGSI KEUANGAN (FINANCIAL)
..................................... 60
5.1. Fungsi Accrint
.....................................................................................60
5.2. Fungsi Accrintm
.................................................................................63
5.3. Fungsi Amordegrc
..............................................................................65
5.4. Fungsi Amorlinc
.................................................................................66
5.5. Fungsi Coupdaybs
..............................................................................67
5.6. Fungsi Coupdays
................................................................................69
5.7. Fungsi Coupdaysnc
............................................................................71
5.8. Fungsi Coupncd
..................................................................................72
5.9. Fungsi Coupnum ................................................................................74
5.10. Fungsi Couppcd
..................................................................................76
5.11. Fungsi Cumipmt
.................................................................................77
5.12. Fungsi Cumprinc
................................................................................79
5.13. Fungsi Db
............................................................................................81
5.14. Fungsi Ddb ..........................................................................................82
5.15. Fungsi Disc
..........................................................................................83
5.16. Fungsi Dollarde
..................................................................................85
5.17. Fungsi Dollarfr
....................................................................................86
5.18. Fungsi Duration
..................................................................................87
5.19. Fungsi Effect
........................................................................................89
5.20. Fungsi Fv
.............................................................................................90
5.21. Fungsi Fvschedule ..............................................................................92
5.22. Fungsi Intrate
......................................................................................93
5.23. Fungsi Ipmt
.........................................................................................95
5.24. Fungsi Irr
.............................................................................................96
5.25. Fungsi Ispmt
.......................................................................................98
5.26. Fungsi Mduration
...............................................................................99
5.27. Fungsi Mirr
.........................................................................................101
5.28. Fungsi Nominal ..................................................................................103
5.29. Fungsi Nper
.........................................................................................104
5.30. Fungsi Npv
..........................................................................................105
5.31. Fungsi Oddfprice
................................................................................107
5.32. Fungsi Oddfyield
................................................................................109
5.33. Fungsi Oddlprice
................................................................................111
5.34. Fungsi Oddlyield
................................................................................113
5.35. Fungsi Pduration ................................................................................115
5.36. Fungsi Pmt
..........................................................................................116
5.37. Fungsi Ppmt
........................................................................................118
5.38. Fungsi Price
.........................................................................................119
5.39. Fungsi Pricedisc
..................................................................................121
5.40. Fungsi Pricemat
..................................................................................123
5.41. Fungsi Pv
.............................................................................................125
5.42. Fungsi Rate ..........................................................................................127
5.43. Fungsi Received
..................................................................................128
5.44. Fungsi Rri
............................................................................................130
5.45. Fungsi Sln
............................................................................................131
5.46. Fungsi Syd
...........................................................................................132
5.47. Fungsi Tbilleq
.....................................................................................133
5.48. Fungsi Tbillprice
.................................................................................135
5.49. Fungsi Tbillyield .................................................................................136
5.50. Fungsi Vdb
..........................................................................................137
5.51. Fungsi Xirr
...........................................................................................139
5.52. Fungsi Xnpv
........................................................................................141
5.53. Fungsi Yield
.........................................................................................143
5.54. Fungsi Yielddisc
..................................................................................145
5.55. Fungsi Yieldmat
..................................................................................147
BAB 6 FUNGSI LOGIKA (LOGICAL) ................................................
149
6.1. Fungsi And
..........................................................................................149
6.2. Fungsi False
.........................................................................................151
6.3. Fungsi If
...............................................................................................152
6.4. Fungsi Iferror
......................................................................................153
6.5. Fungsi Ifna ...........................................................................................154
6.6. Fungsi Not
...........................................................................................155
6.7. Fungsi Or .............................................................................................156
6.8. Fungsi True
.........................................................................................157
6.9. Fungsi Xor
...........................................................................................158
BAB 7 FUNGSI TEKS (TEXT)
............................................................ 160
7.1. Fungsi Asc
...........................................................................................160
7.2. Fungsi Bahttext ...................................................................................161
7.3. Fungsi Char
.........................................................................................162
7.4. Fungsi Clean
........................................................................................163
7.5. Fungsi Code
.........................................................................................164
7.6. Fungsi Concatenate
............................................................................165
7.7. Fungsi Dollar
.......................................................................................166
7.8. Fungsi Exact
........................................................................................167
7.9. Fungsi Find
..........................................................................................168
7.10. Fungsi Fixed
........................................................................................170
7.11. Fungsi Left ...........................................................................................171
7.12. Fungsi Len
...........................................................................................172
7.13. Fungsi Lower
.......................................................................................173
7.14. Fungsi Mid
..........................................................................................174
7.15. Fungsi Numbervalue
..........................................................................175
7.16. Fungsi Proper
......................................................................................177
7.17. Fungsi Replace
....................................................................................178
7.18. Fungsi Rept ..........................................................................................179
7.19. Fungsi Right
........................................................................................180
7.20. Fungsi Search
......................................................................................181
7.21. Fungsi Substitute
................................................................................183
7.22. Fungsi T
...............................................................................................184
7.23. Fungsi Text
..........................................................................................185
7.24. Fungsi Trim
.........................................................................................187
7.25. Fungsi Unichar ...................................................................................188
7.26. Fungsi Unicode
...................................................................................189
7.27. Fungsi Upper
.......................................................................................190
7.28. Fungsi Value
........................................................................................191
BAB 8 FUNGSI TANGGAL & WAKTU (DATE & TIME)
................ 193
8.1. Fungsi Date ..........................................................................................193
8.2. Fungsi Datedif
.....................................................................................195
8.2. Fungsi Datevalue
................................................................................197
8.3. Fungsi Day
...........................................................................................198
8.4. Fungsi Days
.........................................................................................199
8.5. Fungsi Days360
...................................................................................201
8.6. Fungsi Edate
........................................................................................202
8.7. Fungsi Eomonth
.................................................................................203
8.8. Fungsi Hour
........................................................................................205
8.9. Fungsi Isoweeknum
...........................................................................206
8.10. Fungsi Minute
.....................................................................................207
8.11. Fungsi Month
......................................................................................208
8.12. Fungsi Networkdays
..........................................................................209
8.13. Fungsi Networkdays.intl
...................................................................211
8.14. Fungsi Now .........................................................................................213
8.15. Fungsi Second
.....................................................................................214
8.16. Fungsi Time
........................................................................................215
8.17. Fungsi Timevalue
...............................................................................217
8.18. Fungsi Today
.......................................................................................218
8.19. Fungsi Weekday
.................................................................................219
8.20. Fungsi Weeknum
...............................................................................221
8.21. Fungsi Workday
.................................................................................223
8.22. Fungsi Workday.intl
..........................................................................224
8.23. Fungsi Year
..........................................................................................227
8.24. Fungsi Yearfrac
...................................................................................228
BAB 9 FUNGSI LOOKUP & REFERENSI (REFERENCES)
............... 231
9.1. Fungsi Address
....................................................................................231
9.2. Fungsi Areas
........................................................................................233
9.3. Fungsi Choose
.....................................................................................234
9.4. Fungsi Column
...................................................................................235
9.5. Fungsi Columns
..................................................................................236
9.6. Fungsi Formulatext ............................................................................237
9.7. Fungsi Hlookup
..................................................................................239
9.8. Fungsi Hyperlink
................................................................................241
9.9. Fungsi Index
........................................................................................242
9.10. Fungsi Indirect
....................................................................................246
9.11. Fungsi Lookup
....................................................................................247
9.12. Fungsi Match
......................................................................................249
9.13. Fungsi Offset .......................................................................................251
9.14. Fungsi Row
..........................................................................................253
9.15. Fungsi Rows
........................................................................................254
9.16. Fungsi Transpose
................................................................................255
9.17. Fungsi Vlookup
..................................................................................256
BAB 10 FUNGSI MATEMATIKA & TRIGONOMETRI (MATH &
TRIG)
......................................................................................
259
10.1. Fungsi Abs
.........................................................................................259
10.2. Fungsi Acos .......................................................................................260
10.3. Fungsi Acosh
.....................................................................................261
10.4. Fungsi Acot .......................................................................................262
10.5. Fungsi Acoth
.....................................................................................263
10.6. Fungsi Aggregate
..............................................................................264
10.7. Fungsi Arabic
....................................................................................268
10.8. Fungsi Asin
........................................................................................270
10.9. Fungsi Asinh .....................................................................................271
10.10. Fungsi Atan
.......................................................................................271
10.11. Fungsi Atan2
.....................................................................................272
10.12. Fungsi Atanh
.....................................................................................274
10.13. Fungsi Base
........................................................................................275
10.14. Fungsi Ceiling
...................................................................................277
10.15. Fungsi Ceiling.math
.........................................................................278
10.16. Fungsi Ceiling.precise ......................................................................280
10.17. Fungsi Combin
.................................................................................281
10.18. Fungsi Combina
...............................................................................282
10.19. Fungsi Cos
.........................................................................................284
10.20. Fungsi Cosh
.......................................................................................285
10.21. Fungsi Cot
.........................................................................................286
10.22. Fungsi Coth
.......................................................................................287
10.23. Fungsi Csc .........................................................................................288
10.24. Fungsi Csch
.......................................................................................289
10.25. Fungsi Decimal
.................................................................................290
10.26. Fungsi Degrees
..................................................................................291
10.27. Fungsi Even
.......................................................................................292
10.28. Fungsi Exp
.........................................................................................293
10.29. Fungsi Fact
........................................................................................294
10.30. Fungsi Factdouble ............................................................................295
10.31. Fungsi Floor
......................................................................................296
10.32. Fungsi Floor.math
............................................................................298
10.33. Fungsi Floor.precise
.........................................................................299
|
10.34. Fungsi Gcd
........................................................................................301
10.35. Fungsi Int ..........................................................................................302
10.36. Fungsi Iso.ceiling
..............................................................................303
10.37. Fungsi Lcm ........................................................................................304
10.38. Fungsi Ln
...........................................................................................305
10.39. Fungsi Log
.........................................................................................306
10.40. Fungsi Log10
.....................................................................................307
10.41. Fungsi Mdeterm
...............................................................................308
10.42. Fungsi Minverse
...............................................................................309
10.43. Fungsi Mmult
...................................................................................311
10.44. Fungsi Mod .......................................................................................312
10.45. Fungsi Mround
.................................................................................314
10.46. Fungsi Multinomial
.........................................................................315
10.47. Fungsi Munit
.....................................................................................316
10.48. Fungsi Odd
........................................................................................317
10.49. Fungsi Pi ............................................................................................318
10.50. Fungsi Power
.....................................................................................319
10.51. Fungsi Product
..................................................................................320
10.52. Fungsi Quotient
................................................................................321
10.53. Fungsi Radians
..................................................................................322
10.54. Fungsi Rand
......................................................................................323
10.55. Fungsi Randbetween
........................................................................324
10.56. Fungsi Roman ...................................................................................325
10.57. Fungsi Round
....................................................................................326
10.58. Fungsi Rounddown
..........................................................................328
10.59. Fungsi Roundup
...............................................................................329
10.60. Fungsi Sec
..........................................................................................330
10.61. Fungsi Sech ........................................................................................331
10.62. Fungsi Seriessum
..............................................................................332
10.63. Fungsi Sign
........................................................................................334
10.64. Fungsi Sin
..........................................................................................334
10.65. Fungsi Sinh
........................................................................................335
10.66. Fungsi Sqrt
........................................................................................336
10.67. Fungsi Sqrtpi
.....................................................................................337
10.68. Fungsi Subtotal
.................................................................................338
10.69. Fungsi Sumif
.....................................................................................340
10.70. Fungsi Sumifs ....................................................................................342
10.71. Fungsi Sumproduct
..........................................................................344
10.72. Fungsi Sumsq
....................................................................................345
10.73. Fungsi Sumx2my2
............................................................................346
10.74. Fungsi Sumx2py2
.............................................................................348
10.75. Fungsi Sumxmy2 ..............................................................................349
10.76. Fungsi Tan
.........................................................................................350
10.77. Fungsi Tanh
......................................................................................351
10.78. Fungsi Trunc
.....................................................................................352
BAB 11 FUNGSI STATISTIK (STATISTICAL)
.................................. 354
11.1. Fungsi Avedev ...................................................................................354
11.2. Fungsi Averagea
................................................................................355
11.3. Fungsi Averageif
...............................................................................357
11.4. Fungsi Averageifs
.............................................................................359
11.5. Fungsi Beta.dist
.................................................................................361
11.6. Fungsi Beta.inv
..................................................................................362
11.7. Fungsi Binom.dist
............................................................................364
11.8. Fungsi Binom.dist.range
..................................................................365
11.9. Fungsi Binom.inv
.............................................................................367
11.10. Fungsi Chisq.dist
..............................................................................368
11.11. Fungsi Chisq.dist.rt
..........................................................................370
11.12. Fungsi Chisq.inv
...............................................................................371
11.13. Fungsi Chisq.inv.rt ...........................................................................372
11.14. Fungsi Chisq.test
..............................................................................373
11.15. Fungsi Cofidence.norm
...................................................................374
11.16. Fungsi Confidence.t
.........................................................................376
11.17. Fungsi Correl
....................................................................................377
11.18. Fungsi Count
.....................................................................................379
11.19. Fungsi Counta
...................................................................................380
11.20. Fungsi Countblank ...........................................................................381
11.21. Fungsi Countif
..................................................................................382
11.22. Fungsi Countifs
................................................................................383
11.23. Fungsi Covariance.p
........................................................................384
11.24. Fungsi Covariance.s
.........................................................................386
11.25. Fungsi Devsq .....................................................................................387
11.26. Fungsi Expon.dist
.............................................................................388
11.27. Fungsi F.dist
......................................................................................389
11.28. Fungsi F.dist.rt
..................................................................................391
11.29. Fungsi F.inv
.......................................................................................392
11.30. Fungsi F.inv.rt
...................................................................................393
11.31. Fungsi F.test
......................................................................................395
11.32. Fungsi Fisher .....................................................................................396
11.33. Fungsi Fisherinv
...............................................................................397
11.34. Fungsi Forecast.ets
...........................................................................398
11.35. Fungsi Forecast.ets.confint
.............................................................400
11.36. Fungsi Forecast.ets.seasonality
.......................................................401
11.37. Fungsi Forecast.ets.stat
....................................................................402
11.38. Fungsi Forecast.linear
......................................................................404
11.39. Fungsi Frequency
.............................................................................405
11.40. Fungsi Gamma
..................................................................................406
11.41. Fungsi Gamma.dist
..........................................................................407
11.42. Fungsi Gamma.inv
...........................................................................408
11.43. Fungsi Gammaln
..............................................................................410
11.44. Fungsi Gammaln.precise
.................................................................411
11.45. Fungsi Gauss
.....................................................................................412
11.46. Fungsi Geomean
...............................................................................413
11.47. Fungsi Growth
..................................................................................414
11.48. Fungsi Harmean
...............................................................................416
11.49. Fungsi Hypgeom.dist .......................................................................418
11.50. Fungsi Intercept
................................................................................419
11.51. Fungsi Kurt
.......................................................................................421
11.52. Fungsi Large
......................................................................................422
11.53. Fungsi Linest
.....................................................................................424
11.54. Fungsi Logest ....................................................................................422
11.55. Fungsi Lognorm.dist
........................................................................423
11.56. Fungsi Lognorm.inv
.........................................................................424
11.57. Fungsi Maxa
......................................................................................425
11.58. Fungsi Median
..................................................................................427
11.59. Fungsi Mina
......................................................................................428
11.60. Fungsi Mode.mult
............................................................................430
11.61. Fungsi Mode.sngl .............................................................................431
11.62. Fungsi Negbinom.dist
......................................................................433
11.63. Fungsi Norm.dist
..............................................................................434
11.64. Fungsi Norm.inv
..............................................................................436
11.65. Fungsi Norm.s.dist
...........................................................................437
11.66. Fungsi Norm.s.inv ............................................................................438
11.67. Fungsi Pearson
..................................................................................439
11.68. Fungsi Percentile.exc
.......................................................................441
11.69. Fungsi Percentile.inc
........................................................................442
11.70. Fungsi Percentrank.exc
...................................................................443
11.71. Fungsi Percentrank.inc
....................................................................445
11.72. Fungsi Permut
...................................................................................446
11.73. Fungsi Permutationa
........................................................................447
11.74. Fungsi Phi
..........................................................................................448
11.75. Fungsi Poisson.dist
...........................................................................449
11.76. Fungsi Prob
.......................................................................................451
11.77. Fungsi Quartile.exc
..........................................................................452
11.78. Fungsi Quartile.inc
...........................................................................454
11.79. Fungsi Rank.avg
................................................................................455
11.80. Fungsi Rank.eq .................................................................................457
11.81. Fungsi Rsq
.........................................................................................458
11.82. Fungsi Skew
.......................................................................................460
11.83. Fungsi Skew.p
...................................................................................461
11.84. Fungsi Slope
......................................................................................463
11.85. Fungsi Small
......................................................................................464
11.86. Fungsi Standardize
...........................................................................465
11.87. Fungsi Stdev.p ...................................................................................466
11.88. Fungsi Stdev.s
...................................................................................468
11.89. Fungsi Stdeva
....................................................................................470
11.90. Fungsi Stdevpa
..................................................................................471
11.91. Fungsi Steyx
......................................................................................473
11.92. Fungsi T.dist
......................................................................................474
11.93. Fungsi T.dist.2t
.................................................................................476
11.94. Fungsi T.dist.rt ..................................................................................477
11.95. Fungsi T.inv
......................................................................................478
11.96. Fungsi T.inv.2t
..................................................................................479
11.97. Fungsi T.test
......................................................................................481
11.98. Fungsi Trend
.....................................................................................483
11.99. Fungsi Trimmean
.............................................................................485
11.100. Fungsi Var.p
....................................................................................486
11.101. Fungsi Var.s
....................................................................................491
11.102. Fungsi Vara
.....................................................................................492
11.103. Fungsi Varpa ...................................................................................494
11.104. Fungsi Weibull.dist
........................................................................495
11.105. Fungsi Z.test
....................................................................................497
BAB 12 FUNGSI TEKNIK (ENGINEERING)
...................................... 500
12.1. Fungsi Besseli
....................................................................................500
12.2. Fungsi Besselj
....................................................................................501
12.3. Fungsi Besselk
...................................................................................502
12.4. Fungsi Bessely
...................................................................................503
12.5. Fungsi Bin2dec
..................................................................................505
12.6. Fungsi Bin2hex
.................................................................................506
12.7. Fungsi Bin2oct ..................................................................................507
12.8. Fungsi Bitand
....................................................................................509
12.9. Fungsi Bitlshift
..................................................................................510
12.10. Fungsi Bitor
.......................................................................................512
12.11. Fungsi Bitrshift
.................................................................................513
12.12. Fungsi Bitxor
.....................................................................................514
12.13. Fungsi Complex
................................................................................516
12.14. Fungsi Convert .................................................................................517
12.15. Fungsi Dec2bin
.................................................................................519
12.16. Fungsi Dec2hex
................................................................................520
12.17. Fungsi Dec2oct
.................................................................................521
12.18. Fungsi Delta
......................................................................................523
12.19. Fungsi Erf ..........................................................................................524
12.20. Fungsi Erf.precise
.............................................................................525
12.21. Fungsi Erfc ........................................................................................525
12.22. Fungsi Erfc.precise
...........................................................................526
12.23. Fungsi Gestep
....................................................................................527
12.24. Fungsi Hex2bin
.................................................................................528
12.25. Fungsi Hex2dec
................................................................................530
12.26. Fungsi Hex2oct
.................................................................................531
12.27. Fungsi Imabs
.....................................................................................532
12.28. Fungsi Imaginary
..............................................................................533
12.29. Fungsi Imargument
..........................................................................534
12.30. Fungsi Imconjugate ..........................................................................535
12.31. Fungsi Imcos
.....................................................................................536
12.32. Fungsi Imcosh
...................................................................................537
12.33. Fungsi Imcot
.....................................................................................538
12.34. Fungsi Imcsc
.....................................................................................539
12.35. Fungsi Imcsch
...................................................................................541
12.36. Fungsi Imdiv
.....................................................................................542
12.37. Fungsi Imexp ....................................................................................543
12.38. Fungsi Imln
.......................................................................................543
12.39. Fungsi Imlog10
.................................................................................544
12.40. Fungsi Imlog2
...................................................................................545
12.41. Fungsi Impower
................................................................................546
12.42. Fungsi Improduct .............................................................................547
12.43. Fungsi Imreal
....................................................................................548
12.44. Fungsi Imsec
.....................................................................................549
12.45. Fungsi Imsech
...................................................................................550
12.46. Fungsi Imsin
.....................................................................................551
12.47. Fungsi Imsinh
...................................................................................552
12.48. Fungsi Imsqrt
....................................................................................553
12.49. Fungsi Imsub ....................................................................................554
12.50. Fungsi Imsum
...................................................................................555
12.51. Fungsi Imtan
.....................................................................................556
12.52. Fungsi Oct2bin
.................................................................................557
12.53. Fungsi Oct2dec
.................................................................................559
12.54. Fungsi Oct2hex
.................................................................................560
BAB 14 FUNGSI INFORMASI (INFORMATION)
............................. 562
14.1. Fungsi Cell .........................................................................................562
14.2. Fungsi Error.type
..............................................................................564
14.3. Fungsi Info
........................................................................................565
14.4. Fungsi Isblank
...................................................................................566
14.5. Fungsi Iserr
........................................................................................567
14.6. Fungsi Iserror
....................................................................................569
14.7. Fungsi Iseven
.....................................................................................570
14.8. Fungsi Isformula ...............................................................................571
14.9. Fungsi Islogical
.................................................................................572
14.10. Fungsi Isna
........................................................................................573
14.11. Fungsi Isnontext
...............................................................................574
14.12. Fungsi Isnumber
...............................................................................575
14.13. Fungsi Isodd
......................................................................................576
14.14. Fungsi Isref
........................................................................................577
14.15. Fungsi Istext ......................................................................................578
14.16. Fungsi N
............................................................................................580
14.17. Fungsi Na
...........................................................................................581
14.18. Fungsi Sheet
......................................................................................582
14.19. Fungsi Sheets
.....................................................................................583
14.20. Fungsi Type
.......................................................................................584
BAB 16 FUNGSI JARINGAN (WEB)
.................................................. 587
16.1. Fungsi Encodeurl
..............................................................................587
16.2. Fungsi Filterxml
................................................................................588
16.3. Fungsi Webservice
...........................................................................589
Penutup
.............................................................................................................592
Daftar Pustaka
..................................................................................................593
Profil Penulis ....................................................................................................594
|