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.
Archive for the ‘Computer Tips’ category
Creating a logo
January 30th, 2010Making validation list in excel
January 19th, 2010How 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…
Change the cell formatting base on the value (Excel)
December 18th, 2009If 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.
Get this day and month in Indonesia Fomat with Excel
August 2nd, 2009In my new client, somebody ask me “how to get this day and month in excel?” (I make the format in Indonesia because I’m Indonesian) . He ask me because he is newbie in IT and he study excel autodidact. Although I’m an IT worker but my excel is bad (Hehehehe… :) ), And I try to solve his problem and search “today” as keyword in the help Excel (kekekekeke 
).
I try for some minutes and finally I get the ways. This the solution, But before I write the solution I’d give some lesson for Indonesia language :). This the name of day and month in Indonesia.
If you want to learn Indonesian language for a bit you can read this.
First Step: How to get the date,weekday, month, and year in this day
Use the function as show below:
- To get weekday use weekday() function and insert today() function as the serial number
- To get the date use day() function and insert today() function as the serial number
- To get the month use month() function
- To get the year use year() function
This is the result from weekday, day, month, and year sequentially :
Second Step : How to get the name of days and months in Indonesia
You must understand how to use choose() function and this the way:
- To get the name of days in Indonesia
- To get the name of month in Indonesia
The last step : Join all function to view the date format in Indonesia
- Use function concatenate()
Concatenate joins several text strings into one text string.
Type the function like this in the formula bar
And the final result is
Some Simple Trick In Microsoft Excel
July 2nd, 2009I have some simple trick in excel, in this sample I use Ms.Excel 2003. I write this article just to share my experience when I have simple problem in excel. I will separate this trick be 2 part.The first part is “Adding 0 number before another number” and the second part is “Adding millisecond sign in excel”. Alright I try to describes one by one.
The first trick “Adding 0 (Zero) number before another number “
As the sample I will try to write a number of number in the excel like the following picture
The next step is block rows A and B, right click there and then select Format Cells…
In the Number tab choose Custom Category, type “00000″# in Type text box.And then click OK
As the final result is like this
The second trick “Adding millisecond sign in excel”
If you confuse to add millisecond sign for time format in excel you can use this trick as the solution. First step for example you type the following text in excel
And the result is like this
You must be disappointed with this result because your desirability for time format until millysecondsign failed.
For the solution you can blok cell A and the right click there. In the Number tab, Custom category you can type hh:mm:ss.00 in the Type text box. This format will changes your cell format.
And the final result is this following picture
I hope this simple tips can help the readers. Thank’s
