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...
JoAnn, an amazing scrapbooker from Emerald City Elegance, teaches you how to make an amazing mini scrapbook album of your own out of note cards. Describes the necessary materials and tools and gives an easy to follow explanation of how to put together this excellent gift. Includes great scrap booking tips and ideas about cutting and punching holes into card stock, presentation advice, and working with different types of paper. Video includes beautiful pictures of paper crafts to get your crea...
This video by WirelessZone gives an overview and shows the first steps of setting up a recently unboxed Motorola Barrage. The demonstrator runs through the basic display settings, sound setting, the ring tones (almost all the default ones) and many more. The display settings include the wallpaper, display back light, keypad back light, feeling, icons, clock formats etc. The sound settings include the digital dial readout which reads out the number that was keyed in without looking at the phone.
This video is for XBOX360 users, and includes general suggestions for the types and models of headsets to use for the gaming system. The man on the screen giving advice is Michael Weezner, who says he is an "avid video gamer" and who has much experience about selling, buying and playing video games and accessories. He recommends the Turtle Beach Wired Headset for the XBox 360 or the Turtle Beach Wireless Headset for the XBox 360. Both have built in sound counseling features, and will block ou...
Would you like to learn to cook Korean Food? In this superb video from aeriskitchen, a Korean foodie teaches you all of the ins and outs of cooking a tasty Spicy Fried Squid recipe. The video includes a step by step guide to help you through the process, from shopping, to chopping, to the final presentation. The video includes some interesting information about the recipe, as well as some really fun Korean language lessons that will be a blast to share with your guests and family!
Want to access files from multiple computers at work or home? An expert from PC Remedies explains how to set up a Home Group network on Windows 7 systems. Includes a how-to of setting up your location, and managing the set-up wizard. Finally maximize your current resources by networking your work and entertainment files, as well as hardware such as printers. The excellent video gives you an exact snapshot of what you can expect to see on your own Windows 7 system. Includes advice on setting u...
How else are you going to delight the people of Poland without telling them how wonderful everything is? In this language tutorial, learn how to say various things are good... including yourself. Phrases include: "good computer", "good husband", "good tea" and much more.
In Poland, you will eat... and you will eat well. In this short language tutorial, learn how to ask, "Does the price include breakfast?" to your waiter, which translates to "Czy to cena ze sniadaniem?"
Jill Jaxx teaches some simple techniques you can use to improve your singing voice. These techniques are easy enough that you can practice them at home. The main focus is focusing on your breathing but includes some great (and funny) tips including holding your tongue! The student featured in this demonstration has a retainer and Jill helps her to not only relax her breathing to sing better, but to control her tongue to help get her notes and voice out the way she wants it!
Everyone wants to keep their hands warm, but here we are shown how to keep them warm with style as we are shown how Anna Saccone accessorizes, matches, and makes the warm winter dressing fashionable and exciting. From style of top to the type of footwear, Anna keeps the winter dressing trendy and tells where to buy the clothing while including clearing up some misconceptions when purchasing certain clothing online. Once Anna shows how well she can cover the basics of winter dressing, she adds...
You may think you'll never be in an emergency situation, but you can never be too prepared! This video provides excellent tips on what to bring and do in an emergency situation.
If you’re selling your home, you’ll need to know its square footage. Why pay a professional when you can measure it yourself?
Hak5 isn't your ordinary tech show. It's hacking in the old-school sense, covering everything from network security, open source and forensics, to DIY modding and the homebrew scene. Damn the warranties, it's time to Trust your Technolust. In this episode, see how to set up SSH tunneling to securely transmit HTTP traffic.
Learn how to write a grant proposal. If your organization has come up with a great idea that needs money to get off the ground, you'll need a great proposal. Here's how to write one.
This is a video walkthrough of Mission 7: "Relentless" in Call of Duty 4 World at War. This includes cheats, glitches and quick play strategies. This game is a first person shooter (FPS).
This is a video walkthrough of Visari Palace in Killzone 2. This includes cheats, glitches and quick play strategies. This game is an FPS.
Freestyle BMX bike riding includes a variety of styles of extreme BMX tricks. Learn how to freestyle from our BMX biking expert in this extreme sports video tutorial. Take action: spot your landing, gain proper speed for the trick, learn to bunny hop down, and learn to ride faki. Patrick, the instructor in this how-to video from Live Strong, resides in Campell, CA and has been riding for several years. His sponsors include Mongoose Bikes, Fox, Monster, and Calabasas Cyclery.
Potassium is an important metal for keeping your cells alive and can be found in many foods, including fruits, vegetables, and meats. Potassium is a mineral that helps maintain normal fluid balance in your body, helps control blood pressure and reduces your risk of kidney stones. Potassium is particularly high in foods like bananas, sweet potatoes, yogurt, yellow fin tuna and soy beans. Try these tips for buying foods rich in potassium in this healthy nutrition how-to video.
Project it! Sketch it! Perfect it! The Crayola Illumination Station is three great drawing tools in one! Use the light desk mode to trace one of the 10 cool background scenes-or create your own. Switch to projector mode and insert an image disc. Choose from 120 characters to project and trace into your design. Add color and shading to your creation with the included Mini Super Tip markers to complete your work. You can even detach the projector and use it as a flashlight! Includes Illuminatio...
In Batman: Arkham Asylum, the Riddler Physical Challenges can be quite difficult to beat, but if you want to clear all of them, this video will take you through each. It walks you through each and shows you where to locate them all, including getting a 20x combo and the rest of the combat challenges.
Kipkay has a new cool project for you. In this video, you'll learn how to make a laser out of a lighter. All you need to do is a cheap butane lighter. Any one will do, including one bought from a convenience store. Just watch this how-to video, and you'll be playing with your laser pointer in no time at all!
Do you have an old uninterruptable power supply you're not using or that's broken? Most people have scads of them these days, and they contain all sorts of useful electronics parts, including all of the stuff to make a little batter charger, which you'll learn how to do by watching this video and checking out the circuit diagram here.
Export your video to share on Vimeo with iMovie. This video shows the different steps involved in exporting video, including setting the video width & height, bit rate, frame rate, audio settings, and saving to a file ready for upload.
Add transitions and effects with iMovie. Effects and transitions can really influence the mood of your video. This informative and lighthearted tutorial shows the overall procedure, including the editing environment, effect preview, and suggested basic transitions to use.
Trim and cut video footage with iMovie. This video tutorial provides an overview of the steps involved, including selecting video resources to be used in the project, placing video resources in the timeline, highlighting the actual clips to be used from the resources, and rearranging the chronological order of the clips in the timeline.
Learn how to edit videos in this quick and easy tutorial. Use iMovie in this project to make a 5x5, which is a series of 5-second video clips compiled together into a 25-second video project. This tutorial details the various steps of video editing, including importing footage, arranging clips in the timeline, trimming & cutting, editing sound & music, adding text effects and exporting to a video sharing site like Vimeo.
Export your video to share on Vimeo with Windows Live Movie Maker. This video shows the different steps involved in exporting video, including setting the video width & height, bit rate, frame rate, audio settings, and saving to a WMV file ready for upload.
Add transitions and effects with Windows Live Movie Maker. Effects and transitions can really influence the mood of your video. This informative and lighthearted tutorial shows the overall procedure, including the editing environment, effect preview, and suggested basic transitions to use.
Follow along in this instructional video as Jeri Ellsworth demonstrates how to fabricate and install the passenger side bracing on dirt track racecar being built from a 1981 Camaro. The materials and tools needed for this project include a 1 3/4 x .120 tubing, an "Affordable Bender" bender, a Millermatic welder and a Hypertherm 43 plasma cutter.
Learn to fabricate the halo and window posts with some tubing and a Millermatic welder into a dirt track racecar being built from a 1981 Camaro. The materials and tools needed for this project include a 1 3/4 x .120 tubing, an "Affordable Bender" bender, a Millermatic welder and a Hypertherm 43 plasma cutter.
Fabricate and build door bars (aka sissy bars) for a full tube chassis 1981 Camaro racecar by following along in this instructional video with Jeri Ellsworth. The door bars are being built for a very rugged car, designed to withstand a large amount of side impact. Tools and materials needed for this project include 1 3/4 x .120 tubing, an "Affordable Bender" tubing bender, a Millermatic welder and a Hypertherm 43 plasma cutter.
Learn how to fabricate and install a rollbar into a 1981 Camaro being converted into a racecar. In this video, Jeri Ellsworth bends and cuts tubing into a rollbar and welds it into place. Tools and materials needed for this project include 1 3/4 x .120 tubing, an "Affordable Bender" tubing bender, a Millermatic welder and a Hypertherm 43 plasma cutter.
Learn how to tie subframe rails together with a Millermatic welder as this 1981 Camaro gets rebuilt into a racecar. In this video, Jeri Ellsworth welds the rails and shows proper preparation and technique. Tools and materials needed for this project include 1 3/4 x .120 tubing, an "Affordable Bender" tubing bender, a Millermatic welder and a Hypertherm 43 plasma cutter.
Learn to play "Holly Jolly Christmas" on ukelele this holiday season. "Ukelele" Mike Lynch shows you how on this informative video, which includes chords, lyrics, strumming pattern and technical details on the instrument used to play this song.
Including a teleporter scene in your science fiction movie? This tutorial shows you how to use a compositing effect so you can replicate the look of the Star Trek transporter. It's fairly easy - all you need are three separate, easy to work with layers.
The new Nexus S from Google comes preloaded with Android 2.3 (Gingerbread), which itself includes the latest iteration of Google's official YouTube app.
CGI and live action shots get together in almost every big-budget Hollywood movie these days, but combining them in one shot can be challenging for the uninitiated. This video will teach you all about using CGI in live action films, including the use of 3D Studio Max, Blender, and other software to do the animation, rendering, compositing, and other digital steps to making great CGI-live action integration happen.
A cyclorama wall will have a seamless connection between the all the various pieces of the wall, including where it meets the floor. This tutorial shows you how to build your own cyclorama wall using concrete, drywall and white paint.
We hear so much these days about expensive microdermabrasion and facial treatments at doctors' offices that we forget we forget we have many of the same moisturizing and exfoliating ingredients at home, including avocados, lemons, and oatmeal.
Fibromyalgia sucks. It manifests itself as pain over your entire body and even as a painful response to touch, which can make even everyday activities diffuclt to get through. But there are measures you can take to decrease this pain, including exercising and eating better. Check out the video for more tips.
