Rabu, 08 Mei 2013

FUNGSI CARA MENGHITUNG TANGGAL DAN WAKTU DALAM Ms.EXCEL



Fungsi ini dilakukan untuk pendataan umur, berikut cara menghitung berdasarkan tanggal, bulan, tahun kelahiran :

1.      Langkah pertama buatlah tabel yang ingin kalian buat dengan format (DD/MM/YY)
2.      Setelah itu lalu masukan NAMA, TANGGAL LAHIR, DAN HARI LAHIR
3.      Lalu disampingnya kita buat tabel UMUR SAMPAI TANGGAL TAHUN, setelah ini baru kita bisa masukan fungsi tanggal, berikut rumusnya ;
4.      = DATEDIF(C4;TODAY();"y")&" Tahun " logikanya jika tanggal ada di cellsC4 adalah hari ini, maka yang akan muncul adalah umur kita dihari ini.
5.      Untuk menghitung  bulan menggunakan rumus =DATEDIF(C4;TODAY();"ym")&" Bulan "
6.      Dan cara untuk menghitung hari menggunakan rumus =DATEDIF(C4;TODAY();"md")&" Hari "
7.      Dan begitu pun seterusnya, atau untuk mudah tinggal tarik ke bawah saja cellsnya, maka akan sama hasilnya seperti di atas.
Cara menghitung Fungsi aritmatika

Rumus cara menghitung  pertambahan, pengurangan, perkalian, pembagian, dan gabungan
1.      Langkah pertama yang harus dibuat pun sama seperti cara menghitung umur sampai tahun ini.
2.      Untuk cells pertambahan rumusnya adalah  =A13+B13+C13.
3.      Untuk cells pengurangan rumusnya adalah  =A13-B13-C13
4.      Untuk cells perkalian rumusnya adalah =A13*B13*C13
5.      Untuk cells pembagian rumusnya adalah =A13/B13/C13
6.      Untuk cells gabungan rumusnya adalah =A13&B13&C13
FUNGSI IF

1.      Langkah pertama buat lah cells-cells nama pembeli, kode barang, jumlah barang, dan nama barang
2.      Setelah itu buat lagi cells-cells untuk nama barang, harga satuan dan total harga
3.      Lalu masukkan rumus IF di cells nama barang dengan rumus =IF(C44="A";"Laptop";IF(C44="B";"Komputer";"Printer"))
Jika peryataan A adalah laptop maka hasilnya akan keluar laptop, jika pernyataan B adalah komputer maka hasil yang keluar adalah komputer, dan selain peryataan tersebut adalah printer
FUNGSI LOGIKA

1.      Langkah pertama buatlah kolom bilanganI,II dan III dan masukkan F.AND, F.OR, F.NOT
2.      Masukkan angka pada kolom bilangan I,II,III
3.      Pada kolom F.AND masukkan rumus =AND(D37>E37;C37>E37)
4.      Pada kolom F.NOT masukkan rumus =NOT(D37>E37)
5.      Pada kolom F.OR masukkan rumus =OR(D37>E37;C37>E37)
FUNGSI STASTIKA




1.      langkah pertama buatlah kolom nama, nilai (ulangan 1, ulangan 2, ulangan 3, total nilai, dan rata-rata)
2.      masukan semua data ke nama dan nilai (nilai ulangan1, ulangan2, ulangan3)
3.      dan pada kolom total nilai masukkan rumus =sum(c6:e6) itu maksudnya hasil nya akan di tarik dari kolom c6 samapi kolom e6.
4.      Pada kolom rata-rata masukan rumus =average(c6:e6) hasil rata-rata dari c6 sampai e6
5.      Untuk kolom jumlah siswa masukkan rumus =count(b21:b25) untuk jumlah dari b21 sampai b25
6.      Untuk kolom jumlah nilai tertinggi masukkan rumus =MAX(f21:f25)
7.      untuk kolom jumlah nilai terendah masukkan rumus =MIN(f21:f25)
8.      untuk kolom rata-rata masukkan rumus =AVERAGE(f21:f25)











FUNGSI STATISTIKA DALAM PEMBUATAN LAPORAN MINGGUAN


Fungsi statika ini berfungsi untuk hasil laporan mingguan penjualan beras
1.      langkah pertama buatlah kolom kode, jenis, harga, berat, discount,setoran, bonus, dan pendapatan
2.      masukkan data ke dalam kolom kode, jenis, harga, berat, bonus
3.      pada kolom discount 10% masukkan rumus =IF(e97>=150;10%*c97)
4.      untuk kolom setoran masukkan rumus HARGA*BERAT/DISCOUT (=c97*d97/e97)
5.      untuk kolom pendapatan masukkan rumus SETORAN+BONUS (=f97+g97)


