Apps Sheets Search Results

How To: Manage color in Aperture

Instead of using Photoshop, why not give Apple's Aperture a try? Aperture is designed more for post-production work for professional photographers, letting you cull through shoots, enhance images, manage massive libraries, and deliver stunning photos.

How To: Make a creature puppet that bites and wags when held

If you're in the mood to make a horror movie, complete with creepy creatures and all, then you could make your dreams come true. Just check out this video tutorial on how to make a creature puppet that bites and wags when held. You can make this mechanism using string, craft wood, and hot glue, the action can be controlled with one finger, so the puppet appears to be alive when cradled in your arms. A nifty horror prop for a "pet monster."

How To: Make Red Bull Jell-O shots

In this how-to video, you will learn how to make Red Bull Jell-O shots. You will need any type of Vodka, watermelon flavored Jell-O, ketchup and mustard containers, a whisk, Red Bull, a sauce pan, several 2 oz plastic containers with lids, cookie sheets, newspapers, a mixing bowl, and a 2-cup measuring cup. First, cover the entire work area with newspaper. Cover a cookie sheet with newspaper and place as many 2 oz plastic cups over it as you can. Pour one cup of Red Bull into the sauce pan an...

How To: Photograph a pregnant mom

In this video, we learn how to photograph a pregnant mom. Try taking a shot of the woman outside, this will feature her stomach and show off the glow of her skin as well. Process it after you have taken the photo to edit it further. Drape a sheet around the woman as well, which is a really popular photo technique as well. Take fun shots with your partner, animals, other children, and around the house! The camera can focus on different things to show multiple subjects in the scene. Be creative...

How To: Digitally print on uncommon surfaces

In this video, we learn how to digitally print on uncommon surfaces. First, you will want to apply the gloss evenly with a sponge brush. Use clear so that when it's printed you will almost be able to see through it. This will come out really crystal clear and look amazing. Take the top sheet off and set it aside to dry. Grab the underneath part and then cover this with the gloss as well. Doing this step beforehand will help the pre-coat look even better for when you are printing. Once you are...

How To: Make an origami book

Another video in which the presenter Ngai Chen Cheung demonstrates his Origami skills. Again all you need is a blank sheet of paper. The first step is to create pre-creases which makes the later folding maneuvers a bit easier.

How To: Make original Toll House chocolate

In this tutorial, we learn how to make original Toll House chocolate. First, measure out 2 1/4 c flour with 1 tsp baking soda, and combine with 2 sticks of butter. Then, add in 3/4 c sugar to the mixture with a spoonful of molasses. Now, add in one egg and combine together. Then add in one bag of Toll house chocolate chips to the mixture along with vanilla. After this, spoon the cookie batter onto a greased cookie sheet and bake in the oven until they are golden brown. take out of the oven an...

How To: Make prosciutto eggplant calzone with Guy Fiore

In this tutorial, we learn how to make prosciutto eggplant calzone with Guy Fiore. First, take dough and work it out on a flat floured surface. Then, mix the pine nuts with the cheese mixture, and cut up your prosciutto. Add on the eggplant and other ingredients into the center of the dough alone with a generous amount of parmesan cheese. After this, push the calzone down and twist the side to make it into a pocket shape. Place this onto a baking sheet, then wash it with an egg. Place into th...

How To: Treat bed bugs with inspections & follow-up

In this video, we learn how to treat bed bugs with inspections and follow-up. First, you want to take off all your bedding and sheets, then place it into a bag. After this, you need to clean it in burning hot water to make sure the bugs are all killed. After you have removed this, you need to search the mattress to find where the rest of the bed bugs are at. Check around the headboard to see if the bugs are hiding there. Once you find these, you need to use either professional chemicals or a ...

How To: Make Indian sukha aloo

