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 ‘Computers’ 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.
Making simple Brochure design
November 28th, 2009This morning my friend showed the book catalog design, and then I look at it, it’s good. Then I borrowed the book, and I try to emulate these examples. I’m looking for pictures of buildings on flickr, and I combine these images with examples of existing design. After a while I tried to finally bearing fruit as well. And the result is not bad. Here is the result.
Trying to make website design
November 24th, 2009A few months ago I tried to change the design to an existing website.I am using extjs for this website. I am still learning to use extjs, I try to learn from the website application created by my friend. This is view for login form.
And this the index
