Membuat Link dan Keyword Otomatis

Bagaimana membuat link dan keyword secara otomatis? Coba perhatikan kalimat dibawah ini, kalau gak ngerti tinggal click Translate aja gak usah bingung. Kaya tomato aja.

We can create this as your database in excel and also can use every time you want to use as link reference on your blog post. On this excel list you can create keyword change as you want and you can publish your record through website after you insert new keyword for your web address.

To create this list you first to create tree column on your excel but the important one you must write your web address correctly, once you create wrong address make your link is damage and will make your blog being avoid by Google search engine because contain of dead link. To make sure that your address right you must check it one by one.

On the first column is formula and on the third column is your keyword for your web address. On the first line of your cell B4, just right like this =HYPERLINK(C4;D4) if your first row is in fourth row and your formula is placed on the column C and your keyword is on column D. For other Cell like B5, B6 and so on, need not to fill, you just copy from B4 to B5, B6 and so on. Every time you change your keyword on cell D your keyword link also change like on the Cell D.

The example of this record on excel is as follows:

No.	Key Word with Link	Web Address	Keyword
1	Adhesive Formula	http://adhesive-formula.blogspot.com	Adhesive Formula
2	American Crisis	http://american-crisis.health-tips-diseases.com	American Crisis
3	Animals World	http://animals-world-07.blogspot.com	Animals World
4	Anodizing	http://anodizing-process.blogspot.com	Anodizing
5	Art and Technology	http://swasasi.blogspot.com	Art and Technology
6	Automobile	http://mobileandmotor.blogspot.com	Automobile
7	Bacteria	http://bacteria.health-tips-diseases.com	Bacteria
8	Bimbel Online	http://bimbelonline.blogspot.com	Bimbel Online
9	Biology	http://biology.health-tips-diseases.com	Biology
10	Blogs Review Center	http://blog-center.blogspot.com	Blogs Review Center
11	Body Organ	http://organ.health-tips-diseases.com	Body Organ
12	Brain Thinking	http://brain.health-tips-diseases.com	Brain Thinking
13	Carbon Steel	http://carbon-steel.health-tips-diseases.com	Carbon Steel
14	Cat Type	http://cat.health-tips-diseases.com	Cat Type
15	Chemical Process	http://chemistry.health-tips-diseases.com	Chemical Process
16	Chemical Substances	http://chemical-substances.blogspot.com	Chemical Substances
17	Coffee Bean	http://coffee.health-tips-diseases.com	Coffee Bean
18	Communication Media	http://media.health-tips-diseases.com	Communication Media
19	Dog Type	http://dog.health-tips-diseases.com	Dog Type
20	Electronic Knowledge	http://adigrahito.blogspot.com	Electronic Knowledge
21	Electroplating	http://electroplating-process.blogspot.com	Electroplating
22	Engineering	http://engineering.health-tips-diseases.com	Engineering
23	Facebook Member	http://facebook.health-tips-diseases.com	Facebook Member
24	Google Adsense	http://adsense-google-pots.blogspot.com	Google Adsense
25	Health Act and Safety	http://health-act-safety.blogspot.com	Health Act and Safety
26	Health and Safety	http://safety.health-tips-diseases.com	Health and Safety
27	Health Eyes	http://eyes.health-tips-diseases.com	Health Eyes
28	Heart Diseases	http://heart.health-tips-diseases.com	Heart Diseases
29	Honey	http://honey.health-tips-diseases.com	Honey
30	House Design	http://house.health-tips-diseases.com	House Design
31	House Model	http://house-model.blogspot.com	House Model
32	Indonesian Food Forage	http://indonesian-food-forage.blogspot.com	Indonesian Food Forage
33	Kompas Media	http://kompas.health-tips-diseases.com	Kompas Media
34	Many Adhesives	http://adhesive.health-tips-diseases.com	Many Adhesives
35	Many Health Tips	http://many-health-tips.blogspot.com	Many Health Tips
36	Medicine	http://medicine.health-tips-diseases.com	Medicine
37	Music Element	http://music-elements.blogspot.com	Music Element
38	Music to Download	http://music-todownload.blogspot.com	Music to Download
39	Algorithm Process	http://process-algoritma.blogspot.com	Algorithm Process
40	Science	http://science.health-tips-diseases.com	Science
41	Skin Diseases	http://skin.health-tips-diseases.com	Skin Diseases
42	Technology	http://technology.health-tips-diseases.com	Technology
43	Training and Teching	http://training.health-tips-diseases.com	Training and Teching
44	Twitter Forum	http://twitter.health-tips-diseases.com	Twitter Forum
45	Viruses	http://viruses.health-tips-diseases.com	Viruses
46	Waste Water	http://waste.health-tips-diseases.com	Waste Water
47	Water	http://water.health-tips-diseases.com	Water
48	Windows Office Hacker	http://windosoffice.blogspot.com	Windows Office Hacker