Mid Day Search Results

How To: Fold a five-point paper barn star

This is a video tutorial in the Arts & Crafts category where you are going to learn how to fold a five-point paper barn star. You will need a square sheet of paper. Fold it in half to make a rectangle. Take the right folded corner and fold it up to the left edge of the rectangle. Place the corner about 1/3 from the top edge and fold the sheet. Next take the left corner and fold it over the edge you just folded. Finally take the flap on the right and fold it over to the opposite side. Now cut ...

How To: Extract only numbers from a text string array forumla

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 489th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract only the numbers from a text string. This is accomplished with recourse to Excel's LEN, INDIRECT, ROW, MID, ISNUMBER, INDEX, LARGE, SUMPRODUCT, and SUM functions.

How To: Extract digits to the right of a decimal in MS Excel

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 580th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the REPLACE, MID, COLUMNS and SEARCH functions to extract numbers to the right of a decimal into their individual cells.

How To: Do a double leg freerun trick

In this video tutorial, viewers learn how to do a double leg free-run trick. This trick is similar to the side flip, except the side flip needs the legs to be tucked in while the double flip needs the feet to be kept straight. The double leg is at a 90 degree angle in mid-air. Keep your legs together and knees locked. Land on the balls of your feet. Never land on the heels or flat footed. This video will benefit those viewers who are interested in flexibility, aerobics and free-running, and w...

How To: Force flower bulbs to bloom

This video explains how to force flower bulbs to bloom. The instructor first takes a pot and fills the bottom of it with gravel, which then the bulbs are placed right on top of the set gravel. The rest of the bowl is filled with polished show rocks mid way up the bulb to set them properly inside the pot so they are unable to move freely. The instructor then explains that using the gravel and rock filling forces the bulbs to bloom faster then with standard potting soil. The instructor explains...

How To: Practice a pump fake & pivot with Kobe Bryant

Learn how to do the Kobe Bryant pump fake & pivot! This is another Nike Signature Move from NBA Laker MVP Kobe Bryant. Get in triple threat position. Jab step, drive by, pump fake and then pivot. This is a mid-range game for when you have an aggressive defender. Show him the ball, step through for a drive. If the defender is close left pivot around in a pirouette. Take the shot or you've got the teammate.

How To: Winterize your car brakes & ABS

For most people who deal with seasonal cold weather, it makes sense to prepare one's car brakes/ABS for the winter weather. Ed Kriston from AAA Mid-Atlantic discusses typical brakes and anti-lock brakes. Kriston goes over the general makeup of how brakes work and what components make up the brake system. He goes over how to tell if there is sufficient brake pad to get you through the winter. To make sure your car brakes or anti-lock brakes are prepared for the cold weather, follow the steps i...

How To: Improve your chipping game in golf

In this how-to video, you will learn how to prepare for a golf tournament by improving your chipping game. For a high shot, put the ball up in the stance with an open club face. Address the ball with the hands a little bit behind the ball. Through the shot, let the club continue to go while your hands are behind the ball. For a mid-range shot, take a middle stance with a lot less wrist hinge where you are almost right on top of it. For a low shot, place the ball back in your stand with your h...

How To: Understand the properties of a rhombus in Geometry

In this math tutorial the instructor discusses the properties of a rhombus. He begins by saying that the properties of a rhombus are similar to the properties of a square. He says that the rhombus is a quadrilateral and hence the sum of internal angles of it is 360 degrees. He says that four sides of a rhombus are equal in length. He says that a rhombus has two diagonals which cross each other at their mid points and are perpendicular to each other but says that the lengths of diagonals are d...

How To: Convert your MP3s to ringtones using iTunes

To convert your MP3s to ringtones using iTunes follow the instructions below. First download and install iTunes and then agree to the terms of use and open the program. Then, click "File" and then "Add to Library." Locate the MP3 file you want to convert and open it in iTunes. Now click "iTunes" at the top of your toolbar and select "Preferences", then click the "Import Settings" icon bar and select "MP3 Encoder" in the "Import Using" bar Click "OK" twice to exit to your iTunes library. Now r...

How To: Get Your HTC One M7 Ready for a Different Mobile Carrier

Whether it's spotty data coverage, bad customer service, or a high monthly bill, at some point many of us consider changing carriers. The problem is, we often don't want or need to change our devices. Since it's now legal to unlock devices to bring to new carriers, getting devices switched over is doable, but it's pain going into carrier stores and dealing with their constant upselling.

How To: Activate flight mode on the Samsung Galaxy Tab

Taking a trip soon? Well, make sure you can still enjoy your Samsung Galaxy Tab up in the air. Turning on the Airplane Mode allows you to use your device safely mid-flight. This video shows you exactly how to active it on your Android tablet. Hit MENU < SETTINGS < WIRELESS & NETWORKS and then select FLIGHT MODE at the top. This will activate it. You can press it again to deactivate it. You can also turn on or off FLIGHT MODE by pressing the power button on the side.

How To: Draw realistic lips and teeth

