Drop Consumers Search Results

How To: Defeat Barthandelus in Final Fantasy XIII

Make sure to buff up before fighting Barthandelus. Make sure you use the aegisol buff. Then use your Liba Scope ability in order to understand its weaknesses. Attack the smaller heads before attacking the main upside down head, because in the beginning it will be almost invincible. After attacking the sides of the boss, attack the main head. If your health drops to about half, switch over to medic class and heal. The boss has some strong attacks so make sure to be ready for them. If you buff ...

How To: Make quick and easy tuna meatballs

On Tastyfood TV the recipe is "Tuna Meatballs". They will take you through the process of creating this recipe. It uses two small tins of tuna, two small boiled potatoes, parmesan cheese, eggs, and some breadcrumbs. The tinned tuna is drained and put in a bowl. The boiled potato is peeled and mashed in a bowl, then the tuna is added, then finally the two eggs. A pinch of salt, a sprinkling parmesan cheese, and it is all mixed together, formed into balls, and dusted with breadcrumbs. After bei...

How To: Make an Excel gradebook that drops the 2 lowest scores

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 196th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM, SMALL and VLOOKUP functions to create a gradebook (or grade book) based on a total score minus the two lowest scores.

How To: Make an Excel gradebook that removes the lowest score

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 195th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM, MIN and VLOOKUP functions to create a grade book based on given total score that drops the lowest score and calculates grades automatically.

How To: Make a Spartan spear from scratch at home

To make your very own Spartan Spear, like in the movie 300, you just have to follow a few short, easy instructions. Start off by taking a broom stick, and cutting off the end. Make sure your broom stick is empty inside. Then take a hammer and flatten the last few inches of it, hammering it into a point or a flat blade at the end. Cut off part of the tip at an angle on either side, then open it back up with pliers. A few inches below the opening, take your pliers and press in on the broom stic...

How To: Make tortilla chips at home from scratch

This video shows you how to make tortilla chips at home. First, you will need to preheat your deep fryer to 375 degrees. Slice tortillas into wedges or whatever size or shape you want. You may stack them and cut several at once, if that makes it easier for you. Prepare a plate for your tortillas, by lining a plate with paper towels. This will absorb the excess oil, and it will prevent your chips from being too greasy. Place 10-15 tortilla pieces into your fryer basket. Drop the basket in the ...

How To: Do the Windmill & Standing Windmill breakdance moves

This video by StenLTran92 shows how to accomplish the break-dance moves "Windmill" and "Standing Mill." The video begins by first displaying the move in it's entirety. Then, the instructor takes us through the step by step of performing the break-dance move. The moves are all broken down into various kicks, drops, and facings that are to be followed if the move is to be done correctly. After the first lesson, the instructor moves on to how to accomplish a variation on the "Windmill" move. Bot...

How To: Use a hammer and nail to open a soup can

Have you ever been caught with nothing to eat but canned soup or tuna fish and no can opener in sight? In this video, AJ Conover demonstrates how to open a can with a hammer and nail. First make sure the hammer and nail are very clean. Use the hammer to lightly pound the nail into the can's lid creating holes. Be careful not to pound too hard and drop the nail into the food inside the can. Hammer enough holes to make an opening around the edge of the can's lid and then pry the lid up and open...

How To: Make a blooming paper flower

This video shows us how to make a blooming paper flower. To start, you shall first draw a flower on your computer, using paint or other similar program. The flower should be simple, a circle with eight identical pedals arranged around it. Print your drawing and, using a pair of scissors, cut your flower out leaving no excess paper. Take each pedal and fold it inwards towards the center of your circle. Now, get a bowl that will easily accommodate your flower and fill it with enough water to al...

How To: Make a perfect omelette

Diane Morgan shows us the right way to cook a nice fluffy omelet. Break the eggs into a bowl and beat them with a fork until they are fluffy, adding a small amount of milk and some salt and pepper. Add a little butter to a non-stick omelet pan; let it melt on low heat and drop in the eggs. When the skin starts to form, begin tilting the pan as you scoop the cooked parts of the egg into the center with a spatula. When all of the egg is cooked you can start adding the fillings over the top. To ...

How To: Apply conditional formatting within MS Access 2010

lyndapodcast teaches you how to apply conditional formatting withing Microsoft Access 2010. You click View - Design View. Click the Total tab and you'll notice some highlighted options above. Click Format and then Conditional Formatting. This where you will create rules. Click the new rule button. Now you will see the conditions with drop-down menus. Type in the numbers you want and then select the formatting you want when the rule is true. The preview below will show you how the numbers will...

How To: Make a homemade rosemary facial spray or facial mist

Nili Nathan demonstrates how to create your own homemade rosemary facial spray. 1. Start by adding 3 oz of distilled water to a spray bottle. Add 1 tablespoon of olive oil. 2. Take rosemary essential oil and add 6 drops to the bottle. 3. Gather up some fresh rosemary (possibly from your garden or a friends garden or a nearby store) and add that to the bottle. Close the bottle tightly and shake it up. 4. Now you are ready to spray desired amount to body and face!

How To: Create a water droplet in Photoshop

This video offers Photoshop users a detailed procedure for adding simulated water droplets to photographs. A male voice-over describes each step in a conversational tone, and his instructions are easy to follow and apply. As he narrates, each step is carried out on screen, allowing you to find the different Photoshop tools and settings when you do it yourself. The procedure uses the gradient tool, drop shadow, and liquefy filter to create a water droplet to a clover leaf. In addition to showi...

How To: Do basic sidechaining in Ableton

