Require Larger Search Results

How To: Extract part of a table from a larger table in Excel

New to 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 Excel tutorial from ExcelIsFun, the 185th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to extract part of a table from a larger table. You'll accomplish this with an array formula that uses Excel's INDIRECT, IF, ROWS, COUNTIF, INDEX, SMALL, and ROW functions. The formula will extract records that meet one con...

How To: Use the spot or regular healing brush in Photoshop

Do you love to edit your photos in Photoshop? Watch this quick video that contains some really neat tips on how to use the healing brushes and patch tools in Photoshop. The spot healing brush makes it easy to brush away blemishes or other marks on the skin. It's good for small spots, not larger areas. You can use the patch tool for larger jobs. These two tools combined will give you a pretty impressive end look. It can remove tattoos, wrinkles, acne and so much more!

How To: Solve word problems that require you to compare whole numbers

From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just finish your homework or study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to unpack and solve problems requiring you to compare two or more whole numbers.

How To: Shave your private parts for men

If you're looking for some manscaping tips, this how-to video is for you. Learn the tips and tricks to go smooth down there and impress the ladies. Be careful, follow the steps and you too can trim the grass and make the tree look larger. So if you want to shave your private parts, look no further.

How To: Make a wide-mouthed screaming face in Photoshop

Munch's The Scream is one of the world's most famous paintings, and at least since it was painted people have had a fascination with images of larger-than-life mouths screaming. This video will show you how to use Photoshop to create some cool screaming face effects, like making the mouth huge and distorted or even making it cover the entire face! The effects are cool and easy, so try it!

How To: Apply visible liner on heavily hooded eyes

A lot of people have larger hoods on their upper eyelids. If this is the case for you, you may be frustrated by never being able to see your liner or shadow when your eyes are wide open. Check out this tutorial for a lesson on how to create visible eyeliner on heavy eyelids. This trick is super easy and doesn't take long and will really make your eyes stand out no matter what your lids are like.

How To: Make a mold using an epoxy fiberglass layup

Check out this video to learn how to make a professional epoxy fiberglass layup and epoxy laminating systems. This process is ideal for working on larger projects, a typical 'fiberglass layup' is a popular process for those who need a large, strong, and lightweight tool.This process can be used in automotive, mechanical, fine art and film special effects uses.

How To: Grow the perfect tomato (for you)

In this video tutorial, viewers learn how to grow tomatoes. Begin by some tomatoes at a supermarket. Then extract the seeds from the tomatoes and wrap them into a paper towel. Then place the seeds in between the pages of a phone book to quickly dry them. Now plant about 8-10 seeds into a small pot with soil. The seeds should be planted 25 inches deep into the soil. As the plants grow larger, change the pots to a larger size. This video will benefit those viewers who enjoy gardening and would ...

How To: Do ruffle & ruffle bow cake decorating techniques

Wilton Cake Decorating demonstrates how to do a ruffle and a ruffle bow cake decorating techniques. Use a #104 petal tip to create this effect. Also use a medium icing consistency and hold the bag at a 45 degree angle. A petal tip can be used to make ribbons and bows. The icing tip has a narrow end and a larger end. Place the larger end down and move your hand up and down to create the ribbon. Make a figure eight to make the bow. Add a knot in the middle, if desired, and add strings. Star tip...

How To: Change the size of text and icons in Windows 7

In this video tutorial. viewers learn how to change the size of text and icons in a Windows 7 computer. Begin by clicking on the Start menu and open Control Panel. In the Control Panel window, click on Appearance and Personalization. Then click on Display. Now users are able to select the size of text and icons to Smaller - 100%(default), Medium - 125% and Larger - 150%. If users select one of the larger sizes, some of the items will not fit on the screen. Once users have select the setting, ...

How To: Identify a mustang horse

This video is a tutorial on how to identify a mustang horse breed. The instructor begins by saying that it is not easy to identify a mustang horse because of the cross breeding characteristics of mustangs. The mustang shown in the video is larger then an average mustang. The instructor shows the mustangs white brand and all the different meanings along with age tagged along with the horse. The mustang is known for having feet that are larger then most other horse species. The most important s...

