New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 141st installment in their series of digital spreadsheet magic tricks, you'll learn how to take the number 1 (for day one of the month) and use the DATE function to convert it to a serial number formatted as a date.
How to grow sweet potatoes
In this video you will learn how to get your potato plant growing using a 5 gallon bucket. Start by taking your 5 gallon bucket and drilling a series of small holes at the bottom for draining. Next line the bottom of your bucket with about 2 inches of rocks to help with drainage and top with a layer of weed block and a couple inches of soil. Now your bucket is ready to add a budded potato. To make your potatoes bud out simply leave them in a bag and place them in the dark for about a month un...
Jonathan Wallace demonstrates how to pickle beet root and store garlic. First, boil the beet root. Keep the root and about three to six centimeters of the stem on the beets during the boiling process. Next, create a spiced pickling vinegar by using 2 1/4 liters of vinegar, cinnamon powder, 12 cloves, two tablespoons of coriander seed, one tablespoon of mustard seed, four dried red chilies and two teaspoons of black peppercorn. Boil the ingredients together and then let it simmer for 15 minute...
In this video tutorial, viewers learn hoe to apply Frontline for dogs. Be sure that you get the appropriate amount of dosage for your dog. Frontline is a topical flea intake preventive for dogs. Do not let your dog go into water 72 hours before and 72 hours after apply the product. Begin by apply the product in between the shoulder blades. Do this by parting the fur and apply the product onto the skin. Also apply the product at the base of the tail. This process needs to be done once a month....
The video tells you have to protect your car using waxes and sealants. It begins by showing you how to apply a premium wax using Dodo Juice Paste Wax and a soft applicator by ensuring the wax is bonded to the paint sufficiently prior to removing an amazing finish can be created. A properly waxed car can show high shine and gloss and even improve the color of the car. The next segment of the video shows you how to apply synthetic sealants to protect the car, using Duragloss polish prep agent f...
This video demonstrates how to make rootwork oils for spell craft. This will take an investment of time to get the most out of this. You must have a preservative in your oil for this project. Here, you will need to use either jojoba oil or vitamin E oil. These will not have to be used as the base, but they will need to be present for preservation.
In this video, we get tips on how to get into shape and add fitness into our lives. One alternative to get fit is to just add fitness into your everyday routine instead of having to add in a specific work out regimen. Something you can do is take the stairs instead of the elevator and park further away from the store. You can also place things to keep active at your desk including weights and doing leg exercises. While on breaks, you can also do exercises with co-workers. All of this exercise...
This Home and Garden video tutorial shows how to deal with fire ants in the garden. This video is from Danny Lipford. These fire ants have been travelling fast and are spreading rapidly throughout the USA. When a mound of the ants is stepped upon, the entire ant colony will bite and each ant will bite repeatedly. Some people have severe allergic reactions to the ant bites. There are some new products in the market like Over’n Out. You spread it on the entire garden. It takes about six weeks t...
Falsely suspended on YouTube? Get you account back within a month. When your account is suspended on YouTube, all your videos will still be intact. Search "reopen account" without quotes in YouTube. Open the first video that is displayed. The video will show you link to contact YouTube. To get things straight, visit the link as stated in the video. You will get an email from YouTube explaining your penalties which are usually copyright claims. Click on each penalty and you'll be given a set o...
You can create a calendar for your computer using VB.net. It is extremely easy and very quick to make this for yourself. First you're going to select 'month calendar' and click that into your form area. Now center the box closer to the calendar, and change the name of your application to monthly calendar. Now all you need to do is test the application. Go up to the Start Debugging button and make sure everything is good with that. That's all you need to do-now you have your very own little ca...
Learn how to make a kissing ball for Christmas with these steps outlined in this video tutorial. A kissing ball is essentially a bunch of pine boughs in the shape of a ball decorated with red ribbon and pine cones that can be used as seasonal decorations. You need to cut the boughs of pine in the desired lengths you want. The longer the boughs, the larger the ball. You will need a florist's Styrofoam ball soaked in water, which will be covered with the pine boughs. Once the ball of pine is fo...
This video shows how to control a fire ant problem in your yard. Fire ants don't do any damage to your yard, but they can cause damage with their bite.
This video demonstrates how to make your own play dough with simple ingredients – flour, salt, cream of tartar, cooking oil, water, and a few drops of food coloring.
This video discusses how to mend a broken heart after being dumped by a significant other. The video starts with a question being asked a guy who was just dumped and now his best friend is trying to go out with her. The presenter takes a satirical stance on the question and basically says time heals all pain. The presenter then says that is why they waited four months to answer his question, in the hopes that his broken heart would be healed. Finally, the video offers the advice of moving on ...
In this video Dr. Schultz will show you how to control extreme underarm sweating. If you suffer from extreme underarm sweating, despite regular use of antiperspirants, follow these steps: Make an appointment with your doctor so that they can give you a prescription for a topical antiperspirant called Drysol. This liquid is applied once a week, at bedtime, and is covered with cling wrap. After a few weeks you will see a significant reduction in the amount of underarm perspiration you experienc...
You should watch this video if you want to improve your credit score with just 3 steps. To improve your credit score: Check your credit report. It is where your score comes from. You can also get a free copy of your credit report once a year at Annual Credit Report. Check it for errors. Timing. If you're going to apply for a loan as the application month approaches, stop charging because if your balance happens to be reported while it's big, it will temporary lower your score. Don't close you...
In this video Dr. Schultz will show you how to fix stretched or wrinkled earlobes. Here are a few things you can do to remedy stretched or wrinkled earlobes: Laser treatments, especially carbon dioxide treatments, a specified amount of heat is delivered to the skin, and it causes a contraction, which causes a plumping of the earlobe, removing the wrinkles. The results will last for years. With injectable filler treatments like collagen, you will also find a plumping of the skin, but they will...
In this video from Socoolscienceshow Crazy Chris shows us how phony fortune tellers make it seem like they are predicting the future. He uses a crystal ball in this demonstration. He says that anyone can pretend to predict someone's future just by spouting out some common future predictions such as in "3 to 7 days you will have a disagreement with a loved one, 4 to 6 months you'll find a new love, and 2 to 5 years you'll change your career." Fortune telling is completely fake and Crazy Chris ...
In this video from dend359, we learn how to get rid of acne scars. First, he said he looked into laser treatment but that's too expensive. Then he found Divine Beauty ECIT Rejuvastamp treatment and it's much cheaper and similar to laser treatment. It did take about 3 months to fix the scars. He shows us one scar that has improved over time and recommends Divine Beauty's treatment. It requires a lot of patience because this treatment will take some time. This video will benefit anyone looking ...
This video gives a brief description of how to prepare and cook baby artichokes. Baby artichokes vary in size based on the season, may being the best month to get them. To avoid getting a bitter flavor from your artichokes be sure to remove the skin, this is best accomplishes by brushing,rinsing, peeling, and cutting all of the green outer layer until you can see the pale yellow inside. To preserve the color of your allow them to sit in lemon or vinegar water and drain completely when done. C...
This video demonstrates how to sharpen a carbon steel knife using a whet stone. Depending on how much you use the knife and how you use it, the knife might need to be sharpened once a month or every other week. First the whet stone should be lubricated using water. Then place the knife on the whet stone at an angle as shown in the video and drag it up and down while applying ample pressure to sharpen it. Do not twist the knife. Depending on the hardness of the knife and the roughness of the w...
Want to stay warm while out in the cold without looking like a frump? This video is for you! Stylist Jackie O Dee shows you multiple ways to tie a scarf to keep looking stylish during the cold winter months. Some styles work well under outerwear while others can be pinned and worn indoors with your regular outfit. The great thing is that many of these techniques can be transferred to lighter spring scarves as well as this instruction can be used all year long.
This instructional video walks you through how to get great abs in 3 minutes. The person that did this video lost 100 lbs in just 3 months. You should perform each exercise for 20 seconds with a 10 second break in between daily. After completing all 6 you should repeat 2-3 times. It shows you exactly which exercise to do without talking but using music. After successfully doing these exercises daily you should see results in no time at all.
Patti Moreno the Garden Girl shows how to grow an environmentally friendly, low maintenance, drought and insect resistant Eco-Lawn, a blend of 7 Fescue grasses for shady, rocky, and sandy soils. Prepare the bare ground by raking debris. Spread the seed, and then water the seed once a day for the first month. The grass sprouts in 7-14 days. Fill in patches with more seed. Remove leaves, but don't disturb soil and seeds. To convert to an Eco-Lawn, mow the old grass very low, and then spread new...
This video is for those people who have been doing a lot of exercise for months and not getting stronger and bigger and not developing muscles. The techniques that are being shown here are advised by the professionals and skilled trainers in this area. So the technique that can be used is forced negatives. It is called so because in this technique we are trying to lift more weight than what we can possibly lift normally. About ten percent more. It is done by using out other hand to give an ad...
This how-to crochet video offers a simple pattern and instruction for stitching your own cute and easy crocheted hat. Knitted hats don't have to be for winter. While a cozy hat will protect you from the cold, a lighter yarn can add some style in warmer months as well. Check out this video d.i.y. arts and crafts lesson and learn how to crochet your own knot stitch cover for a ball cap.
This how-to crochet video offers a simple pattern and instruction for stitching your own cute and easy crocheted hat. Knitted hats don't have to be for winter. While a cozy hat will protect you from the cold, a lighter yarn can add some style in warmer months as well. Check out this video d.i.y. arts and crafts lesson and learn how to crochet your own beanie or cap style hat.
In honor of DIY Wedding month, Meg shows us some awesome wedding lighting solutions and nice personal touches to make your day extra special. This how-to decorating video will show you ways to plan a beautiful, personalized wedding.
I have always loved the idea of faithfully keeping a journal with something written or drawn for each day of the year. In practice it has never worked. I decided that I might have a chance if I only had to write one word a day and that it was important to keep it small and simple so I wouldn't be tempted to start more elaborately and then quit because I couldn't live up to the expectation. I designed a series of small books, one for each month, that go in a box made from a cereal box. Learn h...
For Breast Cancer Awareness month, the look in this how-to video helps you remember with a lots of pink. Use the following cosmetics to create this look: Shiseido Dual Balancing Foundation, Bare Escentuals Mineral Foundation, MAC Emote Blush, MAC Pleasantry Blush, MAC Cream Color Base in "Pearl," Bourjois Liquid e/s in "Rose Electron," Urban Decay Scratch e/s, Urban Decay Flash e/s, MAC Gesso e/s, MAC Blacktrack Fluidline, Urban Decay 24/7 Eyeliner in "Zero," Shu Uemura Lash Curler, Bourjois ...
Gardener P. Allen Smith give us some tips on how to care for our lawns during the hot summer months. You need to choose the correct type of grass seed and soil to suit your area and local weather conditions. In the summer, let your grass grow a little longer so that the blades of grass can shade the roots. Watch this instructional gardening video to learn how to maintain a fresh summer lawn, without dumping unnecessary fertilizers onto it or over watering the brittle grass.
Smoke machines can add great atmosphere to any occasion. But your smoke machine can get clogged. You need to clean the smoke machine every 6 months. This tutorial teaches you how to clean your smoke machine. Great care must be taken as the smoke or steam is very hot and can burn you in a split second. Watch this how to video and soon you will have a sparkling clean smoke machine.
Triceps tendon ruptures are not very common, but they are a debilitating injury. A triceps tendon rupture may require surgery. Learn how to treat sports injuries in this how-to video on health and rehab.
Get inspired from the smell of paint and, well, start painting.
One way for a middle-aged person to look better than ever is to sit on a patio surrounded by well-aged pots. Flaking, lichen-covered clay pots give the impression that they’ve been around a lot longer than you have. And because antiqued pots look expensive, everyone will think that your investments are doing well and your children have moved out. There are three methods of giving your pots the beauty of antiquity. Two of these techniques take minutes, and the other one takes months.
We next discuss trimming regular hedges. Most people just want a hedge that's tidy and neat, one that performs a function of blocking a view. We discuss some newly planted Boxwoods. Glenn planted these several months ago and wants to keep these low growing, about the height of the wall behind them. When the new growth starts to come up and the plant has reached its desired height, he prunes them. Glenn leaves an open space between the plant and the wall, this allows for good air circulation, ...
Learning the basics about your body during pregnancy can help you better understand the physical changes you'll experience over the next few months. Know about your body changes during pregnancy.
This isn't your ordinary Scrabble fiend, but relax... Scrabble was not the reason behind the death of this Pennsylvania woman's baby. But nonetheless, it's a horrible story of parents who'd rather neglect their own flesh and blood, rather than their pets.
As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 19th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate return on equity, assets, and profitablility — return on investment (RoI).
