Today I tried to create a logo that was asked by someone at my client companies. Therefore, I make the following logos.
This is the first version.
And this is the second version.
Maybe it’s good enough for a beginner.
Creating a logo
January 30th, 2010 2 comments »Kevin Skinner in America’s Got Talent
January 24th, 2010 No comments »In my country Indonesia, I just saw “America’s Got Talent”. I watching this program in one of Indonesia TV Program INDOSIAR. This program is so definitely amazing to search the people talent in every place. This program give people chance to show their talent. A colorful of hopeful stars, including singers, dancers, comedians, magicians, ventriloquists of all ages strut and perform on stage to show their talent,to show their unique ability.
So when Indonesia will make the same program, I think this program is very good. We wait for Indonesia got Talent.
Ok we will back To America’s Got Talent, for the first time I watching this TV Program in my opinion one of unique people in my mind is Kevin Skinner.He is an 35 year old man, Unemployed Farmer come from villages to realize his dream to show his talent. I think he is very talented with his beautiful guitar sound and his voice like “Ronan Keating”. So for you all, keep sharpening your talent. And as Indonesian we wait for “Indonesia’s Got Talent”
This is Kevin Skinner videos with his song “If tomorrow never comes”.
Making validation list in excel
January 19th, 2010 No comments »How to create a dropdownlist in excel?
The trick is to use data validation. Follow the step belows:
1. Prepare simple data such as the following picture
2. By selecting cells A1: C5 determine the table name for the data, with the name ‘departments’.
3. The next step to create a new table as shown in the picture, then select the range A10: A13. Select the menu Data - validation.
So the window will appear for data validation.
In the list of options ‘Allow’ select ‘list’, and for the source type the following =$A$2:$A$5. And then click OK
- In B10 cell use vlookup function to find the data of Department Name base on ID Department, the function is like this.
=VLOOKUP(A10,Department,2,TRUE)
- In C10 cell use vlookup function to find the data of Department Name base on ID Department, the function is like this.
=VLOOKUP(A10,Department,3,TRUE)
Drag your mouse from B10 to B13, as shown below. Do the same thing for C10 to C13.
4. As the final result, when you choose one of list for department ID, the departmen name and Amount of Employee will appear automatically base on the data in table department.
Good Luck…
Merry Christmas
December 25th, 2009 No comments »Merry Christmas December 25, 2009 for all people, I hope at Christmas this year we are more blessed in our life journey each.
Merry Christmas ..
-dedi -
Silent Night
Silent night, holy night
All is calm, all is bright
Round yon Virgin Mother and Child
Holy Infant so tender and mild
Sleep in heavenly peace
Sleep in heavenly peace
Silent night, holy night!
Shepherds quake at the sight
Glories stream from heaven afar
Heavenly hosts sing Alleluia!
Christ, the Saviour is born
Christ, the Saviour is born
Silent night, holy night
Son of God, love’s pure light
Radiant beams from Thy holy face
With the dawn of redeeming grace
Jesus, Lord, at Thy birth
Jesus, Lord, at Thy birth “
Change the cell formatting base on the value (Excel)
December 18th, 2009 No comments »If you wish to change the format of cell based on the value in a cell, You do not need to use a macro to change the cell format automatically. You just need to know the features of microsoft excel.
What is the features?
The feature is conditional formatting. To understand the feature you can see the following simple example.
Under format menu, select conditional Formatting
When the first Conditional Formatting window appears, enter first condition. In this example Formula is =OR($C3=”",$C3=”0″, $C3=”Right”). Next, you need to select what formatting to apply when the condition is met. To do this, click on the Format button.
In the font tab you can set the font style and font color
For the cell background color or style you can choose Pattern tab. In order to understand the detail see the following picture.
You can add conditions to the conditions 1 to 3 in accordance with your wishes. As in the example you can notice the following condition.
Now when you return to the spreasheet, the conditional formatting will be applied. As you can see in the following sample.