How To: Stuff balloons inside of balloons for party decor

An interesting party decor idea is to place balloons inside other balloons. This can be accomplished easily by first inflating a large balloon. Using a small stick, push a second, smaller balloon inside the larger one and then inflate the smaller balloon while it is inside the larger one. You can then tie up the second balloon, leaving the smaller one inside the large balloon. This can be repeated with multiple small balloons, so your balloons will have a unique and interesting look. This tut...

How To: Do a sideflip to a cartwheel

Interested in Parkour? Take a look at this instructional video and learn how to perform a sideflip after a cartwheel. The sideflip after a cartwheel requires a technique quite different from the normal sideflip. It requires flexibility, height, lightness, and good air awareness.

How To: Make a urethane rubber mold

This video illustrates in great detail how to create a perfect urethane rubber mold. Urethane Rubber molds are widely used when a flexible mold material is required and a more expensive or less abrasion-resistant silicone rubber is not desired. However, their use requires careful application of release agents. This process can be used in automotive, mechanical, fine art and film special effects uses.

How To: Say "help" and ask "how much" in Polish

In this tutorial, we learn how to say basic phrases in polish: "help" & "how much". While watching this video, you will want to pay attention to how each of the phrases are said. The different words are said in different ways by people that have the right dialects and accents. As you continue to learn the different phrases, you will be able to have small conversations with those who truly speak the language! Incorporate this into larger sentences, then you will be able to have larger conversa...

How To: Create advanced shadows in GIMP

In this video we learn how to create advanced shadows in GIMP. First, create a new image that's 500x400. After this, create different layers on the page and use the shadow and gradient to create different colors. As you do this, you can you can add in a layer mask to create a deeper shadow inside the image. Use a larger brush to make the shadowing fuzzy and then use the shape tool to drag it out and make it larger. Practice playing with the different brushes and gradients and have fun creatin...

How To: Curl your hair without a curling iron

In this tutorial, we learn how to curl your hair without a curling iron. First, you will need to section your hair so you have the bottom of it. Next, you will place the straightener at the root of the hair and twist the straightener. Then, pull the straightener slowly through the hair and twist at the end. When the hair comes out, you will have beautiful curls in the hair! Continue to do this throughout your entire head of hair. If you want smaller curls, use smaller sections of hair and if ...

How To: Draw manga facial expressions

In this tutorial, we learn how to draw manga facial expressions. To draw an angry face, you will draw a circle for the head with a point for the chin. Then, you will draw in a slight frown for the mouth and half circles for the eyes. Then, draw in slanted eyebrows above the eyes to make the character look angry. Add in highlights around the face to make the expression larger. Then, add in lines around the face to show it being crunched up and the person being angry. You can also make the mout...

How To: Draw Rock Lee from Naruto

In this tutorial, we learn how to draw Rock Lee. First draw a circle for the head, making a chin underneath and using lines to reference where the facial features will go. After this, draw eyes that are slightly aligned to the left hand side of the face. The right eye should be larger than the left, both off center. Then, draw two dots for the nose and a "u" shape for the mouth. After this, draw a larger circle around the head and then draw in angry eyebrows above the eyes. Start to erase the...

How To: Draw cartoon caricatures

In this tutorial, we learn how to draw cartoon caricatures. Start off by drawing the eyes and the eyebrows. Next, draw in the hair on the forehead and then start to make the face surrounding the hair. After this, you will need to draw in the ears and make a note to draw in any prominent features that the person you are drawing has. Make sure to draw larger lips and a small neck, making the head look larger. For men, do the same thing and give each of the pictures a bit of personality! Don't b...

How To: Draw a rose, step by step

In this tutorial, we learn how to draw a rose, step by step. start off drawing the petals of the rose, making the inside of the flower first. After this, start to draw in more details and draw around the inside of the flower, making the rose larger and larger. After you have done this, draw on the stem underneath where the petals are, and add leaves onto the stem. Continue to add in any details that you see fit throughout the picture. When you are done drawing, color it if you prefer, then si...

