Long Form Search Results

How To: Replace a long IF with a MIN/MAX formula in Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 100th installment in their series of digital spreadsheet magic tricks, you'll learn how to replace a long IF formula with a simple MIN/MAX formula (or an even simpler MEDIAN function). See 3 amazing examples. When you have a hurdle such a Commission Hurdle or a Payroll Taxable Earning Hurdle, and you are using an IF function fo...

How To: Use long exposure photography to paint with sparklers

Long exposure photography has long allowed photographers to do amazing things with light. Now you can do that! This video will show you how to use a long exposure, sparklers, and Photoshop to create amazing psychedelic art on your photographs. This new art form is called light painting or light writing, looks amazing, and is pretty easy to get started doing. Do it!

How To: Program a Roland TR-808 drum machine

The Roland TR-808 drum machine is one of the most important modern instruments, forming the backbone of both hip-hop and electronic music percussion. If you have gotten your hands on one, you're a lucky devil, but you have a long way to go before you can unlock it's true potential. Watch this video to learn how to program an 808 all the way up to a 64-step beat!

How To: Do a simple, quick light painting with flashlights

Light painting (or light writing) is a relatively new art form combining flashlights and long camera exposures to create amazing still images with designs literally drawn on them in light. This video features an experienced light painter teaching you the basics of the at in only 2 minutes! He covers what you will need, how to use it, and demonstrates the painting of a simple happy face. Now get out there and try it yourself!

How To: Make a custom dress form

Kick up your look by adding dresses you make yourself to your wardrobe. It's simple to create a patter and sew a dress that will fit your exact measurements. You'll be amazed at the differene of having a drees you made yourself makes.

How To: Can chuck roast with brown gravy

There's nothing like a delicious chuck roast during a long day at work. But if you're interested in making it in a different form, this may be what you need. In this video tutorial, you'll find out how to can chuck roast with brown gravy using jars and a canner. So check it out, get the materials ready, adn good luck!

How To: Bonsai style a larch

Bonsai is an art form that requires patience and a good eye. It's a relaxing hobby that anybody can take up, just as long as they are willing to learn a few things. This tutorial is a beginner video for those who are interested in bonsai. This video will focus on styling a larch tree. So sit back and enjoy!

How To: Create a puff-pastry cornucopia

In this video we learn how to make a puff-pastry cornucopia. This is a great centerpiece for Thanksgiving and can be used to hold different foods such as buiscuts or finger sandwiches. First we need to form the mold for the cornucopia. You take some tin foil and make about 13-16 balls. These are spacers for inside the mold. Then you cut a piece of tin foil about 30" long. You place your balls in the middle and wrap your foil up over. Start to form your cornucopia the way you like. Try to make...

How To: Deep clean your makeup brushes

Makeup brushes accumulate a lot of bacteria and dirt. Keeping your makeup brushes clean should be an important part of your makeup routine. And it doesn't have to take very long. Julieg713 has some great advice on how to deep clean your makeup brushes efficiently. Deep cleaning makeup brushes is recommended at least once a month to keep your brushes in top form and bacteria-free.

How To: Publish your own book

Want to see your book in print? Going the route of agents and sending your manuscript off for publication is a long grueling process that may not even pan out. If you're not looking to get famous and you're just looking to get your book in tangible form, take a look at this instructional video and learn how to self publish your own book.

How To: Sculpt a hairy ceramic clay monster

In this how-to video, you will learn how to create a hairy clay figure. You will need to mix basic clay to do this. Rub the clay into a ball and then shape it into the body of the creature. Do not work the clay for too long, as it will harden faster. Use matches to form the eyes. Once the form is complete, move on to the hair. Use a different color clay for a great visual effect. Make the clay into long strings. Once they are done, cut them with a clay knife to form small dots. Rub these dots...

How To: Tie an ascot and scrunchie tie

Place you tie around your neck. Make one side longer and one side shorter. Then you will criss-cross the two sides of the tie, with the longer end being placed over the short end. Take the long end and loop it around the shorter end. Then you will take the longer end and bring it through the little loop that you have already formed by looping the end around. This will give you the ascot. To do a scrunchy tie, take the ends and pull them through the loop that has formed, and then you will have...

How To: Make swords & hearts out of balloons

This video demonstrates how to make a balloon sword and heart. To make a sword, pump up a balloon as long as possible and tie the end. Twist the balloon at this end making a small ball. Bend the balloon at around 20 cms in length and twist both the ends of the balloon at the same level as the ball creating a loop. This is named the 'elephant bend'. Now insert the long end of the balloon into the loop leaving behind a small part. Your sword is ready.To make a Heart flower. Take a red balloon a...

How To: Origami a nice swan

Origami isn't just folding paper, it's a form of art. So, if you want to try a new creative way to express yourself, and if you like birds, try out this tutorial on folding an origami paper swan.

How To: Style Apostolic/Pentecostal haistyles for long hair

