Pages

Minggu, 30 November 2008

Belajar Microsoft Office Excel bagian 8


Fungsi SUMIF()


Dalam sebuah tempat usaha dagang atau toko penjualan, kadang kita membutuhkan informasi tentang barang dagangan kita yang terjual dalam satu hari atau satu minggu atau satu bulan bahkan satu tahun, sebagai dasar untuk menentukan besaran stok yang harus disediakan sesuai dengan trend pembelian barang yang ada di tempat usaha kita.



Untuk mengetahui jumlah barang yang terjual

Maple Dijon Chicken CrockPot Recipe


Day 335.

I think anything with the word "dijon" in the title instantly sounds exquisite and marvelous---even though it's only a $2.99 condiment. Dijon is the show-off in the mustard family.

Carissa sent me this recipe on my birthday, and I printed it out right away. I was pleasantly surprised to have everything in the house already (well, minus the bay leaves).

The Ingredients.


--1 lb chicken pieces (I used frozen breast tenderloins)
--1 cup chicken broth
--2 sweet potatoes, peeled and chopped

--1 onion, chopped
--2 T dijon mustard
--3 T maple syrup
--3 cloves garlic, chopped

--2 bay leaves
--1 tsp thyme

The Directions.


I used a 4 quart crockpot---it was a good size. This fed the four of us with a tiny bit left for lunch the next day. If you have a large family or would like leftovers, double the quantity.


Put the chicken into the bottom of your crockpot and toss it with the thyme, maple syrup, and dijon mustard.


Peel and slice the sweet potato, and add to the pot. Add the onion and garlic. If you don't want your onion to have a crunch, put it at the bottom of the crockpot; otherwise on top of the chicken is fine.


Pour in the chicken broth. Add the bay leaves.


Cover and cook on low for 6-8 hours, or on high for 4-5. This is done when the chicken is cooked through and the vegetables reach desired tenderness.


The Verdict.


Very good, and quite moist. The picture up above is a bit misleading----I had enough juice in the pot to ladle over the vegetables and some leftover white rice. The sweet potato fell apart a bit, so some were more mashed than chunky.
The kids each ate 2 of the breast tenderloins, and a bit of sweet potato.

Thank you, Carissa --I really liked this chicken a lot-- I enjoyed the flavor and appreciated how easy it was to throw together.

Sabtu, 29 November 2008

CrockPot Ropa Vieja Recipe



Day 334.

What should you do when you have a house full of food? Make more!

right?

The turkey carcass has been soupified, and the yams, potatoes, and stuffing has been given away and frozen. The refrigerator looked weird and empty yesterday, but we had an overflowing produce drawer. I had an email saved from Melanie, who walked me through making Ropa Vieja---which is a fantastic way to use a frozen hunk-of-meat, and feed a lot of people.

The Ingredients.

