Penggunaan Rumus VLookUp Pada Ms. Excel (Tugas Keterampilan Komputer)

MICROSOFT EXCEL 2007  (VLOOKUP)

1. Persiapkan data yang akan di lookup

2. Lalu, siapkan data yang akan menjadi lokasi acuan untuk VLOOKUP

3. Masukkan rumus (formula) VLOOKUP dengan benar

4. Hasil akhirnya akan terlihat seperti gambar dibawah ini

5. Selesai 

Langkah-langkah Mengupdate Ms. Office menjadi 2013 (Tugas Keterampilan Komputer)

1. Download software key/serial number yang ms. office 2013 yang berlisensi di it.fullerton.edu/students
     - Buka web browser masukkan link it.fullerton.edu/students di search bar
     

 

     -Scroll down lalu klik gambar Office 2013

     - Klik Get Microsoft Software disebelah kanan
       Pastikan software requirement nya cocok dengan windows yang Anda gunakan

     - Masukkan usernam dan password akun di bagian Student Login, lalu klik Login

     - Cari Microsoft Office Proffesional Plus 2013 lalu klik Add to cart

    - Klik View your cart, ikuti langkah langkah nya

 

     -  Klik Place your order

     - Klik Ok
                     

     - Baca baik-baik informasi penting yang ditampilkan : Simpan Serial Number nya. Serial Number ini dipakai saat proses penginstallan

 

2. Install Office 2013 versi trial
3. Buka salah satu program office (misal : word)
4. Masukkan Serial Number nya.
5. Hapus Versi Lama Office dari komputer sebelum menginstall Office 2013
    - Buka Control Panel

   - Pilih Uninstall A Program

   - Klik pada versi lama dari Office yang ada di komputer lalu klik Uninstall. Klik Yes, lalu klik Close setelah proses selesai

   - Setelah proses instalasi selesai, Komputer akan meminta Anda untuk me-restart klik Ok untuk me-restart

 6. Masukkan DVD Instalasi ke komputer dan ikuti instruksi untuk instalasi
     - Masukkan DVD Instalasi Microsoft Office 2013 ke komputer

    

     - Klik Install Now

    - Ketika Instalasi nya sudah selesai, klik Close

    - Buka Program Office apa saja, yang baru saja terinstall (Misal: Word, Excel, dll)

    - Tunggu Sebentar dan setelah keluar Pop Up Window klik Enter a product key instead

     - Masukkan Serial Number yang Anda dapat

    - Klik Accept dan ikuti langkah selanjutnya dengan meng-klik Next

    - Selesai!! Klik All Done

Source : www.fullerton.edu

The Differentiation Between Public Service Ads and Commercial Ads (Tugas Softskill)

The Definition of Advertisement

Advertisements is the promotion of new objects such as tables, services such as the post office, place of business and ideas to be paid by a sponsor. Other components of the promotion include publicity, public relations, sales, and sales promotion.

Public Service Advertisements (Iklan Layanan Masyarakat)

Public service ads are ads that present social messages which aims to raise public awareness of a number of social issues, which is a condition that can threaten the harmony and the common life.

Public service ads can be campaigned by a profit or non-profit organization with the goal of improving the socio-economic welfare of the community.

          

          Public Service Advertisements (Iklan Layanan Masyarakat)

Commercial Advertisements (Iklan Komersial)

Commercial ad is an ad that aims to support the marketing or promotion of a product or service that is produced from the company / industry and personal.

There are 2 kinds of commercial advertising :

1. Strategic Advertising : This kind of advertisement is used to build the brand. This was done by communicating the brand value and benefits of the product or service advertised.

2. Tactical ads : Are ads that have an urgent goal. This kind of ad is designed to encourage consumers to immediately make contact with a particular brand. In general, these ads provide special offers short term to spur consumers to respond on the same day.

     

Commercial Ads (Iklan Komersial)

http://id.wikipedia.org/wiki/Iklan_layanan_masyarakat

https://www.scribd.com/doc/77441541/Iklan-Komersial

http://id.wikipedia.org/wiki/Iklan 

Gunadarma

link homepage gunadarma