House Based Search Results

How To: Create value-based formatting using data bars in Excel

See how to create value-based formatting using data bars and color scales in Excel 2007. See how to use the Format Cells dialog box and the pop-up mini-toolbar in Microsoft Excel 2007. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with this particular iteration of the program, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, w...

How To: Work with cost & selling price markup in MS Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 48th installment in his "Excel Business Math" series of free video lessons, you'll learn about the basics of markup on cost and markup on selling price. Markup on cost uses the base cost. Markup on selling price uses the base selling price.

How To: Throw a lamp base

You all the know the scene from Ghost? Where Patrick Swayze and Demi Moore are sitting and they are trying to make something using the machine? It's one of the most iconic scenes out there. Anyways, this video isn't about ghosts, or either of those actors, but rather that machine and what it can do. This tutorial will show you how to throw a lamp base easily. Enjoy!

How To: Use Heron's formula

Area of a triangle can be calculated when you have the length of its base and height. In this case the area is 1/2 times the base and its height. If you do not know the height of the triangle but know the lengths of all the sides of the triangle then you can calculate its area using the Herons formula. First to use it you need to computer the semi perimeter of the triangle S, which is S = (a + b + c)/2, where a, b, c are the lengths of the sides of the triangle. Now the area of the triangle i...

How To: Make a gradebook based on percentage scores 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 194th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM, VLOOKUP and ROUND functions to create a gradebook based on percentage scores that will calculate grade for you automatically. See also how the VLOOKUP and the percentage format can deliver the wrong grade when you dont use the ...

How To: Play "Tears In Heaven" by Eric Clapton on guitar

Ballinguy556 shows you how to play "Tears in Heaven" by Eric Clapton. You need an acoustic guitar to begin. You will be learning the main riff. Take your thumb and play the open E string, hammer thumb on E string and then play the open the A string. Then play the A cord bar. Then pluck E, G, E strings. Move your D cord up a step and low E. Play a F cord together and the base next. Then play an open E the same. Then play a D in the same together, base pattern while lowering your index down a h...

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: Make molded rose cake decorations

This tutorial shows how to make tiny molded roses and leaves that you could put on cupcakes. To start you only need a few ingredients: icing sugar, water, paste coloring, fondant icing sugar, and a piping bag (optional). Mix all ingredients together, then put them in a bag so they stay soft. Make the color of the rose or petals any color you want. Knead the dough so that you will have the color you would like. Next, break off a piece of the kneaded dough and form it into a cone shape. Break o...

How To: Find the surface area of a regular pyramid

In this tutorial, the instructor shows how to compute the surface area of a regular pyramid. A regular pyramid has four equal sides which are in triangle form, and the base in square form. Its surface area is four times the area of its side plus the area of its base. He goes on and takes an example with sample values and demonstrates how to compute the final value using the formula. He reminds the viewer to use square units in the final answer, as square units equal the area. To find out the ...

How To: Build a crochet style tent-bed for your pet

Crochet a cool house-tent for your little homeless friends. This instructional video will walk you through a super simple pet project. Whether you're out to craft dwellings for a dog, cat, pig, or free-range snake, this tutorial demonstrates how to build and combine all the necessary components, including the frames, walls, and personalized decorations. The results are quite cozy.

How To: Build a beam bot twin motor robot base

This robot is BEAM bot inspired. First we build up the Motor Drive, an excellent and cheap Robot Bot-Base. We start with the Tamiya kit, get it going, then strap on a battery and a drag wheel, center the drag wheel. Tape it all in place with bright yellow tape and make a BEAM Bot with batteries. Plans for this BEAM framework are to add smarts.

How To: Use the SOFLAM item in Battlefield 3

The SOFLAM is a gadget that you can use in Battlefield 3. It is a team based gadget that you deploy and use to laser target. It is different than a mortar and can be a little hard to use. This guide will show you how to get the most out of a SOFLAM so that you can tear up the other team.

How To: Make an electro pop dance beat in Reason 4

Electro pop is everywhere in these 1980's-obsessed 2000's, and if you can churn out a solid dancable electro pop beat on your PC you're well on your way to some musical success. Watch this video to learn how to make a cool dance electro pop beat in Reason 4 based on the song "Midnight Movie" by The Secret Handshake.

HowTo: DIY Lady Gaga Hair Bow

The best thing about going Gaga for Halloween is the variety of possibilities. Lady Gaga's wardrobe is vast and colorful: the Meat Dress, her trippy Anime Eyes, the scantily clad Caution Tape look, the Soda Can Hair Rollers, the light up Gothic Crown, the Cigarette Smoking Glasses, and, of course, the classic Hair Bow from Poker Face. It's my personal favorite, and the following illustration is easy to follow. If you don't feel like messing with your own hair and have a wig around the house, ...

How To: Potty train and housebreak a dog