--3 lbs meat (get what's on sale. Stew meat, chuck roast, steaks, whatever.)
--1/2 cup chicken broth
--1/4 cup apple cider vinegar (could use white)
--1 T cumin
--1 tsp smoked paprika
--1 tsp salt
--1/2 tsp black pepper
--1/4 tsp cayenne pepper
--1 large red onion, chopped
--2 red bell peppers, chopped
--2 med yellow apples, grated
--3 stalks celery, chopped
--3 cloves smashed and chopped garlic
--1/2 cup cilantro leaves

The Directions.

I used a 6.5 quart crockpot. I think you'll need at least a 5 quart----this is a lot of food.

Combine all of the dry spices in a bowl. Rub the spices all over the piece (or pieces) of meat you are using. Put the meat into your crockpot. Dump any extra spice on top.

Coarsely chop the vegetables and add to the pot. Smash the garlic, take the leaves off the cilantro stems, and add.

Peel the apples, and grate them into the pot with a cheese grater.

Add the chicken broth and vinegar.

Cover and cook on low for a very long time, or on high for a pretty long time. I'd go for at least 10 hour on low and at least 7 hours on high, checking about 2 hours before serving to see if you can shred the meat with forks. If you can't shred the meat, cook for longer, or remove the meat and cut in long slices, then return to the pot.

Ropa Vieja means "old clothes"---the meat and vegetables should be shreddy and fully intertwined. The longer and slower you cook this, the better. There is plenty of moisture from the chicken broth and vinegar---if you are a peeker, you may need to add more chicken broth; but otherwise, you'll get a good amount of juice at the bottom of the pot.

Serve over brown or white rice, with a ladle full of broth.

The Verdict.

Delicious. After a few days of sweet Thanksgiving food, we were ready for a different flavor.

The kids ate their meat separate from the vegetables, but did eat it. They also ate a ton of rice, because--well--that's just what they do.

I hadn't cooked the meat long enough when I took the above picture. I was tired, and just wanted to be done, and the kids were hungry. After we took some of the meat out, it cooked for another 3 hours on low, and then was perfect. The resulting stew was tangy and smoky at the same time---it was delicious. I ended up cooking on low for a total of 12 1/2 hours.

Thank you, Melanie!

Jumat, 28 November 2008

Perawatan Komputer dengan Defragmenter


Defragment adalah fasilitas yang dimiliki system operasi windows untuk untuk melakukan pengaturan tata letak data atau program yang tersimpan dalam media penyimpan data (storage).

Di dalam penggunaan computer setiap kali kita menggunakan program maka prosesor akan menggunakan data itu secara acak sehingga penempatan pada media storage pun dilakukan secara acak sehingga perlu dilakukan defrag

The CrockPot as an Air Freshener/ Odor Neutralizer


Day 333.

Happy Black Friday! I hope each of you had as wonderful of a Thanksgiving as I did. It was also terribly easy---we had 6 crockpot dishes and a turkey-in-the-oven. Lots of food, and a super-easy clean-up.

But.

At about 10pm last night, the house was cleared, and I noticed a funk. It wasn't bad, but it was a slightly sour smell of old mulled wine, and dirty dishes. Instead of actually cleaning the dishes and emptying the wine crockpot, I eliminated the odor.

With the Little Dipper!

The Ingredients.

--water
--baking soda (for the little dipper, I used 3 T)
--crockpot

The Directions.

Pour water into the crockpot you are going to use. Add baking soda. Mix. Plug it in and turn to low (the Little Dipper and some of the small ones don't have settings, they just plug in). Keep the lid off.

Let the baking soda do the job of soaking up unpleasant odors.

If you would prefer to use the crockpot as an air freshener, fill with water, and add:

--drops of essential oil
--potpourri scent
--2 teaspoons of vanilla or other desired extract
--ground cinnamon, and cloves
--a cinnamon stick
--slices of lemon

The Verdict.

I was quite pleased with how the baking soda really did absorb the kitchen odors. I took the mini crock into another room later and smelled the water----it smelled strongly of mulled wine.
woah.

Kamis, 27 November 2008

Sharing Internet pada Windows XP

Anda memiliki akses internet di rumah yang hendak anda bagi (sharing) dengan anggota keluarga anda yang lain ? berikut ini tips untuk melakukan sharing pada windows xp.


Sebelum melakukan sharing internet pada windows xp, pastikan dulu bahwa komputer yang hendak anda jadikan pusat terpasang dua buah Network Interface Card (NIK)/kartu jaringan. Satu NIC untuk koneksi Internet dan satu NIC lagi

CrockPot Pumpkin Pudding (crustless pumpkin pie)


Day 332.

Happy Thanksgiving! I hope you have a wonderful day full of warm memories and lots of love.

If you are in need of some last-minute crockpot holiday food ideas, here's the list.

This year we're going to have:
--cornbread stuffing
--sweet and sour caramelized onions
--candied sweet potatoes (I'll update the picture and recipe for this, too, after we eat)
--mashed potatoes with cream cheese and sour cream
--homemade cranberry sauce
--mulled wine
--this pumpkin pudding
oh! and an oven-roasted turkey.

I wasn't planning on doing any more Thanksgiving-y dishes; my mother-in-law is bringing store-bought pies and ice cream. My kids aren't huge pie eaters, and have never shown any interest in pumpkin pie. Like, EVER. But my seven-year-old convinced me last night that it's the crust of the pie that she doesn't like, but she likes the filling. And then her younger sister decided to say the exact same thing.

Crustless pie? That's easy. I can do that. This is much better than my original plan, which was to open a can of pumpkin pie filling and hand them each a spoon.

The Ingredients.

--1 can of pumpkin puree (15 oz)
--1 can evaporated milk (12 oz--the big can, not the little guy!)
--3/4 cup white sugar
--1/2 cup Bisquick-type mix (I used Pamela's Baking Mix)
--2 eggs
--2 T butter, melted
--1 1/4 tsp cinnamon
--1/2 tsp nutmeg
--1/4 tsp cloves
--1/8 tsp ginger
--2 tsp vanilla extract

The Directions.

I used a 4 quart crockpot and it was the perfect size. If you only have a big one, you can use it, but be aware that the batter will be spread out more and will cook much quicker. If you insert an oven-safe dish into the crock, it will work, but the batter will be quite thick and will take a VERY long time. Plan accordingly.

Spray cooking spray into your crockpot.

Set aside.

In a mixing bowl, combine all of the ingredients, and whisk until fully blended. No need to use a hand or stand mixer, just some elbow-grease.

Pour the batter into the prepared crockpot. Cover and cook on high for 3-4 hours, or on low for about 6. Check your "pie" after 2 hours on high, and 3 hours on low, then check every 30 minutes.

When fully cooked, the pie will look just like a finished pumpkin pie. The batter will have browned and will crack in a few places. The center will have set enough for you to touch it without getting batter on your finger.

Let sit in the crockpot until room temperature, then spoon into serving dishes and top with whipped cream.

The Verdict.

Perfect. It tastes fantastic, is gluten-free, and was terribly easy to do. We'll be making this again, and I'm happy to have it to serve today.

yay!

I'm off to peel potatoes. For hours.
serenity now!

Rabu, 26 November 2008

Fungsi IF AND Pada Microsoft Office Excel


Penggunaan Fungsi (Rumus) IF AND


Rumus MIcrosoft Office Excel IF AND biasanya digunakan untuk mencari nilai tertentu berdasarkan dua buah ketentuan ata dua buah persyaratan.



Jika kedua persyaratan itu terpenuhi maka diberikan nilai tertentu sedangkan salah satu saja persyaratan atau tidak ada persyaratan yang terpenuhi maka tidak mendapatkan nilai tertentu.



Format rumus/fungsi IF AND

CrockPot Baked Oatmeal Recipe


Day 331.

Thanksgiving is tomorrow. I think I'm in denial.

If you're looking for tried-and-true CrockPot Holiday (any holiday!) Dishes, here's a list.

Today, however, I'm posting about baked oatmeal. I started making baked oatmeal when my first was about a year old and I was working out of the house. The mornings were never long enough, and I wanted her to have something hearty (and healthy) for breakfast. I'd make a pan on the weekend and cut off squares each morning for her to eat in the car.
It worked really well.

Baked oatmeal can be uber-healthy, or packed with sugar. I've cut the sugar and butter in half since I first started making it. If you think your family will meet this with resistance, start with a full cup of brown sugar (no need to double the butter in the crockpot, there's plenty of moisture) and then cut it back each time. You can sneak in nuts (ground or whole), extra grains, fresh and dried fruit, and protein powder.

The Ingredients.

--3 cups rolled (not instant) oats (if gluten free, make sure they are certified)
--1/2 cup brown sugar
--2 tsp cinnamon
--2 tsp baking powder
--1 tsp salt
--2 T flax meal (optional)
--1 cup milk
--2 eggs
--2 tsp vanilla
--1/4 cup butter, melted
--3/4 cup dried fruit

updated 11/29: if you are going to use steel-cut oats, you'll need more liquid. I don't know how much though, so if you figure it out, let me know! :-)

The Directions.

I used a 4 quart round crockpot. You're baking this, but no need to vent the lid of the crock; keep all the moisture in.

I really wanted this to take 6 hours on low so I could see if it could be done overnight. It took 4 3/4 on low for me----so unless you hardly sleep, do this in the day time so you can keep an eye on it.

Mix all the ingredients together in the crockpot. I dumped in all the dry stuff, then added the melted butter and milk. Stir well with a spoon---make sure the baking powder gets dispersed evenly.

Cover and cook on low for 3-5 hours, checking every so often. This is done when the edges are brown and are beginning to crust, and the center is set. An inserted knife should come out clean.

Let it sit in the cooling crockpot for at least an hour before attempting to cut. The longer you let it sit, the more set and brownie-like the pieces will be.

The Verdict.

I made this on Sunday evening and it's already all gone. The kids hadn't had it in a while and had a bunch for breakfast each day and wanted it for dessert last night. The flavor is like a great big oatmeal cookie. I like mine heated with my morning coffee, and Adam likes to crumble his on top of yogurt.

Selasa, 25 November 2008

Belajar Menggunakan Toolbar Microsoft Office Excel

Pengenalan dan Penggunaan Toolbar Formating pada Microsoft Excel


Apa itu toolbar ? bagi yang sudah sering berpetualang dengan Microsfot office excel tentu sudah sangat paham akan toolbar tapi bagaimana dengan yang belum terbiasa atau masih dalam taraf belajar seperti saya.



Toolbar adalah tempat dimana diletakan icon-icon atau lambang-lambang yang bermakna sebuah perintah dengan maksud

CrockPot Chicken Adobo Recipe


Day 330.

I actually just got a pang of something weird when I typed that number in. 35 (36) days left in the year? Really? That's it? I actually feel really sad about that (today. tomorrow, I might decide to spend the afternoon jumping on the bed.)

Thank you so much for the wonderful birthday wishes, and for the great comments directed towards Adam. He read every one of them. Probably thrice. I've got a lot of scheming to do before his birthday, but it looks like he's going to be spending it with a thousand women for BlogHer.... that's a good gift, right?

I've never made Chicken Adobo before. My grandma read me this recipe over the phone out of a xeroxed booklet of International Food put out by my first grade class. We all really liked the chicken a lot, and have a bunch saved in the freezer for future soups. Thank you, grandma, for keeping the booklet!

The Ingredients.

--3 to 5 pounds of chicken meat (I used a whole chicken. Next time I will use boneless pieces.)
--1/4 cup soy sauce (La Choy and Tamari wheat free are gluten free)
--4 cloves garlic, chopped
--1 tsp black pepper
--1/2 tsp salt
--1/2 cup apple cider vinegar (can use regular white)
--4 bay leaves
--1 1/2 cups shredded carrots
--1 yellow onion, sliced in rings

The Directions.

If you have the time to assemble the chicken in a plastic zipper bag with the salt, pepper, soy sauce, garlic, and vinegar the night before, do so. The chicken will be much more flavorful if left to marinate overnight. Then dump out in the morning on top of the vegetables.

I used a 6.5 quart crockpot. If you use 3 pounds of chicken, everything will fit in a 4 quart or larger.

I had a 5 pound chicken. I did skin it, and I am certainly getting better at skinning chickens.

Rub the chicken with salt, pepper, and crushed garlic. If using a whole chicken, shove 2 bay leaves inside. Set aside.

Slice the onion in rings and place the rings at the bottom of the crockpot. Add in the shredded carrot---I used the bagged shredded carrot to save time. Put the chicken on top. Pour in the soy sauce and vinegar.

Cook on low for 7-8 hours, or on high for 4-5. This is done when the chicken is cooked through and has reached desired tenderness.

I cooked our whole chicken on high for exactly 4 hours. It was fully cooked, but completely fell apart. The vinegar is such a tenderizer that I wouldn't attempt this again with bone-in chicken--the bones freak me out with the kids.

The Verdict.

Delicious. This results in very flavorful and moist chicken. There is a lot of juice, and we served it over basmati rice. The kids each ate a plateful. When I make it again, I might put in some shredded cabbage---Adam and I both really liked the pickled vegetables an awful lot.


other great chicken recipes:

Vietnamese Chicken
Brown Sugar Chicken
Rotisserie-style chicken
Lemon and Herb Chicken
Whole Chicken with Salad Dressing

Senin, 24 November 2008

Gunakan Internet Yang Lebih Bermanfaat

Apa manfat internet ? semua pasti tau bahwa internet adalah suatu sarana untuk memperoleh informasi atau dunia informasi yang tidak terbatas, dan semua orang mengakui itu. Hal ini karena dengan internet kita bisa mendapatkan informasi apa saja, dimana saja dan kapan saja kita butuhkan.


Ada sisi baik dan ada sisi buruknya dari internet, kesemuanya itu tergantung dari si pemakai atau pengguna

CrockPot Mulled Wine Recipe


This recipe is part of Oprah.com's Holiday Food Blogger Roundup. Welcome Oprah.com readers! Thank you for stopping by. xoxo steph

Day 329.

It's day three hundred and twenty-nine, and it's my birthday.


I have a lot to be thankful for this year. It's been a total trip.

Last Friday, Adam called and said that he invited a bunch of friends over to celebrate my birthday. He told me not to ask questions but that they were coming, and that he'd handle it all. It's a good thing our house is always thirty-minutes-away from being company-ready.

I put on a crab dip, and this mulled wine for our friends. I had fun fiddling in the kitchen, and the kids went to town making decorations.

When everyone was settled and had some of the mulled wine (quite enjoyable!) Adam laid out his surprise: he was dropping the six ladies off at a restaurant and the boys were going to watch all of the kids. My friends were in on it, and we all piled into the mini van. When we got to the restaurant, a table was waiting piled with appetizers and champagne.

Wow. The night couldn't have been any better. Thank you Adam, and thank you so much to Jennifer, Karen, Claudia, Nancy, and Carol. I love you all so much.

And now I'm crying. Again.

The Ingredients.

--2 bottles dry red wine (I used Cabernet Sauvignon)
--1 cup freshly squeezed orange juice (about 3 oranges)
--2 more oranges (one to float on top, and one for garnish wedges)
--3/4 cup white sugar
--1/4 tsp allspice
--1/4 tsp cinnamon
--4 cinnamon sticks
--4 whole cloves

The Directions.

Serves 6-8 (sort of. it really depends if you want your guests to have a taste, or a bunch. I'll double this next time.)

I used a 6 quart crockpot.

Open the wine. This was really very hard for me. I need one of those fancy wine opener thingies. It seriously took a good twenty minutes for me to open one of the bottles, and I got all sweaty and frustrated. ugh.

Squeeze the oranges to get 1 cup of juice. I'm sure you could get away with using store-bought juice, but the pulp floating around is what's kind of neat about mulled wine; it's more rustic this way. And oranges are in season.

Stir in the sugar, and add the ground spices. Float the cinnamon sticks and whole cloves on top. Slice one of the oranges in rings, and float the rings on top.

Cover and cook on high for 2 hours, or on low for 4.

You want the wine to get as hot as a traditional hot beverage.

Ladle into mugs, and serve with a fresh orange wedge.

When serving, leave the lid off and the crockpot on "low."

The Verdict.

I liked this much more than I thought I would, and look forward to making it again. I will on Thanksgiving. I like that you can use terribly cheap wine (Adam went shopping the night before and Trader Joe's was already closed, but this is a great use for 2 Buck Chuck---although he assures me that the Sutter Home was on sale for $3.99) and still wow even the toughest wine snob.

Minggu, 23 November 2008

Belajar Funfsi IF Microsoft Office Excel

Fungsi IF


Setelah pada postingan kali lalu kita pelajari tentang fungsi SUM, AVERAGE, MAX dan MIN maka kali ini kita akan maju ke tingkat yang lebih tinggi lagi yaitu fungsi logika IF.

Format rumusnya adalah =IF(persyaratan pertama;nilai1;=if(persyaratan2;nilai2 ... ;nilain)


dari formula di atas jika dilogikakan maka dapat dibaca, Jika persyaratan pertama terpenuhi maka nilai1 ditampilkan,

Salsa Chicken and Black Bean Soup

Day 328.

My kids each ate their weight in this soup. It smelled delicious while cooking, and tasted even better.


This is a brain-child of Natalie, who emailed me early last week. The neat part about this soup is that she (and then I did, too!) used dry black beans instead of canned or
pre-cooked dried beans.

The beans will take a super long time to soften, so this is a great candidate for those who are out of the house for long periods of time. It's soup---there's a lot of volume, and it won't burn on you.
The even-neater (more neat?) trait of this soup is that there is no chopping or dicing, yay!


Thank you so much, Natalie!


The Ingredients.
--1 pound chicken (I used frozen breast tenderloins)
--1 cup dried black beans (or 2 cans, drained and rinsed)

--4 cups chicken broth
--1 cup sliced mushrooms

--1 cup frozen corn
--1 jar prepared salsa (16 oz)

--1 1/2 tsp cumin
--1/2 cup sour cream (to stir in at the end)

--shredded cheddar cheese, avocado slices, cilantro (all optional)


updated 12/15:
Pace salsa is pictured in the ingredients. Pace, and many Campbells products are now no longer being classified as "gluten free"---please read all labels and use your best judgment when making choices to feed your family. You can read a discussion about the labeling, here.

The Directions.


I used a 6.5 quart crockpot. You will need a 4 quart or larger.


If you know you are going to make this the night before (yay for meal planning!) soak the black beans in enough water to cover and another 2 inches overnight. In the morning, drain the water and rinse the beans.

If you don't have super hard water or live in a super high altitude, you can quick soak the beans by pouring boiling water over them and let them sit for an hour or two. I did an hour, but 2 would really be better if you have the time.

Drain and rinse the beans.
Add to the crockpot. Put in the chicken, and add the broth and salsa. Pour in the corn and mushrooms, and add the cumin. Stir, but don't disturb the beans---let them stay at the bottom of the pot, closest to the heating element.

Cover and cook on high for 9 hours. Yup. High. For 9 hours. It took a crazy long time for the beans to soften, but they did.

If you are using beans you soaked overnight, canned beans, or pre-cooked beans, you can cook on low for 6-8 hours, or on high for 4-5--similar to normal soup-cooking time.


If you'd like to thicken the broth (I did this), you can use your immersible blender (I love that thing) to blend a bit of the beans and chicken. If you don't have one, scoop out 2 cups of the soup and carefully blend in your traditonal blender. Stir the mixture back into the crockpot.

Stir in the 1/2 cup of sour cream before serving, and garnish with shredded cheese and avocado slices.


The Verdict.


We all loved this. My crockpot was more than half way full, but the four of us ate so much we only had a small tupperware full for leftovers.

This is a new favorite in our house. I thought that the salsa might be too spicy, but the kids didn't complain once. They are used to spicier things than some of their peers, but I didn't find the soup spicy at all, just packed with flavor. If you're concerned, stick with mild salsa. You can always add some white or red pepper to the grown-up portions.


Thanks again, Natalie, for a new family-favorite!

Sabtu, 22 November 2008

CrockPot Crab Dip Recipe


Day 327.

Dip! With crab meat! And cream cheese!

Do better things than this exist?

I don't actually think so.

We had a houseful of people last night and I was thrilled that Christine emailed me earlier in the week with her famous crab dip recipe. I changed a few things, but this is definitely her recipe. Thank you, Christine!

The Ingredients.

--1 pound crab meat (imitation crab meat is NOT gluten free. Go for the real stuff!)
--3 packages (8oz each) cream cheese
--1/2 cup buffalo wing sauce (or you can use 1/2 cup jarred salsa)
--1 can chilies and tomatoes, drained (Rotel)
--1/2 cup milk
--2 lemons, optional

The Directions.

I used a 4 quart crockpot. This feeds 20 people as an appetizer, or one cranky woman as a meal.

Sort through the crab and make sure that there aren't any shells.

Cube the cream cheese and put it into your crockpot. Plug it in and turn to high to begin melting the cream cheese. Add the buffalo wing sauce (or salsa), milk, and the drained can of Rotel.

Put in the crab, and stir gingerly to combine.

Cover and cook on low for 2-3 hours, stirring every 20 to 30 minutes, or on high for no more than 2 hours, stirring often.

Serve with your favorite crackers, cubed bread, or celery sticks.
If you plan on serving out of the crockpot, you can "pretty it up" by inserting slices of lemon all the way around the edge of the dip in the crock.

The Verdict.

This was a hit. The crock was scraped clean.

Kamis, 20 November 2008

Panduan Membuat Email Pribadi Gratis


Masih banyak sahabat kita yang belum punya alamat surat elektronik yang biasa disebut e-mail atau electronic mail. Jangan seperti iklan di televisi ya yang ceritanya salah seorang teman menanyakan apa nama alamat email kamu ? terus sang teman pun dengan polosnya menjawab Jl. Ki Hajar Dewantara Gang Kakak Tua Nomor 100 (aneh bukan ?). Tapi sebetulnya bukan aneh tapi karena memang si teman ini

Rabu, 19 November 2008

Panduan Setting Modem CDMA Venus VT-12 Dengan Perdana StarOne


Sebelum memasang modem CDMA Venus Vt-12 pada port USB computer atau laptop anda, lakukan installasi software untuk modem venus vt-12 dengan cara:



Langkah pertama,

Masukan cd driver ke cd/dvd-rom drive, apabila autorun berfungsi maka akan langsung muncul jendela installasi driver modem venus vt-12, namun apabila autorun tidak berfungsi maka kita harus melakukan installasi secara manual

Selasa, 18 November 2008

Download Software Gratis


Halaman download ini disediakan oleh blog Belajar Ilmu Komputer untu membantu para pengunjung blog yang membutuhkan tautan download perngakat lunak yang diperlukan, khususnya perngkat lunak gratis yang dapat diperoleh secara gratis dari penyedianya. Meskipun tidak semua perngakat lunak gratis ada di sini tetapi dengan bantuan halaman ini semoga makin mempermudah para pengunjung menemukan

Tips Memilih Anti Virus Yang Tepat


Sejak datang di Bali tahun 1988, tepatnya bulan Juli 1988 dan mulai saat itu juga saya mengenal yang namanya komputer, kebetulan seorang saudara saya yang memiliki tempat kursus komputer, yang pada saat itu memang sangat jarang ditemukan tempat kursus komputer. Tempat kursus komputer saudara saya ini termasuk salah satu tempat kursus komputer yang cukup terkenal di daerah Denpasar bahkan di luar

Senin, 17 November 2008

Belajar Microsoft Office Excel Bagian 5


Mengetahui Nilai Total, Rata-rata, Maksimal dan Minimal dalam Microsoft Office Excel



Sudah siapkan anda untuk masuk pada pelajaran kita kali ini yaitu untuk mencari nilai tertentu seperti nilai Total, Rata-rata, Maksimal dan Minimal.



Untuk mencari nilai Total rumus yang digunakan adalah SUM (summary), formatnya :

=sum(sel awal..sel akhir)

contoh :

Misalkan anda diminta untuk menghitung

Minggu, 16 November 2008

Mengenal Kerusakan Komputer


Beberapa hari yang lalu saya sibuk memperbaiki komputer di sekitaran kota denpasar, hampir setiap hari pada sore harinya saya memperbaiki komputer yang rusak.



Dari sekian banyak komputer yang saya perbaiki kesemuanya memiliki tanda-tanda kerusakan yang hampir sama yaitu CPU (Central Processing Unit) hidup tapi Monitor Berkedip-kedip (maksudnya lampu indikator pada monitor berkedip-kedip), ada

Jumat, 14 November 2008

Belajar Formula Sederhana Microsoft Office Excel

Belajar Membuat Formula Sederhana


Kali ini kita akan mulai dengan mengenal formula atau rumus-rumus yang sering digunakan dalam microsoft office excel.

Kita awali dengan pembuatan sebuah tabel excel dan simpan (save) dengan nama TABEL4 dengan format sebagai berikut :
Pada sel A3=NO, B3=NAMA KARYAWAN, c3=GAJI POKOK, D3=TUNJANGAN, E3=PINJAMAN dan F3=GAJI BERSIH.

Kemudian dari sel A5 sampai

Selasa, 11 November 2008

Cara Membuat Banner Teks Dengan Cooltext


Para blogger yang belum bisa membuat banner sendiri sangat bersyukur karena ada yang berbaik hati menyediakan layanan pembuatan banner atau logo dengan cuma-cuma, meskipun masih banyak keterbatasan-keterbatasan yang dimiliki namun ya namanya juga yang gratisan ya harus dimaklumi perlu pembatasan.



Walaupun kota Denpasar pagi ini turun hujan, sehingga membuat penampilan penulis hari ini agak

Minggu, 09 November 2008

Pasang Banner Belajar Ilmu Komputer


Bagi pengunjung yang mau memasang link ke Belajar Ilmu Komputer dengan Banner seperti di bawah ini ?





Copy code/script di atas dan pastekan di blog anda.


Bagaimana cara membuatnya ? Bagi yang sudah terbiasa dengan design banner atau logo tentu tidak masalah tapi bagaimana dengan kita yang masih awam ? pertanyaan ini bisa ddi jawab dengan membuatnya dari situs yang menyediakan design banner

Jumat, 07 November 2008

Perintah DOS DIR


Perintah DIR adalah perintah DOS yang berfungsi untuk menampilkan file-file dalam sebuah drive atau folder aktif.



Perintah ini sama dengan perintah Copy pada postingan terdahulu yang sama-sama di jalankan dari prompt drive.

Perintah ini juga paling sering digunakan bagi yang sudah terbiasa bergaul dengan Command Prompt, tidak usah melanjutkan untuk membaca, tapi bagi yang belum terbiasa

Kamis, 06 November 2008

Cara Sederhana Mengetahui Bad Sector Hard Disk


Komputer anda lambat ? atau bahkan sering hang ? kalau benar itu terjadi, memang banyak penyebab yang dapat menimbulkan komputer anda menjadi lambat antara lain karena terserang oleh virus, data yang tersimpan dalam hard disk terlalu besar kapasitasnya misalnya berupa film-film, foto-foto, selain itu juga bisa jadi karena hard disk anda sudah ada bad sectornya, sehingga proses akses data yang

Rabu, 05 November 2008

Belajar Membuat Garis Tabel Microsoft Office Excel

Membuat Garis Tabel pada Microsoft Office Excel
Tabel identik dengan garis, untuk itu perlu ketelitian dalam membuat garis dalam sebuah tabel.

Sebelum kita lanjut ke cara pembuatan tabel, terlebih dahulu perhatikan gambar di bawah ini.

Dari gambar di bawah saya mengambil contoh sel B5, dari sel B5 tersebut terdiri atas garis bagian atas, garis bagian bawah, garis bagian kiri dan garis bagian

Selasa, 04 November 2008

Mengatur Default Directory Penyimpanan File Excel


Kenapa musti diketahui cara mengatur directory yang digunakan untuk penyimpnan file ? ini karena masih banyak pengguna (user) komputer khususnya yang masih pemula seringkali mengalami kehilangan file yang telah dibuatnya dari microsoft office excel atau dari program aplikasi lainnya, ini karena pengguna belum memahami fungsi dari folder itu sendiri, sehingga saat menyimpan file mereka (para

Senin, 03 November 2008

Membuat Folder pada Windows Explorer


Untuk mempermudah dalam proses pengolahan file-file sebaiknya kita membuat folder. Apa itu folder ? folder adalah semacam suatu tempat yang sengaja dibuat untuk menyimpan file-file.

Baimana cara membuat folder ? ada beberapa cara membuat folder namun kali ini saya mencoba uraikan cara membuat folder dari windows explorer.

Ikuti langkah berikut untuk membuat folder pada windows explorer.



Minggu, 02 November 2008

Belajar Microsoft Office Excel Bagian 2


Cara Membuat Tabel Pada Microsoft Office Excel 2003

Kali ini kita akan mulai dengan membuat tabel pada Microsoft Office Excel, sebelum memulai saya jelaskan sedikit tentang sel (cell). Sel yaitu tempat perpotongan antara Kolom dan Baris, misalnya saja anda menempatkan pointer pada kolom ke C dan baris ke empat maka akan dibaca "pointer berada pada sel C4".



Oke sekarang mari kita mulai dengan