To create an apostolic or pentecostal hairstyle, start with a poof in the front of the hair. It can be ratted behind for stability. Use two bobby pins to secure the back corner of the poof. Squirt the hair with hairspray before moving on. Then create a low ponytail in the back of the hair, pulling the top up and out slightly while forming the ponytail so it creates another poof in the back of the head. Spray the ponytail with hairspray then smooth out the hair on the top of the ponytail. Wrap...

How To: Tie the Tea Cup decorative knot

If you're into arts and crafts then you know that there is more that you can do with a long piece of string than just tie your shoes. On this TyingitAllTogether video you have the opportunity to tie the teacup decorative knot using one long piece of string folded in half. The author of the video first shows you what the end product will look like then methodically begins to walk you through setting up the string in Y-configuration to "crossing each bights crook" which involves overlapping and...

How To: Do long multiplication

In this video the instructor gives you sample as of how to SLEP long multiplication. You start by breaking the numbers up to simpler forms. If you have a two digit number that your multiplying by a another two digit number you multiply the first two digit number and then buy the second digit of the second two digit number. You have to remember to carry the remainders. You then add your two multiplicative lines together giving you the sum. this can be done to cover any set of multi-digit numbe...

How To: Make papier-mâché

In elementary school, we all experienced the wonders of papier mâché, that wonderfully malleable mixture of paper and glue (or maybe paper, flour, and water). Once it hardens, it's a homemade work of art. And homemade papier mâché is art on the cheap, allowing your imagination to soar without breaking your budget.

How To: Light paint with a camera, flashlights, and tripod

Light painting or light writing is one of the coolest of the coolest multimedia arts. It consists of setting a camera for a very long exposure in a dark area, then moving light sources around in front of the camera. When the aperture finally closes, you will have a photo where the light is preserved everywhere it was. Basically, you've drawn on a photo with light. How cool is that? This video will show you how to do it quickly and easily, allowing you and your friends to enjoy this exciting n...

How To: Make a non-toxic clay pipe for smoking marijuana

We are taught how to make a non-toxic pipe using baking clay and an eyelet and socket. First you form a bowl out of the clay with your hands. When thats done you poke a hole on the top to form the bowl, then a hole on the side towards the bottom to create the shaft for the pipe. Freeze it. While that's being froze the shaft of the pipe can be made. Rolling the clay the longer piece is formed. The inside is hallowed out. Blow through it to make sure its usable. Attach the long piece to the bow...

How To: Make an origami spinning top, step by step

This is an instructional video that demonstrates how to make an origami spinning top. You need seven square pieces of paper, and she uses 6"x6" sheets. First fold the paper diagonally. Fold the short edges to meet the long edge. Unfold it and use that as a guide for the next fold. Fold the top triangles down and tuck on corner into the pocket. Make seven exactly the same. She shows how to slide one folded piece of paper into the next one and fold the edges over each other to hold them togethe...

How To: Make a fishing spear for use in the wild

This video shows you how to make a fishing spear for catching fish or small wildlife in survival situation.To start, you need a sapling about 5 feet long and a knife. Make a raw sharpening of the stick. Then split the log at the tip for a length of 6-8 inches. To split, put the knife on the middle of the sapling, near the tip, and press hard against it. Once it is split, find a twig with the width of a pencil and push it inside the split, making the two halves of the stick form a gap between ...

How To: Make 'frog skin' or 'gak'

Chris Giorni, Mr. Science with Tree Frog Treks, demonstrates how to make simulated frog skin. To make the simulated frog skin, you will need glue, water, borax laundry powder and food coloring. First, add a pinch of the powdered borax to water and dye it green using the food coloring. Next, water down the glue and place it on a plate. Add the borax solution to the plate. Mix the compound with your fingers. It will quickly form a long chain polymer or sticky frog skin. Frogs breathe through th...

How To: Long Hair Messy Bun

Buns make the look of a woman highly fashionable and cool. Transform your appearance into highly swanky and dashing by following this simple tutorial to make an awesome Long Hair Messy Bun and instantly transform your simple look into a fashionable one. Step 1: Comb Your Hair and Make a High Pony. Now Take Small Section of Hair from the Pony and Start Backcombing the Surface Side. Step 2: Now with Your Fingers

How To: Make a MySQL database for CoffeeCup Form Builder

This CoffeeCup Web Form Builder software tutorial shows how to create a MySQL database to be used in CoffeeCup Form Builder to build web forms. Mike Lively shows you how to do this using cPanel and the Site Ground server for hosting since it allows an unlimited number of MySQL databases. Start by creating your database in cPanel and then upload the results to CoffeeCup Form Builder.

How To: Create a login form using MS Access 2007

If you want to password restrict some of your data, or just want to know who is doing what in Microsoft Access 2007, you will want to set up a login form for MS Access 2007. This is an easy procedure, and you can create one yourself with just a basic understanding of the structure for MS Access. Watch this video, and Uncle Gizmo will show you how to do a login form and several other forms for MS Access.

Prev Page