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 206th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate commissions with the VLOOKUP function when the lookup value is an account type instead of a number.
A fun type of bracelet is the paracord. It is a heavy duty, unique accessory that is relatively easy to make. In this tutorial, learn how to use the cobra style weave to make a funky looking piece of jewelry. This makes a great addition to your personal style or a wonderful gift. Give it a try!
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 252nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use a cell range typed into a cell in a function.
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 235th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a custom number format for inches that will allow you to type decimals or fractions and have it formatted as inches.
Real flowers are beautiful, but they don't last very long. In this tutorial, learn how to solve the problem of wilting daisies with these fabric flowers! In this video, you will see exactly how to create three different types of fabric flowers and accessorize to your heart's desire.
In this video he just explained about how to solve an algebra problem. The problem is -7+13x=58. He just solve the problem in simple steps. First you find out the x in this problem. To find out x you just add 7 to each side. Then it will be -7+7+13x=58+7. Then the equation will be 13x=65 because in the left side of the equation -7 canceled by +7 so then the equation is 13x=65. Next you just add the divide by 13 each side of the equation. Then the equation will be 13x/13=65/13. Then 13 divided...
Need help tracing an IP address to a location? Well, Tinkernut has a clear and effect way to help out.
Cell phones companies are constantly claiming to have the best service in town; but more often than not your service will be patchy. Check out this tutorial for information on how to boost your phone's signal and get the best reception.
Whether you are protecting your children or hiding personal information, there are ways to block unwanted websites from your computer. Follow this tutorial and learn how to accomplish this on a Windows PC easily.
This wonderful video takes you step by step on growing your very own grain sprouts. You can also use this tutorial to grow all types of grains like, barley, kamut, oats, rye, spelt, triticale or our grain mix. Grain sprouts are so fast and easy that they've included directions for sprouting in both a , mason jar and an easy sprout sprouter in this one video. After this video you'll be sprouting all over the place.
In programs such as Microsoft Word moving text around can save quite a bit of time and for some be easier than re-typing whatever it may be. It's an easy task, but it entirely depends on what kind of computer you own, whether it's a Mac or a PC. In this video tutorial find out how to select, drag, copy, and move text while using a Mac operating system. Enjoy!
There are so many different lighting kits out there, but what's the right one for you. Fortunately this video tutorial series demonstrates the different types of lights and picking which ones are the right for your production.
First download Paint.net. Save the YouTube logo on your computer and then open it using Paint.net. Press S and select the "You" from YouTube, once selected press delete. Now press F and choose the white color, pain the deleted area to fill it with the white color. Press T to select the text tool, select the font Arial Narrow and choose the font size 144, press ctrl+shift+N to create a new layer. Now click on where you want to the text appears and type anything you want. Go to File and Save As...
How to Install Installous on any iPhone or iPod Touch? Learn about it in this video tutorial in the Electronics category. For this purpose you will need a jailbroken iPod Touch or iPhone. First go to Cydia and open it. It takes a little time to load. Go to manage -> source -> edit -> add. Then type in this source: Cydia.touch-mania.com. Download and install it. Now you go to search and type in Installous in the search box. Download it and go back to your springboard. Open it up, search for an...
In this video the instructor shows how to hide any kind of file in a .Jpeg image file. To do this take the image in a new folder. Go to start button and then to run. Type cmd in the run and hit enter to open the command prompt. Now browse to the directory that contains the picture and also the file that you want to store using the CD command. Type the command to create our required file as shown in the video. Now a new file will be created that contains your image as well as the file that you...
First, on your computer access your command prompt and type in ipconfig. Find the line called default gateway and write it down for later. Type your default gateway into your internet address bar and it will bring up your router setup page. Find your upnp and enable it, this will open your NAT. Start your XBox 360 and go to system settings on your XBox dashboard, go down to network settings and test your connection. Next go to IP settings then manual then IP settings. You want to change your ...
In this video, Lusitano 9514 will show you how to make a homemade rubber band bow and arrow out of common household items. To do it, you will only need a basic plastic coat hanger, a long rubber band, and some kind of a stick (for the "arrow"), all of which are quite inexpensive. Watch Lusitano 9514 demonstrate for you exactly how to make the bow and arrow, and show how it works. You will also learn tips and tricks, such as what materials make better ammunition, and what kind of "arrows" are ...
In that video you learn how to hack ikariam.
There is a wide rage of variables to consider when considering getting breast implants. This includes everything from if you are a good candidate, the type of implants, the size of the implants, the type of surgery, the size and the possible side-effects.
This video will show you how to send a text message with the Samsung Galaxy I7500. Just follow these simple steps to start sending text messages from your Samsung Galaxy I7500: From the home page, tap the messaging icon. Select "New Message" Tap the "To" field and enter either the name or the number of the person you wish to send a text to. Type in your message, and when you are done, tap the "Send" key.
In this instructional fishing video from Fishing-Live-Bait, you will learn how to properly tie The Rapala Knot with the Rapala loop that was invented and recommended by the Rapala brothers, who developed this special type of lure. Using an oversized rope that makes it much easier to see and understand how and what he is doing with the string, the host demonstrates for you how to tie this particular knot in an easy to follow, step-by-step manner.
Joann from Paper Crafting shares her tips in this video for filing and saving her scrap paper and card stock. She has created a new system where she uses "paper protectors". They must be clear and they should be intended to use more than one piece of paper. She then puts the scraps coordinated by color and paper type in the clear plastic protectors in a basket so they are always handy.
This walk-through video tutorial shows you how to find out your IP address for XBox live. First press the start button and search for run as shown, click the result, bring up the dialog and type in the given command to open the command prompt window. Type the command in the given window and hit enter. The number that appears is your IP address, use it as the key for XBox Live. In the case of XBox 360, it automatically detects it.
For people who are not very skilled at using the internet, this video has just what you need in order to start and set up a Yahoo email account. After going to your address bar in your internet browser, type in "mail.yahoo.com", which will bring you to the homepage for Yahoo mail. After clicking the button which says "Sign Up", follow the simple steps provided while watching the video in order to get a better understanding on how to create your own email account.
Guitars will need to be tuned continuously to ensure that it is tuned for the correct scale and notes so your music makes sounds the way you intend. If you haven’t been playing forever, you will probably need the assistance of an electric tuner to find the note. This video will show you how to tune your guitar using a tuner.
Get started crocheting with this informative two-part video hosted by a crochet expert. In this two-part video series, learn about the various yarns used in crochet, how they are packaged, and what types of stitch they are use for.
Mark Donovan of Home Addition Plus goes over the key features and benefits of the Rockwell reciprocating saw with active vibration canceling technology. A reciprocating saw is a type of saw in which the cutting action is achieved with a push and pull reciprocating motion on the blade. A positive feature of the Rockwell is that there are no tools needed to replace the blade and it acts great with all materials including wood, metal, plastic, and/or aluminum.
Chef, Gary Rhodes stuffs a whole edam cheese, making a lasagna-style dish of sorts, with this Dutch-inspired Caribbean recipe. Edam is a Dutch cheese that is traditionally sold as spheres with pale yellow interior and a coat of red paraffin wax. By drilling out the center, it leaves a great bowl type shape to stuff. Depending on how spicy you like things, be careful how much chile you use within this recipe!
Duct tape is versatile and can be used for anything. But did you ever imagine that it can be used for making a book cover? Protect your books with sturdy duct tape. This tutorial shows you how to make a general book cover for a paperback using duct tape, but the process can be extended to cover any type of book. Protect all your books from damage with duct tape.
Epson sells many different digital imaging products, including ink jet printers and all-in-ones, digital photo printers, multimedia projectors for business, education, and home entertainment, scanners, digital photo viewers, professional imaging/wide format printers, and more. Check out this video to learn how useful and versatile your new Epson Artisan 810 all-in-one printer can be.
Byrd Designs Hair Accessories and Jewelry brings you this video tutorial on how to style your hair in a French Twist updo. This simple updo works in all types of hair.
Learn how to make a traditional origami lily or iris flower. This video shows how to make a type of flower that looks like a lily. I've used orange paper to make it look like a tiger lily, one of my favorites. You'll need to start from the frog base.
Have you ever wanted to transfer iTunes-purchased songs from your iTunes player into a different media player? Usually it's difficult to do because DRM music protection makes all of its songs .m4p files, whereas most music players only play mp3 files.
Learn how to fold a paper Jet plane. Materials : A4 size paper (type 80gsm or lower).
This is a short video about collecting old or antique binoculars. This binocular video is helpful if you are interested in buying, selling, collecting or just learning about these old scientific instruments. This can help with all kinds of binoculars like Ross, Barr and Stroud, prismatic, or Galilean types.
An important part of surgery is knowing the various types of closures to perform. This medical how-to video demonstrates how to do a deep dermal suturing technique. The deep dermal technique is especially good for laceration repair or wound closure in the operating room. Follow along with the medical video to learn the deep dermal closure technique.
This audio editing software tutorial will show you how to use all the different editing tools in Pro Tools. This includes the zoom, edge, selector, grabber, scrubber, and pencil tools. (Connor Smith also talks about the multiple types of zoom tools, the time compression/expansion and loop tools, and also the object and separation grabber tools). So if you aren't familiar with the editing tools available in Pro Tools, watch this tutorial and get started editing music!
This is the first drum editing video in Pro Tools from thestudiofiles.com.
This Photoshop CS3 for beginners tutorial introduces new Photoshop users to the rectangular marquee tool, the fill command and working with text. You will learn how to create a "senior pic" type graphic using some simple text and basic shapes created with the rectangular marquee tool in Photoshop CS3.
Learn how to build an environmentally friendly directional WiFi antenna with this simple video guide. To follow along at home, you'll need the following things: a copper wedge, an N-type connector, some screws, a clamp-on N plug, a pigtail, and a wireless card. You'll also need a drill, screwdriver, and soldering iron. For comprehensive, step-by-step instructions on hacking your own directional WiFi antenna from a tin can, watch this video tutorial.