How To: Draw a doodle

In this video, we learn how to draw a doodle with Marieke Blokland. Start off by writing the letter "e" in cursive, several times, making the letter larger as you go. Link the e's together, then when you get to the bottom of the paper it will be just a scribbled loop. Now, on the next page, draw more of these looped e's, dragging out the lines. On the next paper, draw spirals going from smaller to larger and going clockwise and counter-clockwise. Start to incorporate all of these shapes toget...

How To: Thread a cord lock

In this tutorial, we learn how to thread a cord lock. First, tilt the cord lock up and find the two different wheels on the inside of it. Now, push your lift cord up through the two wheels that are on the inside of the lock. After this, pull the thread up through the top and then slide the thread through the smaller hole on the lock. Now, you will repeat this again for another piece of string, but thread it through the larger hole once you reach the top. After this, thread another cord throug...

How To: Use the touchscreen on the HP TouchSmart

In this tutorial, we learn how to use the touchscreen on the HP TouchSmart pc. On the Windows desktop you will see a house that has the TouchSmart icon, double touch this, then you will see large tiles that show different shortcuts to application and websites in your computer. You will also see links to website and other items. The bottom and top row are the same, except the bottom is smaller icons than the top. Use your finger to sweep through the different tiles and choose which application...

How To: Graph a hyperbola

This video is one in a series of videos dealing with conic sections, in mathematics. This particular video deals with hyperbolas. The teacher, Robert Ahdoot, gives an example of a hyperbola, during which he emphasizes some key points. A hyperbola is identified by an equation containing x squared and y squared, with a minus sign between them. If x is larger, the hyperbola will open to the sides, and if y is larger it will open up and down. He creates hyperbolas, demonstrating where to make asy...

How To: Make a flower fairy paper art doll

In this video tutorial learn how to make a jointed flower fairy paper doll sitting on top of a trinket box. You will need three strips of paper and two circles cut out of paper. To create the box, curl the strip with a pencil. Then adhere scotch tape to the strip and tape the strip to the circle to create a box-like structure. Cover the perimeter with a larger strip of paper in whatever design you want to use. Follow these same steps to create a larger box. Fit these two pieces together and a...

How To: Divide small numbers by big numbers

This is a mathematical educational video on how to divide a small number by a larger number. You are aware that it is easy to divide a larger number by a small number. For example, if you want to divide 379 by 9 it is easy to do so. But if you have to divide 9 by 379 it is a bit difficult. You have to add a zero and see if you can divide. You need to add one more zero so that you can divide 900 by 379. But you should know that the answer would start like this 0.0 as we have added 2 zeros alre...

How To: Sand mold

Sanding molding can be pretty challenging with all the curves and details. First for sanding curves try wrapping your sandpaper around a piece of dowel rod. Choose the proper sized dowel for the size of the curve that you have to sand. The larger the curve the larger the piece of dowel that you will need. To get into hard to reach crevices try folding the sandpaper several times and then use the edge of the sandpaper to sand down in the tight crevices.

How To: Make Any Android Device Easier to Use with One Hand

Our hands aren't necessarily getting any bigger, but smartphones still seem to be getting larger and larger. With average cell phone display sizes nearly doubling since 2007 (leading to new terminology like "phablet"), reaching all corners of a screen can become nearly impossible with one hand. Granted, most larger devices like the Samsung Galaxy Note 3 and Galaxy Note 4 come with a one-handed option to make navigating easier, but other popular devices like the Nexus 6 don't. While it may see...

How To: Properly caulk like a pro

Caulking can seem like a tough job that requires a lot of patience and skill. In fact, it only requires a couple of tools: caulk, some tape, and a wet rag. In this tutorial from the DIY network, you'll find out how to caulk like a pro using those tools listed. It's an easy task that will have your kitchen or bath looking brand new. Good luck and enjoy!