In this tutorial, we learn how to potty train and housebreak a dog. There are a lot of techniques out there, but you will want to do in the most fast and effective manor. Some pet owners want to paper train their puppies. This may work, but it will take longer to get your puppy to associate going to the bathroom with paper. Don't let your dog pee in the house in the beginning, or this will let your dog think it's okay for them to do this all the time. Focus on all the aspects of dog training ...

How To: Make your home safe and secure with tips from Lowe's

In this tutorial, we learn how to make your home safe and secure with tips from Lowe's. You should do a safety check on your house at least once a year. Start with the entryway, making sure you have an insulated wood door in the doorway. Make sure there is a lock and a deadbolt lock on the door as well. Once inside, make sure you have timers to control your lighting, so it can come on even when you're not at home to detract any robbers. In the garage, make sure you have an electronic door ope...

How To: Play triad nuggets on the guitar with Dan Gilbert

Being a good rhythm guitar player isn't always about just knowing the chords, knowing how to break them apart and use their basic components in a creative was is also incredibly important. In this incredibly detailed video, teacher at Musician's Institute, Dan Gilbert, gives us a lesson on using triads as a base for licks and inventive ways of playing over a chord progression.

How To: Walkthrough the flash game I Remain

In this video, we learn how to walk through the flash game "I Remain". First you will go through the main floor and pick up the basement key, which you will use to go into the basement. In here, you will pick up a box of nails and return to the main floor. From here, you will go into the bathroom and pick up the extension cord. Go back into the main floor to the guest room, then pick up any tools you see in this room. Next, go to the main room and place the fuse in the fuse box. Continue to g...

How To: Create simple animation loops in Adobe Flash Professional CS5

Has looping got you thrown for a loop? See how it's done with this clip. Whether you're new to Adobe's popular Flash-development platform or a seasoned web developer looking to better acquaint yourself with the new features and functions of the latest iteration of the application, you're sure to benefit from this free software tutorial. For more information, and to get started making your own Flash-based twinkling starscapes, watch this video guide.

How To: Use the TODAY and NOW functions in Microsoft Excel 2010

Learn how to make time-based calculations with the TODAY and NOW functions in MS Excel 2010. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the Excel 2010 workflow, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, take a look.

How To: Round when making time calculations in Microsoft Excel 2007

Learn how to round to a given interval when making time-based calculations in MS Excel 2007. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the Excel 2007 workflow, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, take a look.

How To: Fold an easy plane

In this tutorial, we learn how to fold an easy plane. First, fold a piece of copy paper on one side into a triangle, then open up and fold the opposite way, making creases on both sides. Next, fold the triangle further, until you have a shape that looks like a house. Next, fold the two flaps up on top to keep the triangle shape. Then, fold them both down. After this, fold the sides of the triangles into the crease in the middle of the paper. Next, fold the paper in half and make a wing by fol...

How To: Draw an interior perspective room

In this tutorial, we learn how to draw an interior perspective of a room. First, draw a horizontal line, then start to draw squares around it, then add in the back doors and the shelves, counters, windows, and more. Add in details using vortex lines as your focal point. You can use this technique to draw several different perspectives of different rooms. You can draw kitchens, mudrooms, living rooms, bedrooms, and more. You can also add in the little details, including couches, artwork, thing...

How To: Make a Milk Jug Green House

In this video tutorial, viewers learn how to make a mini greenhouse milk jug. Begin by cutting the milk jug in half. Make sure to leave one side uncut, leaving the top of the jug on. Then pour some potting soil into the milk jug and plant some seeds into the soil. Make sure to plant the seeds deep into the soil and then pour some water onto the soil. Now tape down the top of the milk jug. This video will benefit those viewers who enjoy planting and gardening, and would like to learn how to ma...

How To: Make a perfectly thin & crispy pizza pie

In this clip, learn how to make a perfectly thin, crispy Italian style pizza with Food Mob. You will also learn how to top those beautiful bases with the best ingredients so absolutely everyone at the table will be happy. Don't bother with delivery or one of those store bought pizzas - make your own! It's worth it.

How To: Clean residue out of your car parts with SeaFoam

In this video tutorial, viewers learn how to clean the residue out of a car using Sea-Foam. Sea-Foam is a formula that is used to clean any car's residue buildup. Begin by turning on the vehicle. Add 1/3 of Sea-Foam into the vacuum lines that is connected to the break master housing. Then return the vacuum line to it's original spot. Next, add 1/3 of Sea-Foam into the crank case. Finish by adding the remainder of the Sea-Foam into the gas tank. This video will benefit those viewers who have a...

How To: Create a vector leather texture in Adobe Illustrator

See how to create a vector-based leather texture from scratch when working in Adobe Illustrator CS4. Whether you're new to Adobe's popular vector graphics editor program or a seasoned graphic arts professional looking to better acquaint yourself with the new features and functions of this particular iteration of the application, you're sure to benefit from this free software tutorial. For more information, watch this designer's guide.