Monday, 8 February 2016

T Yuniardi

How to show option value or drop down on excel or spreadsheet


1. On Excel

Rare people knowing about Data Validation on spreadsheet. That function is so usefully for user that want to get database on spreadsheet in choosing way (not input). This time i will show you how to show option list or drop down value on spreadsheet and this is function called Data Validation, this is very interesting to do. I use this function that applied on my jobs that using spreadsheet. Because, this Data Validation is simple way to get database on with use on option list. Many people use this software, because of easy to use or not complicated. This function is just pick up list on the data that appear on cell that use option list or drop function

in this software there a lot of formula that we can get, all formula have difference function, each function have difference results. Also we can combine between several formula to become one function just like VLOOKUP( ) and IF( ) if we combine become VLOOKUP( IF( ) ). Then function IF ( ) and AND ( ) if we combine, we can use IF( AND ( ) ) and much more sample combine of using Formula on Spreadsheet.

And this time i will not show about combine function but i will show option list or drop down value (Data Validation). This function is already applied on spreadsheet and we can used as we need. This function is good to applied when we make a report that displaying database. But before we use that function, we must created a database that will connect and show on drop down value. And don’t forget to check database that we want to put on that function, so function that we created can go smoothly.


This is several step to go that function on Excel:

  1. Create simple database, in this post i create table call name Fieldforce. In this table we create four columns. That columns header contain, id, name, position and level. Then we fill that database.
  2. Click cell that will use Data Validation.
  3.  Then click on top menu bar or Ribbon then choose Data
  4.  After that choose Data Validation on right position icon on menu Data Tools
  5.  Choose and click Data Validation, then menu tab Data Validation will Appears. That menu tab contain Settings tab, Input Message tab, and Error Alert tab.
  6. Choose Settings tab, than click on little arrow.
  7.  Choose List, then Source will appears. That Source is to get database that will put on Data Validation.
  8. Then click on Source then menu tab will gone and Source box will show.
  9. Then block data source that we want. in this sample i am using name column on Fieldforce table. Then press enter on source and ok on menu tab
  10. Then to see result of what we did then click cell that have been created Data Validation and litle arrow will show and when that arrow press down option value that contain name will appears on computer.

2. On Spreadsheets

Another version Data validation another Spreadsheets
This is several step to go that function:
  1. Create simple database, in this post i create table call name Fieldforce. In this table we create four columns. That columns header contain, id, name, position and level. Then we fill that database.
  2.  Click cell that will use Data Validation.
  3.  Then click on top menu bar choose Data
  4.  After that choose Validation on right position icon and another steps is same like Excel

Thank you, see you in next posting
Read More

Tuesday, 11 November 2008

asma

Periperal dari Camera Casio Exlim type EX-Z9

Sewaktu saya jalan-jalan di Giant Mall di daerah lebak bulus depan Carefour Lebakbulus Jakarta Selatan, ya sekalian rencana mo membeli kamera untuk kepentingan kantor. mata saya tertuju pada sebuah toko yang berada di Mall tersebut. Nama toko itu adalah Greatpower Digital dan lantainya (yach gak usah di ceritakan ya, nanti kalo ada yang tertarik silahkan cari saja sendiri ya he...he..), dimana toko tersebut khusus menjual jenis-jenis Kamera Digital dari mulai kelas High end sampai Low End. Akhirnya saya langsung menuju ke toko tersebut dan langsung mencari kamera digital yang sesuai dengan spesifikasi yang sesuai dengan kriteria dari atasan saya. Rupanya disitu ada kamera yang menarik perhatian saya dan mempunyai spesikasi diatas spesikasi kamera yang diberikan kepada saya. Dimana Kamera tersebut bermerk Camera Casio Exlim type EX-Z9, dengan spesifikasi fokus utama adalah ukuran kejernihan layar yaitu 8.1 MP (Mega Pixel). Setelah saya beli, ternyata harganya lumayan murah. harga yang tadi ditawarkan adalah 1.7 juta ternyata bisa turun menjadi 1.45 juta (termasuk Kartu Garansi). Kemudian saya menanyakan periperal yang saya dapatkan apa? kemudian pihak toko menjawab:

  1. Baterai yang bisa di charge (Rechargeable Battery)
  2. Recharge Machine Unit BC-60L (Mesin pengisi ulang)
  3. Memory Card 1 Gb
  4. USB Connection Cable
  5. AV Cable
  6. Strap
  7. Power Cable (Power Cord)
Masih bersambung dengan Foto-fotonya
Read More