In this Excel magic trick video the tutor shows how to change operator in a formula from a drop down using Choose function. He shows a basic work book which can be downloaded from the internet for hands-on to the tutorial. In this trick the tutor shows how to include some operators in a drop down box of a cell and based on this drop down value change the operators in equations that are using this cell there by dynamically altering the equation and the value produced using the equation. For th...
This video is about burning a DVD using Nero. On menu bar choose create/edit. Select audit, edit and capture video in dialog box. Nero vision 5 appears. Go to DVD dialog box. Choose where you will import video from. Drag video into open screen. For best quality keep video size to 1 GB. You can add titles, edit or create chapters. Click next. Choose a category which are choices of how the video will appear. You can customize text and audio in this screen. Click next and view the final product....
For the aspiring beat-boxer in all of us, Jaxster is here to help. In the first in a series of tutorials, these simple tips will help you learn the basics of:
This video shows you how to change you Mozilla Firefox page to look like Safari. -First go into your Mozilla Firefox page and go to Google.
Hack a PlayStation monitor into a digital television! Get that old PS1 out of the closet and dust it off, because the switch to digital television is coming soon, and you need a DTV, so why not put that PlayStation One to use? You can build a digital television from a new set top digital converter box and that PSone video monitor, plain and simple. It's easy! Don't forget that forty dollar coupon though from the government for the purchase of the digital converter box.
I have always loved the idea of faithfully keeping a journal with something written or drawn for each day of the year. In practice it has never worked. I decided that I might have a chance if I only had to write one word a day and that it was important to keep it small and simple so I wouldn't be tempted to start more elaborately and then quit because I couldn't live up to the expectation. I designed a series of small books, one for each month, that go in a box made from a cereal box. Learn h...
Got an irrational fear of your closet? You're grown-up enough to know there's no boogeyman living in there, so you must be spooked by how disorganized it is. Summon up some courage and let's get to work organizing your closet.
Can you sleep in a hammock every night instead of a bed? Millions of people around the world do. It is so much cheaper than a traditional bed/box-spring setup. Lighter too! Would you rather move a bed, box-spring, frame etc, or just a sheet with 2 carabiners, 2 Eye Bolts (Lag Threaded), and 2 bits of rope? Watch this video survival training tutorial and learn how to sleep comfortably in a hammock.
Do you dream of standing on stage in front of millions of fans with a guitar in your hand? You could make this dream come true, if only you could play the guitar! This guitar tutorial series from Robert Renman teaches you the basics of guitar playing along with a few beginner and intermediate techniques. You can learn how to play pentatonic scale boxes with this guitar lesson. This pentatonic scale technique will come in handy when you are starting to play the blues. All you have to do is fla...
This animation shows the various steps taken when creating an RTV mold. First, risers are put on the part to allow air to escape from the final mold. A thin film is attached to the part, which will act as a seam for the final mold. A box is built around the entire structure, and it is filled with silicone rubber. Once the rubber has cured, the box and risers are removed, the mold is opened at its seam, and the original part is removed. Any type of urethane can now be injected in the mold to c...
When you need to make a Ghostbusters prop, who are you going to call? Parker! In this video, he shows you how to make a proton pack prop for Halloween, play, or a home movie. You will need a vacuum hose, a small box, miscellaneous plastic parts, a medium circular tin, a big box, a tin can, a water bottle, a coke bottle, a race car trigger, a cookie package, and a pudding container. Watch this video prop-making tutorial and learn how to build a Ghostbusters proton pack.
Check out this two-part 3ds Max video tutorial which exploits a little known capability of Max to create a head. You'll find this technique easier than box modeling for heads since your topology and edge flow are there from the beginning. With box modeling, there's a lot of division, connecting, turning, etc. to get basic topology in place.
First buy a cheap rc buggy, then a cheap wireless camera and receiver off ebay. Then buy a usb TV box and plug it into your laptop. Connect receiver to tv box. Tape camera to car. Switch everything on and drive! My other camera has packed up and I can't see anything through the viewfinder or screen. That's why the filming is so bad.
In this video series you will learn several easy and fun ideas for your child to participate in that will challenge him or her and bring their creativity to the surface. It will walk you step by step through each craft and tell you what materials you will need as well as give you alternatives to certain types of materials. This fifteen video series will keep you and your Toddler occupied for hours of fun and creativity and give your child something to be proud of once he or she is done.
In this kids’ crafts video series, learn how to nurture the growth of your child’s mind and imagination, as well as how to train them to create—through clay pottery in this instance. Our expert will give you some basic instruction on how to make pottery and what craft supplies you need. Then get some free ideas and projects to work on, including a Christmas ornament and a pinch pot. Finally, learn how to use a pottery wheel, and how to teach your kids to use one.
There is more than one version of the Quick as a Wink card trick. This version begins with the deck of cards in the box, but the cards will need to be set up in advance. Put the 2 black sixes on top and the 2 red sixes on the bottom. You will leave the card that will be left in the visible. When you remove the cards from the box, press on the sides, in order to bow the box, which will enable you to pull all of the cards out except the one that you want to leave. Take the top 2 cards off the d...
In order to perform a prediction card trick, you will need the following: a deck of cards, the box the cards came in, a pen or a pencil, and paper.
Select the image whatever you want from anywhere. For example, choose Google search and type high res yoda and select IMAGES choose the picture and save in your computer. Enter into rasterbator software. From the dialog box select the language what you know. Select the image using 'BROWSE..' button and we have to select '3D-Yoda.jpg' and click open button, and then click the CONTINUE button. We have to choose the standard paper size. Next press the CONTINUE button. In this dialog box we have ...
Teach Excel describes how to create a dynamically updating named range that goes from left to right using Excel. First, you define the named range by highlighting the cells containing numbers in a certain row. In the name box to the left of the formula bar, type the name of the data. In this example, the numbers correspond to sales, so type "sales." To check if the named range works, click on an empty cell and enter =sum(sales). That should return the sum of the highlighted cells. However, as...
Michael Weisner, a 2D illustrator and graphic designer teaches us how to draw a majestic Eagle on a waving American flag. To start, you should box in the area for the flag. It should be roughly centered on the page, add a bit of a wave to box to simulate the wind on a flag. Complete the rough outline with the flag pole on the left side. Now you can begin with the Eagle. Use an oval to draw the chest of the Eagle and allow you to easily place the wings and other important features. You should ...
In this Computers & Programming video tutorial you will learn how to create a new account, add and edit in Blogger. First go to Blogger. On the home page click on ‘create a blog’. You will be taken to the account setting up page. Feed in all the details including our email. Then open your email and click on the confirmation link. You will then be taken to your dashboard or your home page. On this page you can click on ‘new post’ button and start writing your blog. When you do this a word proc...
This origami video tutorial shows you how to fold an origami 3D box. 1. Prepare a square paper. 2. Fold from 1 corner to opposite corner. Make a "x" on the folded line of the paper.
Try beat boxing to make percussion sounds using only your mouth. Follow this Howcast guide to learn how to make basic beatbox sounds.
Flip flops are the ultimate summer shoe, they can take you from the beach to the bar without a problem! Everyone has a pair, so why not make yours unique? In this tutorial, learn how to make the coolest pair of flippers on the boardwalk, completely out of duct tape.
This Arts & Crafts How-to video gives a demonstration and product review of the Fiskars Portable Paper Trimmer, used in scrapbooking, card making and other paper craft projects. Learn how to use the Fiskars paper trimmer to make any paper crafting project easier.
In this video from Rival box we learn how to defend against a straight right hand to the body. First he says you can simply back up from the straight. That's one way. Another good way to defend against it is just by blocking the shot with your elbow. He said that could hurt your opponent very much. Then he says you can counter punch against this by using your right hand either a straight or an uppercut because the opponent would be leaning down after throwing his punch. Another counter would ...
Working on the inside requires great cardiovascular training, be prepared to train hard. These shots are effective against people who do not know how to defend themselves on the inside. If you are up against someone who is very smart at shots it is essential to know how to defend yourself from the inside. This is very basic and easy. Stand in basic boxing position: hands up, tucked in, not panicking, using the strength of your arms. It is pretty easy, you are in good shape if you can counter ...
Adobe is best known for its photo and video editing software, but they also have a number of lesser-known apps that you may be interested in. Adobe Fill & Sign, available on iPhone and Android, is the best way to electronically fill out important documents on your smartphone with a third-party app.
Fast-food chain Jack in the Box has decided to put an augmented reality twist on the traditional sweepstakes promotion by employing the immersive powers of Snapchat.
Kylo Ren, conflicted villain of the new Star Wars trilogy, will surely be a major presence again this Halloween, with The Last Jedi fast approaching. His costume, all black and layered, complete with dark-side helmet and crossguard lightsaber, seems quite perfect for Oct. 31 — as well as your next DIY project.
For the past couple of years, random internet dwellers have embarked on an ambitious quest to see just how useless a box can be in hopes of earning sweet, sweet internet points. Welcome to the world of useless machines.
With the explosive popularity of both Thor himself and The Avengers, Thor is an obvious good choice for a Halloween costume. But you don't have to opt for one of the pricey, pre-made costume choices found in every Halloween store in every city. Instead, craft your own in just a few steps, saving yourself money in the process.
Video: . The Walls is a PvP survival map that takes back Minecraft to it's roots: crafting, surviving and creativity.
In order to make Matchbox Mini Chocolate Bar Holders with Cricut, you will need the following: Tag Bags Boxes & More cartridge, card stock, a bone folder, two sided tape, a cuddlebug, Stampin' Up stamps, ink pad, ribbon, a circle hole punch, and adhesive.
Steps to Configure Your Modem/Router are: 1. Open Network connection and click properties
This video shows you how to use the online file delivery service YouSenditIt.com to send a file to someone. There are two ways to do this. One is to register for an account and send a file, and the other is to do it directly from the interface that you'll find on the website. You don't have to register, but generally if your file is going to be larger than 20 MB the person on the receiving end will need to register. But in this video we're shown how to send a file from the interface you're pr...
In order to create a custom caption box in WordPress you'll need to go to your dashboard. Here click on appearances, then on editor. Now over on the right select the sidebar option. Here you'll see some code, what you need to do is find the word that you want to replace on the main page, you can use ctrl+F to find the word. When you've found it within the code just replace it with whatever you want and then press the 'apply' button. You'll see that the main page will now be displaying the wor...
How to stop a dog from digging holes in a yard
This video shows us how to make a star box from a folded paper with origami. Firstly take a piece of paper and cut it in the form of a square. Then take the top left corner and fold it to meet the bottom right corner and then crease it and then unfold it. Then do the same thing to the other side as well and unfold it. Then fold the paper vertically, crease it and then unfold it and do the same thing horizontally as well. Then pinch the top and bottom ends and claps the bottom inward to create...
First of all open the box and take out the kit, different parts and the instruction manual. You also need glue, epoxy adhesives, sand paper, 2 mm drill and a 4 mm drill. Start with assembling the outer frame of the camera by fixing in the slots. Use a screw driver to screw the bolts. Now use the glue and fix the inner parts of the camera. Now make the front portion of the camera. Fix it exactly as shown in the instruction Manual. Now drill in the holes on the sides of the camera's outer frame...