In this video, we learn how to make Indian suka aloo. First, add butter to a wok, then add in cumin seeds, sliced onions, salt, sliced garlic, sliced ginger, sliced green chili, turmeric powder, and then mix together. After these have browned, add in chopped coriander leaves, then add in a pinch of cumin seed powder and chili powder. After this, add in sliced potatoes and toss all the ingredients together until the potatoes are browned. Now, add in more salt and cook on a slow flame for 10-12...

How To: Make crumpled flowers for scrapbooking

This video tutorial is in the Arts & Crafts category which will show you how to make crumpled flowers for scrapbooking. Cut out three circles of 2", 1 1/2" and 1" diameter out of a sheet of paper. Then wet the pieces of paper lightly with water or colored ink and crumple them one by one as shown in the video. Then place the three pieces together and pin them up with a split pin. Now crumple the edges of the paper further to give them the look of a flower. Allow it to dry and your flower is re...

How To: Get rid of bed bugs using a steam cleaner

In this video, we learn how to get rid of bed bugs using a steam cleaner. First, you will need to purchase a simple steam cleaner, which will produce steam that is hot enough to kill bed bugs. Now, take your steam cleaner and let it heat up for twenty minutes. Remove all your bedding items, including sheets and mattress covers. Grab your steam cleaner and steam all around the side of the bed until you have reached all of the spots. Go around the entire mattress as well as the box spring and t...

How To: Apply gold leaf to your nails

In this video, we learn how to apply gold leaf to your nails. First, paint your nails with a dark purple color over the entire nail, then let it dry. After this, apply a clear coat of nail polish and cut out small pieces of gold leaf from a large sheet. Once you have these broken apart, grab them with a toothpick and drop them down onto the nail in the spot you want them to be. You can place around two leaves on each nail. do this for each leaf, then apply the clear coast of nail polish over ...

How To: Lock & unlock cells in Excel

In this tutorial, we learn how to lock and unlock cells in Excel. First, right click one cell and click on format cells. Go to the protection cell, and then un-check the locked category. Click ok, then go to protect sheet, inside of tools. Now, do now allow locked cells to be checked. Now, you will not be able to select cells in the worksheet except cells that are unlocked. This is a great way to protect your information, so it won't accidentally get deleted or ruined. You can do this for ent...

How To: Cook a prime rib

In this tutorial, we learn how to cook a prime rib. To make this you will need prime rib, kosher salt, and bacon. To begin, grab a baking sheet and place a bed of kosher salt on the bottom of it. When you are finished, place the prime rib over the kosher salt and stick a temperature gauge into it. After this, coat the prime rib with pieces of bacon, set in with toothpicks. When you are finished with this, place the meat into the oven and cook until the meat is cooked to your liking. After it ...