FUNGSI HLOOKUP
Fungsi HLOOKUP adalah salah satu fungsi referensi yang bisa digunakan untuk menghitung atau mengambil data dari tabel referensi. HLOOKUP bisa juga disebut horizontal lookup.

1.     langkah pertama buatlah kolom kode nama barang, produksi, harga, terjual, discount, bonus
2.     masukkan data ke dalam kolom nama barang dan harga
3.     pada kolom produksi masukkan rumus =HLOOKUP(LEFT(A112;1);A119:D121;2;0) dan secara otomatis produk yang kita inginkan akan keluar
4.     pada kolom terjual masukkan rumus =MID(A112;3;3)
5.     pada  discount  masukkan rumus =IF(E112>=150;(10/100)*D112
6.     pada kolom bonus masukkan rumus =IF(C112="XL";"Topi";"PIN") jika produk c112 sama dengan XL maka yang keluar adalah TOPI dan selain itu adalah PIN











FUNGSI VLOOKUP

1.      langkah pertama buat kolom KODE, NIS, SEKOLAH, KELAS, JURUSAN
2.      masukkan data ke dalam kolom satu persatu
3.      dalam kolom NIS masukkan rumus =MID(A135;3;6)
4.      dalam kolom sekolah masukkan rumus =VLOOKUP(LEFT(A135;1);A141:B145;2;0)
5.      dalam kolom kelas masukkan rumus =MID(B135;5;1)
6.      dalam kolom jurusan masukkan rumus =HLOOKUP(RIGHT(A135;1);D141:F142;2;0)

48 komentar:

  1. Great blog! I really love how it is easy on my eyes and the information are well written.



    123HP officejet 3835 Printer install

    BalasHapus
  2. Easiest information about excel formula and explanations. Thanks for sharing 123.hp.com/setup

    BalasHapus
  3. Disciplined Judgement 123.hp.com , Distinct Key 123.hp.com , Diverting Knowledge 123.hp.com , Doable Leading 123.hp.com

    BalasHapus
  4. Cheerful Training 123.hp.com , Cheering Unit 123.hp.com , Cheery Vignette 123.hp.com , Cherished Accepted 123.hp.com , Chic Acknowledgement 123.hp.com

    BalasHapus
  5. For 123.hp.com/envy 7155 setup assistance, you can reach out to our techies right away

    BalasHapus
  6. Do you get "printer is offline" error.the issue is mainly due to driver issue and you have to download the latest drivers from 123.hp.com/setup .
    if you still can't fix it visit 123.hp.com and contact support team. these are other link find out your device and follow the steps
    123.hp.com/setup 7155

    123.hp.com/setup 8710

    123.hp.com/setup 8720

    123.hp.com/setup 8035

    123.hp.com/setup 8025

    123.hp.com/setup 6968


    BalasHapus
  7. If you need to use any type of model of HP printer for your printing needs, you can set up your suggested model number of HP printer using printer setup. This website assists you to set up the suggested model number of your HP printer in the suitable ways. First of all, you want to open this link in your suggested browser and download the application step by step. After that, you want to perform shown steps in the direct ways. If you get jammed in the procedure, you can take the good technician from an online technical specialist.

    BalasHapus
  8. We can instruct you properly, if you need to set up an HP wireless printer using printer setup . You can do the setup process easily, if you have correct technical knowledge about 123.hp/setup. First of all, you must go to open 123.hp/setup and open it in the internet browser. then , you should type the model number of your HP wireless printer in the shown box of 123.hp/setup. You can download the personal drivers of your HP wireless printer. After this process, you may get insert setting up the HP wireless printer properly. If you don’t have any manual or choice, you can take the specialized expert instruction or assistance for completing the setup process of HP wireless printer.

    BalasHapus
  9. I am a new user of HP products, so I don’t know anything about its features and task. I need to start a multiple HP printer with the help of hp.com/123.I am using my knowledge to open it in the internet browser and type my model number.

    BalasHapus
  10. I am facing technical issues to complete the HP printer setup procedure. So anyone can share the easy ways to set up anless printer with the assist of 123.hp.com/setup 8720.

    BalasHapus
  11. I want a wireless HP printer for wireless printing favor. Wireless printing technology permits the users to print the files wirelessly simply. It makes users feel free and the best way to get the pinout of any file easily. In the initial stage, I have opened 123. hp/setup in my special chrome browser and have typed the model number of my wireless printer in the shown box of hp wireless fax setup. After this process, I execute the show to finish the setup process. I am confronting issues in this process, so I need to take the unique help from an online technician. So anyone can assist me to set up an HP wireless printer via 123.hp.com.

    BalasHapus
  12. Do you have an HP printer? It needs some software to improve the performance of the hp printer, like driver software,HP easy scan. These all software are performing differently by respective works like scanning your hp printer performance, identifying the printer errors, checking ink cartridge level and also paper struck problems. So you need this type of software contact our website HP Easy Scan (HP Easy scan)

    BalasHapus
  13. I want a wireless HP printer for wireless printing favor. Wireless printing technology permits the users to print the files wirelessly simply. It makes users feel free and the best way to get the pinout of any file easily. In the initial stage, I have opened hp printer wireless setup in my special chrome browser and have typed the model number of my wireless printer in the shown box of 123.hp.com. After this process, I execute the show to finish the setup process. I am confronting issues in this process, so I need to take the unique help from an online technician. So anyone can assist me to set up an HP wireless printer via 123.hp.com.

    BalasHapus
  14. In the event that you are a client of HP Envy fax and searching for a source that can give you definitive advances and documents for the setup of HP Envy Fax, mind me, you should visit Hp Envy Fax. This is one step goal to find all the documents and driver applications related to all the HP Envy Fax models. Along with this, we have indicated here a good and easy process for hp printer setup. So for what reason would you say you are stopping? Hit the connection and appreciate top-tier printing results.

    BalasHapus
  15. I want a wireless printer for wireless printing help. I trust in using HP Officejet fax products for my wireless printer function. HP Officejet fax is an excellent printing system, so legion users choose it for their printing needs. I want to set up an HP Officejet fax with the assistance of 123.hp.com/setup. First of all, I have opened this link in my suggested browser. Then, I entered the model number of my wireless printer in the shown box. I am finishing this step to introduce a printer driver or application for the HP officejet fax setup procedure. After this step, I am getting stuck on finishing the HP officejet fax using Hp officejet 3830test fax setup. I am facing technical issues to complete the HP officejet fax setup procedure. So anyone can share the easy ways to set up an HP officejet fax with the assistance of 123.hp.com/setup.

    BalasHapus
  16. I want a wireless printer for wireless printing help. I trust in using HP Officejet pro fax products for my wireless printer function. HP Officejet pro fax is an excellent printing system, so legion users choose it for their printing needs. I want to set up an HP Officejet pro fax setup with the assist of 123.hp.com/setup. First of all, I have opened this link in my suggested browser. Then, I entered the model number of my wireless printer in the shown box. I am finishing this step to introduce a printer driver or application for the HP Officejet printer setup procedure. After this step, I am getting stuck to finish the HP Officejet pro fax using hp officejet 6830 test fax . I am facing technical issues to complete the HP OfficeJet pro fax setup procedure. So anyone can share the easy ways to set up an HP OfficeJet pro fax with the assist of 123.hp.com/setup.

    BalasHapus
  17. We can instruct you properly if you need to set up an HP Officejet Pro fax using 123.hp/setup. You can do the setup process easier if you have the correct technical knowledge about 123.hp/setup. First of all, you must go to open 123.hp/setup and open it in the internet browser. then, you should type t can model the number of your HP Officejet Pro printer in the shown box of Hp officejetpro 6968 test fax setup . You download the personal drivers of your HP Officejet Pro printer. After this process, you may get inserted into setting up the HP Officejet Pro printer properly. If you don’t have any manual or choice, you can take the specialized expert instruction or assistance for completing the setup process of the HP Officejet Pro printer using 123.hp/setup.

    BalasHapus
  18. In the event that you are a client of HP Officejet Pro Fax setup and searching for a source that can give you definitive advances and documents for the setup of HP Officejet Pro fax setup, mind me, you should visit Hp officejetpro 8710 test fax setup . This is one step goal to find all the documents and driver applications related to all the HP Officejet Pro fax setup models. Along with this, we have indicated here a good and easy process for hp printer setup. So for what reason would you say you are stopping? Hit the connection and appreciate top-tier printing results.

    BalasHapus
  19. You have spend to much time in observation and writing. Appreciated
    Bus Rental Ajman

    BalasHapus