In this how to video, you will learn how to sort columns in Excel with the Excel Experts. This is great if you want to learn the basics of sorting in the program. First, you must have Excel installed and running. Open up a spreadsheet that needs columns to be sorted. Select the column. Go to data and sort. Click options and select left to right. Choose the row you want to use and select the order. To undo this, go to sort and change the sort order. This video offers straight forward advice fo...
Orchids are amazing flowers to grow, but you have to do it just right. If your orchid is starting to wilt or is no longer growing properly, check out this tutorial and get useful tips on how to revive it. In this video, Tom and Joani Maccubbin show you the best ways to re-pot and clean up orchids to keep them living for years. So, before you add this lovely flower to your garden or home decor, make sure you check out this advice, so you can enjoy them for a long, long time.
Women have beautiful faces, don't they? They are so much more delicate and intriguing than a man's face. In this tutorial, learn how to do those pretty mugs justice with tips from Isaiah. You will learn the basics of drawing female faces and understand how they differ from that of a man or child. So, if you are ready to start drawing realistic looking people, make sure you check out this video and get some worthwhile advice. After that, all you have left to do is grab a pencil and start sketc...
If you are in the mood for a quick dinner, check out this video. In this tutorial, learn how to eliminate all of that mess and waiting that comes along with using your oven and make a super fluffy baked potato in your microwave!
In this how to video, you will learn how to properly throw a football. You will need a football to do this task. First, position your feet parallel to your shoulders while you are getting ready to throw. Place one hand on the lace and the other on the opposite side. From here, pull your elbow and the football behind your ear ready to throw. Now, put each step into one quick motion to complete the throw. Keep on practicing this to get the perfect throw down. This video offers great advice in s...
If you’re an entrepreneur or in need of a little more professional marketing then you will need a business card. This video will show you how to create your own business card using Adobe Illustrator. You will need to make sure you are keeping your work with in the standard card size. You can make your own logo or a name title. You will see tips and helpful advice for how to have the best results for your card. You will see an example card which is print ready. Once you get this process down i...
The first advice in this video on how to choose a camping tent is to consider the size of your family. You may want one tent for the whole family or one for the kids and one for the adults. Take time to choose a good camping tent that will last. You may need to spend some money to get a good investment in a tent, one that will last. Do you need the tent for car camping or carry camping? For carry camping you need lightweight materials that will be easy to carry. Large tents may have several r...
Holly Chegg shows the best way to peel and chop fresh garlic in a quick way! She first shows us how to peel off the skin in a perfect manner using a simple technique that everybody should be able to do. It is practically fool proof. She then shows us some easy ways to chop up our garlic into the perfect size, depending on your preference. Don't have time to buy and chop up your own fresh garlic for every one of your family's cherished recipes? Holly Chegg leaves you with advice on using the g...
In this video, John Heaney gives advice on how to answer a simple but difficult question during a job interview. If interviewers ask job seekers to tell them about themselves, they can be put on the spot and be unable to even begin to answer the question. Heaney puts this question into perspective from the employer's perspective. For instance, he reminds you to remember that you are applying for a job and your answer should be related to your technical abilities rather than your personal inte...
Ron Hazelton explains how to protect your foundation or basement wall from being affected by water that is discharged from your downspout. He explains how downspout extenders can be used to carry the water away from the foundation. Ron will show you three variations of downspouts that you can use. You'll learn how to install each kind of downspout so you can decide which is right for you. If you follow the advice given in this video, you're sure to further protect a very important part of you...
This video questions whether or not the writer should stay with her boyfriend who is living with his last girlfriend. The advice given is it's dangerous. If you truly love this guy then you want a personal relationship with him. It’s going to be hard with him living with his last girlfriend. He may be truthful about not wanting to be with her. On the other side of the coin it would be so easy for him to accidentally slip up. Since the ex-girlfriend and he have been down that road before it wo...
Today, Dan and Jennifer are confronted with a difficult question. A woman is in a relationship with a man that still has a 'relationship' of sorts with his ex. The woman is conflicted because she does not like the intimacy that goes on between her boyfriend and his ex. Dan and Jennifer ask several questions to the distraught woman to perhaps allow her to discover the key to her issues. Dan and Jennifer even suggest that there might be a child or maybe even a health issue that has to do with t...
Eric Rochow of Real World Green gives us advice on making our computers more environmentally friendly. This video first explains that screensavers are not green. Screensavers require a computer to use its processor. Ideally, when you're not using your computer it should be in sleep mode and your monitor should be in sleep mode as well. This saves a lot of energy. Also, at the end of the day, turn off your computer and monitor. Don't let them run all night. An interesting fact from the Departm...
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 ...
This tutorial will help you uninstall software or programs from Windows XP. It can be used easily by beginners who have limited knowledge of the operating system. The instructor shows a visual step-by-step tutorial on how to find and use the Add or Remove Programs feature, clearly explaining and showing what you need to do, including some extra advice on follow-up checking. Make sure that when you do go to Uninstall a Program that it is the correct one and read all of the screens during the p...
In this video tutorial, viewers learn how to finish a basement by laying out and planning. Planning the lay-out and design of the basement is an important part of finishing or remodeling a basement. Learn how to get new ideas as you design and lay-out your basement floor plan. Viewers will learn how to finish the basement space with expert tips and advice on home improvement. Make sure the basement is empty. Make measurements and mark them on the wall or floor. For a bathroom, there should be...
Learn how to maintain your heart health at any age! Great advice for all women because the younger you are the better chance you have at protecting your heart and preventing heart disease. Starting at age 30 you should start getting cholesterol test just to keep yourself in check. Once you hit 40 you should start scheduling stress echo cardiograms which can indicate if there are problems with your heart. Once you reach 50 you really need to be aware of the signs and symptoms of a heart attack...
This short tutorial will give you advice on approaching multiple choice exams. A multiple choice exam consists of one question and four possible answers, and only one of these answers will be correct. Make sure you know the layout of the answer sheet, and understand where you must mark your answers. Be careful of the trick answers, as there will almost always be one. read all the answers carefully and make sure you don't mark two answers for a single question. If you don't know the answer, ju...
Have a passion for crochet or knitting? This video is perfect for you! The free tutorial offers splendid advice and instructions about making a beautiful solid-striped scarf. Sit down and gather your supplies and prepare to make a cleverly constructed scarf while watching this video. Follow the instructions as precise as you can. Within the hour or so, you can loom knit your own scarf and maybe even a few other items using techniques and skills acquired from this video!
Draw23 presents a video demonstrating how to draw a face. The video uses no instructions or advice, it just shows plainly, in fast-motion, how to draw a realistic portrait. First, an outline of the face is made, including lines indicating where the eyes, nose, and mouth will be placed. The next step is drawing the features with minimal shading. Next, heavy shading is added, and finally, some last-minute details to perfect the drawing. By watching this video, you can see the proper technique u...
A young girl teaches us how to do a "Mashed Potato" dance. She talks us through step by step instructions on the proper way to do this dance. This is a rather simple dance and she slowly shows each step and narrates as she demonstrates. The feet are first faced inward then rotated outward. Repeating it inward and outward quickly, moving your feet apart a bit after each rotation and you finally have the Mashed Potato dance. She also offers extra help and advice for those who did not understand...
KnitWitch.com will show you how to take out purl stitches in your knitting on this easy to follow video. Tinking, tink, which is knit spelled backwards, is the actual knitting term for removing stitches. This shows how to tink purl stitches and gives great advice on how to hold the yarn to make it easier to see and remove the stitches. As you can be sure that at some point you will have to take out stitches when you knit by following these steps and tips it will be a much easier process.
This video gives you the right way to answer the interview question, "Tell me about yourself". Start with your most significant point. The advice is clearly stated and highlighted by adding text to the video. The example is well done and explains a little of what not to do also. The viewer has an excellent idea of what to expect and how to deal with not only this question, but other similar questions pertinent to job interviews.
In this tutorial the author shows how to make a cool ASCII E-mail signature. He uses Hotmail as an example. He directs how to find the options in the Hotmail email and points us to the location where we can make a Personal e-mail signature. Now he demonstrates how to make sample ASCII signature. As the signature allows only text the author advices to user a tool called JavE to make a good signature. He now shows how to download that software for free and how to use it. Now using this tool he ...
Eating a pomegranate for the first time can be a daunting task. This great tutorial by RawKristen demonstrates, step by step, how to wash the fruit, cut it open and which parts to eat. Both nutritious and delicious, the pomegranate is an excellent addition to your diet that you shouldn't pass by during your next visit to the grocery store. This tutorial covers helpful knife handling techniques and tips, advice on how to choose a ripe fruit and how to get the most out of what is inside.
Did you enjoy Fantastic 4? Was your favorite character Susan Storm? Well, this video is a comprehensive step by step guide to how to draw Susan Storm from Fantastic 4. The video gives very clear and simple instructions. There are very few requirements other than that the viewer should have a pencil and paper. The video gives great advice on how to draw female characters in general. By the end of the video, viewers should have a good idea on how to draw not just Susan Storm, but most female ch...
This how-to video from Lowe's demonstrates how to install a closet organization system. He explains that the first step is to clean out the closet and take inventory of the items that go in the closet, then choose what type of racks, shelving and bins will work for your space. He explains the options and shows wire and laminate components, and encourages the viewers to take measurements to create a design based on their needs. Using this advice and the materials available at Lowe's, along wit...
JoAnn, an amazing scrapbooker from Emerald City Elegance, teaches you how to make an amazing mini scrapbook album of your own out of note cards. Describes the necessary materials and tools and gives an easy to follow explanation of how to put together this excellent gift. Includes great scrap booking tips and ideas about cutting and punching holes into card stock, presentation advice, and working with different types of paper. Video includes beautiful pictures of paper crafts to get your crea...
Kathy Kaehler, author, celebrity trainer, spokesperson and mother, gives us a rundown of the best exercises for fellow women and moms on how to target their belly fat and love handles, and specifically the best ways to tighten these areas. Kathy first does advise us that if you're going to be targeting like this the most important thing first will be cardio and general fitness. Then, she offers us first the side plank, where you place one elbow to the ground, lying on your side, and then elev...
Having trouble with sharpening your serrated knives? Wayne Dolik, an expert sharpener from www.sandiegocutlery.com tells you how. In this video tutorial, Wayne explains the essential tools of serrated knife sharpening and where to get them. Wayne also offers great tips and advice on sharpening safety, how to minimize the chances of damaging your expensive knives, how to make the job as easy on yourself as possible, and how to get the best overall results. You don't have to struggle in the kit...
This video is for XBOX360 users, and includes general suggestions for the types and models of headsets to use for the gaming system. The man on the screen giving advice is Michael Weezner, who says he is an "avid video gamer" and who has much experience about selling, buying and playing video games and accessories. He recommends the Turtle Beach Wired Headset for the XBox 360 or the Turtle Beach Wireless Headset for the XBox 360. Both have built in sound counseling features, and will block ou...
Do the polynomials, or "giant fractions" in your high school math homework have you puzzled? Let Doug Simms, an expert tutor from free math tutoring, walk you through some easy to follow chalkboard examples. He addresses common snags and challenges in the equation simplification process, as well as some great advice about the kinds of problems that you are likely to see on your math exams. There is no reason to go it alone when Doug Simms is waiting to help you in this free video!
Want to access files from multiple computers at work or home? An expert from PC Remedies explains how to set up a Home Group network on Windows 7 systems. Includes a how-to of setting up your location, and managing the set-up wizard. Finally maximize your current resources by networking your work and entertainment files, as well as hardware such as printers. The excellent video gives you an exact snapshot of what you can expect to see on your own Windows 7 system. Includes advice on setting u...
Don't know how to play the guitar but want to learn? Do you want to learn fast and impress your friends? No problem! Check out this video and master the 3 basic chords (or strings) on your instrument instantly and trick everyone into thinking you've been playing for years! This video is easy to follow and offers a step by step introduction to guitar playing as well as advice on playing with three strings. So, grab you guitar and get ready to rock!
MakeoverGirl1 shows how to create perfect rips in your pairs of denim blue jeans. Paul Dillinger describes the right way to cut and rip your jeans to make perfect holes. He also describes how adding yarn when you are making your holes will keep the jeans together and make the holes appear better for when you're wearing them outdoors. Following the steps and advice in this video will help you create the right rips in your jeans to create the fashion statement you desire.
Sick of paying for pricey text messaging plans? Down because your parents cut off or limited your texting? Let Hawks12thman offer his excellent, money-saving advice on how to send your texts for FREE from your computer. Especially helpful for those who cannot afford to keep a cell phone but don't want to miss out on a minute of conversation with friends. Also handy for when you are working on the web and don't happen to have your cell phone handy!
This how-to video demonstrates a how to create an image of the comic-book superhero Spiderman in a basic generic pose. The artist, Xia Taptara, sketches out the basic figure, then gives advice on how to practice drawing tricky features like musculature, hands etc. as he adds more definition using a darker line. As the drawing progresses, Xia Taptara offers tips on perspective and more.
Blogger Chantal McCulligh offers advice on cutting your own side-swept bangs in this video. She shows you how to cut your own bangs in the mirror to achieve the side-swept layered look without having to buy fancy scissors for the task. This video shows the technique several times to fully demonstrate the trick with plain old craft scissors. Chantal makes it look easy and the results look great. Following her directions closely would result in anyone being able to duplicate her stylish look.
MJ shows how to do a "sexy smoky sultry eye" through steps and techniques on how to apply different layers of makeup. This video is helpful for anyone looking for new and fresh ways to apply makeup in a creative manner. The steps in this video are thorough and clearly demonstrated. Besides advice on the makeup techniques, MJ also gives tips on color choice and other things. If you pay attention and follow MJ's steps you will have "sexy smoky smoldering" eyes and maybe even a new video channel...
Paul Bolzoni is one of the best exterminators of New York City. Watch as he talks about some of his experiences as he goes around New York helping people with the bedbug epidemic.