How To: Origami a pajarita (bird featured on PS3's Heavy Rain)

In the PlayStation 3 video game Heavy Rain: The Origami Killer, four protagonists are on the hunt for a serial killer who murders young boys and leave behind his calling card… an origami animal. One of those animals, and the one prominently displayed on the cover art and poster art for the game, is the pajarita. Pajarita in Spanish for little bird (or even just origami in general).

How To: Make a fire starter out of recycled candles

Cut an old sheet of news paper at about five inches in width. Roll it down to create a thick stick of newspaper. Get a roll of string that is specifically made of cotton or use a natural fiber string. Tie the string around your roll of newspaper to make sure it stays together or that it will not unroll. Submerge the rolled newspaper/s on a pot of hot and melted old candles. Let it sit for at least a minute or more as needed. Remove the rolled newspaper/s from the pot and let them dry out for ...

How To: Find a weighted average cost ending inventory value

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 and Mr. Excel, the 43rd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to calculate weighted average cost ending inventory value from transactional records on 2 different sheets using the COUNTIF, SUMIF and SUMPRODUCT functions.

How To: Use Microsoft Excel 2007 for statistics

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the very first installment in his "Excel Statistics" series of free video lessons, you'll learn how to get started doing statistical analysis in Microsoft Excel 2007.

How To: Fold a box from a square sheet of paper with origami

Watch a person fold an origami box. This is an open box, like a drawer, but not like a cube. First step is typical, just make creases between the opposite corners. next step is to fold all four corners to the center point where the first two creases cross. next two opposite flat sides are folded over to the center so the fold is parallel to the sides. then unfold these last two folds, and redo it with the other two perpendicular sides. then unfold everything but two of the corner-to-center fo...

How To: Remove RC Lexan paint from a model car

To remove the lexan paint, obtain a bottle of brake fluid. Make sure you read the Material Safety Data Sheet (MSDS) for its harmful effects, and put on a pair of gloves to avoid contact with the hands when applying the brake fluid. To remove a large area of paint, pour a little amount of brake fluid onto some paper towel, and rub the area in a circular motion until the lexan paint is completely dissolved and removed from the area. A Q-tip can also be used to remove smaller areas. Apply as muc...

How To: Make coconut cupcakes with cream cheese frosting

Pat and Gina Neely show us how to make delicious coconut cupcakes with cream cheese coconut frosting. Start by mixing the butter and sugar together well. Then add the eggs, vanilla, coconut extract and buttermilk. In a separate bowl mix the cake flour, baking powder, baking soda and salt. Add the dry ingredients into the wet ingredients, and finally some coconut flakes. Blend all the ingredients well but don’t overbeat.

How To: Prepare a traditional French toast breakfast

Chef John with Food Wishes demonstrates how to prepare a traditional French toast breakfast. First, add two eggs, a half a cup of milk, vanilla to taste, salt, cinnamon and all spice to a bowl. Whisk the ingredients together. Then, slice bread about an inch thick and soak it in the batter. Use day old bread. Make sure the bread is completely saturated with the mixture. Then, preheat your oven to 400 degrees. Add a couple of tablespoons of butter to a skillet and brown the French toast. Then, ...

How To: Use an advanced filter to extract table data 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 244th installment in their series of digital spreadsheet magic tricks, you'll learn how to use advanced filtering to extract records from a database (table or list) based on 1 criterion (criteria) and place reesults on a new sheet worksheet.

How To: Make pigs in a blanket with crescent roll batter

Andrea Can Cook demonstrates how to make pigs in a blanket using crescent rolls. First, preheat the oven to 375 degrees. To make pigs in a blanket, you will need a tube of crescent rolls and hot dogs. Unfold the crescent rolls onto a baking sheet. Roll up the hot dogs in the crescent roll triangles by placing the hot dogs on the wide part of the triangle and rolling them up towards the tip. Bake the pigs in the blanket for 12 minutes at 375 degrees. For another tasty treat, you can put cheese...

How To: Draw a 3D cartoon shark

This video illustrate us how to draw 3D cartoon shark. Here are the following steps.step 1: First of all take a sheet of paper and pencil.Step 2: draw a U shape structure and again draw a U shape structure above the previous on representing the body of the shark.Step 2: Now from one end of the double U draw a V shape representing the front body of the shark, within the face draw two eyes and jaws of the shark.Step 3: Now at other end draw a tail and from the side of the body draw a triangle a...

How To: Check if a cell is empty using macros in Excel

Microsoft Excel is used to store and work on data by storing them in rows and columns in tables. You can use a macros to check if a cell is empty. To do this you have to know two short cuts. The first is the VBA Window short cut which is Alt + F11 and the other one is View Macros short cut which is Alt + F8. So open an Excel spread sheet and insert some data into a small table. Now create a macro for this tutorial. You can use and IsEmpty() functions to check if a cell is empty. Use this func...

How To: Draw a 3D fanged fish

This video illustrate how to draw a 3D fanged fish. Here are the following steps.Step 1: Take a sheet of paper and pencil and start drawing a circle forming the face of the fish.Step 2: Now in the middle of the circle draw an wavy line showing the jaws of the fish.Step 3:Now draw two small circle on the boundary of the circle forming the eyes of the fish.Step 4: Now from the jaws draw two fins in opposite direction to each other.Step 5: Now draw Two fans beneath the face showing the back fins...