In this tutorial, we learn how to draw realistic lips and teeth. First, draw on your outline for the lips and teeth, using a light pencil. Try your best to get it as natural looking as possible. Now, draw in the shadows and the mid-tones for the lips. Also add in reflective lights and draw in the teeth. Add in details to the teeth and use darker lines to separate them. Use dark creases to form the lips and then continue to add in additional details. When you're finished, darken around the mou...

How To: Adjust EQ settings on a mixer when DJing

See how to adjust the relative levels of low, mid and high frequencies when on the decks. While DJing might appear simple to the untrained eye, truly mastering the turntables requires as much time and dedication as mastering any other instrument. Fortunately, the internet is awash in free video DJing lessons like this one, which make the learning process easier than it's ever been. For more information, including detailed, step-by-step instructions, take a look.

How To: Use volume and EQ controls on a mixer when DJing

Learn how to adjust volume and the relative levels of the bass, mid and high frequencies. While DJing might appear simple to the untrained eye, truly mastering the turntables requires as much time and dedication as mastering any other instrument. Fortunately, the internet is awash in free video DJing lessons like this one, which make the learning process easier than it's ever been. For complete instructions, take a look.

How To: Tune a HPI 21BB engine

In this video tutorial, viewers learn how to tune a HPI 21BB engine. From the base settings, start adjusting the high speed needle in a 1/8 turn. Then adjust the low speed needle in a 1/8 turn as well. Make sure to never run the engine too lean because this can damage the engine. The mid-range needle does not need to be adjusted, but make sure to always run it on base settings. This video will benefit hose viewers who are interested in auto mechanic or have this engine for a vehicle, and woul...

How To: Teach your dog to balance and sit pretty

In this tutorial, we learn how to teach your dog to sit pretty and balance with Adam G. Katz. To do this, teach the dog to stay sitting back and balance instead of standing up by giving him treats in mid-air. This will help larger dogs learn their sense of balance by repeating this over and over with treats so they understand the idea of what they are doing. They will also get used to distributing their weight a different way than just standing fully up. Their sense of balance will improve ov...

How To: Dress up an hourglass figure in a flattering way

In this how-to video, you will learn how get a perfect fit for an hour glass body shape. This means the bust and hip width are the same. This means you have to find the right clothes. A mid rise trouser, simple top, and cardigan will work with this type. As for dresses, many types work well for this shape. A one piece works especially well with an hour glass figure. A belt can also help emphasize the waist. A jersey dress are also perfect for this figure, as it is the same size on the top as ...

How To: Extract the nth word from a text string in Excel

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 559th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract the first, last or nth word from a text string using Excel's SUBSTITUTE, LEN, SEARCH, REPLACE, LEFT, RIGHT and MID functions.

How To: Extract first, middle, & last names in Microsoft Excel

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 562nd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract first, middle and last names when the list contains names where some have a middle name and some do not using the LEFT, SEARCH, LEN, SUBSTITUTE, LEN, MID and IF functions.

How To: Draw a fantasy unicorn

This video illustrates how to draw a fantasy unicorn. Here are the following steps: Step 1: First of all take a sheet of paper and pencil and start drawing the head in a cone shape with the cone having round edge ,this cone represents the head.

How To: Do a kickflip on a fingerboard or tech deck

In this video tutorial, viewers learn how to do a kick-flip on a fingerboard/Tech Deck. Begin by setting the fingers into a Ollie position with the middle finger on the tail and the index finger behind the bolts of the board. Pop the tail down and slide the middle finger on the edge of the board. Tilt the board forward and towards you. Users should catch the board with the two fingers in mid-air, and do not wait for it to land. This video will benefit those viewers who enjoy playing with fing...

How To: Extract dates and times from a database field in Excel

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 312th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the DATE, MID, LEFT and TIME functions to extract dates and times from a database field that stores dates and times as a text string.

How To: Create a Megan Fox inspired hair style

This video illustrate us how to create a Megan fox inspired hair style. Here are the following steps:Step 1: First of all shampoo and condition your hair.Step 2: Now take the hot iron curler and curlers .Step 3: Now part your hairs and take your lower partition and curl it on the curler.step 4: Similarly part down the other hair and roll it on the curler.Step 5: open all the partition and curl it on the roller. Leave it on for at least twenty minutesStep 6: Now open the curlers and comb it li...

How To: Draw a furry cartoon fox

This video illustrate us how to draw a furry cartoon fox. Here are the following steps.Step 1: First of all take a sheet of paper and pencil and start by drawing a oval shape representing the face of the fox.Step 2: Now draw a nose and two oval shape eyes in the face.Now from the bottom of the face draw an oval structure representing the belly of the fox.Step 3: Now from the lower belly draw two small legs with feet.Step 4: Now draw a tail from the back of the mid lower portion representing t...

How To: Do a standard kickflip on a skateboard

In this video tutorial, viewers learn how to do a kick-flip on a skateboard. Begin by putting the back foot on the tail and the front foot near the center of the board. Place the feet in an angled or squared position. Ride at a moderate speed. To perform the kick-flip, pop the tail down and flick the front foot outwards. Then catch the board in mid air with the back foot and then with the front foot. Try to land on the bolts of the board. This video will benefit those viewers who enjoy skateb...