This video shows how to do audio side chain compression to improve your production audio mix. Side chain compression is an easy way to balance the base and the drums. Using a compressor, you can cause your base to drop in volume when the drums are hitting so that one is not over-powering the other. This video walks you through step by step instructions for configuring your compressor to balance based on threshold level, the attack time, and release time. This is an excellent source of audio p...

How To: Make fake blood like the pros

A tutorial and demonstration on how to make fake blood. Things you'll need: 8 tbsp. corn syrup, 1 tsp. red dye, 1 1/2 drops blue dye, 1 tsp. cocoa powder, 1/4 tsp. corn starch. Combine all the ingredients in an empty container. Mix well until everything is well incorporated. Make necessary adjustments to the ingredients if needed. Follow these steps and You'll be able to make a fake blood.

How To: Varial kickflip on your own skateboard

Remember: a varial kickflip is basically a pop shove-it with a little more ankle action, so set up like you would for a pop shove-it. Hit the tail as you would for a pop shove-it, and as the board starts to snap up, flick your front foot just like a kickflip. That action will cause the board to flip while the shove-it action from your back foot will make the board turn 180 degrees below you. Don't flick the flip too hard or it will flip away from you like a crazy 4th of July firework. Let the...

How To: Correct white balance in Photoshop

This informative video tells you how to use the variations panel in Adobe Photoshop to correct color issues in your photo. Too much yellow in your picture? Learn how to use the variations setting to instantly fix this with the corresponding opposite color. With simple clicks and easy preview-able pictures, you can correct color over-exposures with a click of the mouse. First go to the Images drop down and select the variations option. The original photo on the top can be clicked to revert you...

How To: Bodypaint a dragon on a female body

Body painting isn't just art, it's sexy. More and more people are shedding their clothes and adding some paint for a new shocking look that is bound to drop jaws. If you're not into being painted into a Picasso, then maybe you'd like to try your hands on the other side of the paint brush…

How To: Create dotted lines in Photoshop

In this tutorial Photoshopuniverse describes how to create dotted lines in Adobe Photoshop using the brush palette. First create a new blank document in Adobe Photoshop. To open brushes palette, go to menu Window - Brushes. By adjusting spacing and hardness of brush under Brush Tip Shapes menu you can draw desirable dotted lines. To get uniform circled dots uncheck Shape Dynamics box. By holding the shift key click and drag to get a straight dotted line. To create bullet holes or perforated h...

How To: Swing & pronate your tennis serve

Welcome to a tennis lesson from FuzzyYellowBalls, the the best place to learn how to play tennis online. Our free video tennis lessons teach you how to play the game in a new way that combines technical analysis, visual learning, and step-by-step progressions.

How To: Swing to contact in a tennis forehand

Welcome to a tennis lesson from FuzzyYellowBalls, the the best place to learn how to play tennis online. Our free video tennis lessons teach you how to play the game in a new way that combines technical analysis, visual learning, and step-by-step progressions.

How To: Windmill in breakdancing

This guys got it. The windmill is the signature break move where you spin your legs over your head in a circle. Watch the stretch basics too. Lean on the shoulder, throw your legs and then drop the arm to create momentum. This will have you rolling from shoulder to shoulder. It is ALL legs. The legs move in a scissor. The higher the leg, the easier.

How To: Gesso a canvas

You can’t expect to paint a masterpiece on untreated cloth. Here’s how to gesso, or prime, a homemade canvas in a hurry. You will need gesso, water, a plastic mixing bowl, a drop cloth, fine grit sandpaper and a house paintbrush. Tip: some painters prefer to use a squeegee to apply gesso, instead of a brush. The edges of your canvas will drip a little, so use a smaller brush to work the excess gesso back into the sides.

How To: Perform a foot jam endo on a BMX bicycle

BMX: Catch Some Air If Ernest Michaux, inventor of the modern bicycle, could see what people are doing with his creation, he'd freak out. The art of creative biking has never been more challenging and rewarding than it is now. Check out the tricks for a guide to BMX mayhem. Watch this video tutorial to see how to perform a foot jam endo on a BMX bicycle.

How To: Hang a bathroom mirror

Need to upgrade your bathroom's mirror? Well, first you need to take down the old one! And Eric shows you how it's all done in this video guide from GardenFork. Removing a mirror that's been glued to the wall is tricky, but it's nowhere near impossible to take down. Eric covers the mirror surface with contact paper to prevent broken shards dropping everywhere, then start banging on to break it, so you can take it down in sections safely. Once you get it down, see how to hang the new mirror up...

How To: Build a hipster 'fixie' track bike

The first part is the trailer for a fixie feature from track bike legionnaires, MASH SF. The second is a video by Bre Pettis. This instructional DIY video shows you how to build a single speed fixed-gear or 'fixie' bicycle. Using old parts, build a bicycle effective for flat grounds. It looks like a lot of work, but if you have the tools, it should be relatively inexpensive. Learn aside Bre Pettis and Make Magazine.

How To: Make Realistic-Looking Fake Blood

Store-bought fake blood isn't too expensive, but the consistency and color are always the same. Real blood varies, from bright red when oxygenated (arterial blood) to deep, dark red when deoxygenated (venous blood), and it can be either thick or thin. So to achieve the best special effect, you're better off making a batch of DIY fake blood yourself to get the look and texture you're going for. And it's very simple to do.

How To: Make a bath bomb using household supplies

Taylor and Lily demonstrate making fizzy bath bombs. Ingredients needed are one cup of citric acid, one half cup of corn starch, one cup of baking soda, and one quarter cup of a light vegetable oil. Food coloring and flavored extracts or essential oils can be use to scent them. First mix up all of the dry ingredients in a non reactive bowl. Then add the vegetable oil. Mix with a nonreactive spoon, whisk, or gloved hands. If food coloring is being used, add four drops. If using an extract or e...