Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 12th installment in his series of Excel name tricks, you'll learn apply names to formulas using Excel's built-in Apply Name Feature.
Want to lay a hardwood floor yourself? It's easy. Provided, that is, you have all of the following materials: wood panels (preferably with built-in foam underlay), plastic sheeting, duct tape, tapping blocks, a hammer, a crowbar, a straight edge, a miter square, a pencil, string line, some spacers, and a saw. For complete instructions on putting it all together and installing your own custom wooden floor using panels, watch this free DIY guide.
Whether you're using a fancy WYSIWYG (what-you-see-is-what-you-get) page editor like Adobe Dreamweaver CS5 or a barebones text editor like Notepad, if you want to build websites, you'll need to have some understanding of HTML (for the structure of your web pages) and CSS (for their style). And this free coder's guide will get you started along that path.
Want to make your very own diet cola & Mentos rocket? Sure, you could probably figure it out yourself with a little bit of trial and error, but why be wasteful? Especially when the project is already wasteful by design. Better to follow this video guide, which presents a complete overview on how to build your own Mentos & soda-powered bottle rockets.
Creating arrays in PHP is simple once you know how. And, if you don't know how, this free video guide will sort you out. For more information, and to get started building and using data arrays in your own PHP projects, watch this programmer's how-to.
With this tinkerer's tutorial, you'll learn how to assemble a fence from plastic LEGO toy blocks, a design certain to compliment most any LEGO house. For a detailed walkthrough of the assembly process, watch this free video guide.
This tinkerer's tutorial will walk you through the process of assembling a house frame from plastic toy LEGO blocks, a necessary component of any LEGO house. For detailed, step-by-step instructions, watch this free video how-to.
Beautiful cabinets really make the kitchen, don't they? Not only are cabinets handy storage, they also lend a certain level of elegance to the room depending on their craftmanship. If you would like to perform a kitchen makeover but don't want to hire someone else to do it for you, check out this eight part tutorial on how to build custom kitchen cabinets on your own.
Every fire needs three things to burn: heat, oxygen, and fuel. As long as those three things are met, the fire will persist. If you are cooking with grease and a fire starts, you must react fast. Grab an oven mitt, find the lid that fits the pan, and smother the fire. Slide the cover over the pan to cut off the oxygen, and turn off the burner.
In this video Mr.G puts a new spin on magnets and bare copper wire with just a simple battery. Motion via magic? Not quite, but pretty darn close! Join Mr. G, and build your own motor with its own unique new spin. This is a fun, easy, do it at home experiment.
If you ever get lost in the wilderness, with no shelter you'll be happy that you watched this video beforehand. From Maine Primitive Skills School instructor Mike Douglas shows how to build a door to a shelter made out of debris as well as troubleshoots common problems. Don't lose to the wilderness... beat it with your own survival skills!
The sumo deadlift is a great total body exercise. Focusing on your lower body, the sumo deadlift builds strength and this video shows you how to do it properly.
A quick fix is to wet your hands and put it in the bumps of the clothing or your lucky sweater. She explain as you wet the area were the bump is located, you should with your wet hand dab it until the surface is smooth, once this is done, grab a hair blower (any type of hair blower will be good) and with your wet hand dry is as you stroke it gently and see the bump disappear with this simple and shape way to make your cloth look a lot better.
If you want to run homebrew apps on your second-generation iPod Touch or, as a moral issue, believe you should have root access to a computer that you yourself own, jailbreaking is the key. And this guide from Everything iPod Touch will show walk you through the jailbreaking process for a 2g iPod Touch running the 3.1.3 build of the firmware.
Want to make a time schedule in Microsoft Excel partitioned into perfectly regimented 15-minute intervals? It's easy, provided you know how to go about it. And in this Excel tutorial from ExcelIsFun, the 543rd installment in their series of Excel magic tricks, you'll learn how to do just that using the Fill Handle. For a complete walkthrough, watch this Microsoft Office how-to.
What's better than Microsoft Excel's conditional formatting feature? Microsoft Excel's conditional formatting feature when used with multiple criteria, that's what! In this Excel tutorial from ExcelIsFun, the 544th installment in their series of Excel magic tricks, you'll learn how to build multi-variable conditional formatting formulas using the TRUE, FALSE and AND operators.
In this installment of home improvement do-it-yourself videos, brought to you by Lowe's, host Mike Kraft, one of Lowe's home improvement experts, demonstrates a landscaping technique that shows you how to create a retaining wall with interlocking wall blocks, that features a raised planter bed. Mike gives you a list of all the tools and materials you will need to create the retaining wall, and offers some tips on creating curved lines when laying out the wall.
While it is common knowledge that Thomas Edison created the first light bulb, he was not the first to create a means of creating artificial light. That distinction goes to a man by the name of Humphrey Davy who created a means to light up a room called an arc light. The following video will give you a detailed step by step procedure for creating your own 19th century arc light using materials that can often be found right around the home.
If you had to answer the following statement, which answer would you choose? Water is:
You might not be able to grow anymore, but you can still take some measures to utilize your natural build in a better way. You might have stopped growing, but doing simple stretching exercises can do wonders for your posture and make you appear as much as two inches taller. It can be easy hanging off a bar or stretching down to your toes and you will see noticeable improvement and be standing up straight as an arrow.
Denim is built tough enough for cowboys, miners and motorcyclists, but it's cool enough for just about everybody since James Dean. In this video from Put This On web series on dressing like a grownup, see how to buy the perfect pair of denim jeans and also some tips on how to care for them. This is the ultimate denim guide.
Learn how to save money by not hiring a professional and install your new laminate floor on your own. In this video, Matt from Build Direct shows how to install a laminate floor, making sure you don't break the tongue on the laminate flooring boards.
Grab some paper, pennies, and paper clips, and create this stealth weapon in the comfort of your own bedroom. Scaled to actual size, this craftable katana can be used to fend off paper-based attacks, or displayed for decoration. Add as many, or as few, foldable components to customize your sword size.
Using Curious Turtle's Film Wash Color Effects in After Effects create a Super 8 look to your film. In this tutorial, you will learn how to build up a color grade using several layers, then using expressions and After Effects own filters to finish the look. To learn more about the Film Wash, visit www.curiousturtle.com
Have you ever been curious about how a guitar goes from a couple slabs of wood, to a beautiful hand crafted instrument? In this two-part video series, learn how these precious instruments are made from start to finish. In two parts, witness the adding of kerfing, inlaying the tail wedge, the installation of the binding, and construction of the back, the soundboard, the fretboard, and the bridge.
The Winogradsky column, invented by Sergei Winogradsky, is a device for culturing a large diversity of microorganisms. Pond mud and water are mixed into a column using carbon sources like newspapers and sulfur sources like egg yolks. Left in the sun for a few months, the column becomes a colony rich with microorganisms, bacteria, cyanobacteria, and algae. In this video, scientist Karen Dodson shows you how to make your own.
Rocket Racer was the lead bad guy in "Lego Racers", a 1999 video game where players could race Lego go-karts. You faced off against him in the game's final race, and he was surprisingly tough to beat. But no matter how many times he beat you, you had to admire his cool car. This short video uses stop-motion to teach you how you can use Lego bricks to make Rocket Racer's go-kart.
"Lego Racers" was a 1999 video game where players could assemble their own go-karts using virtual Lego pieces and then race them. This short video employs stop-motion animation to show you how you can use Legos to make a toy go-kart for Johnny Thunder, one of the game's characters.
If you grew up playing the video game "Lego Racers" you probably wished you had some of those Lego go-karts for real. This short video uses stop-motion animation to show you how you can use some of those old Lego pieces under your bed to make a toy go-kart for Gypsy Moth, one of the game's characters.
Skimboarding is a fun sport similar to both surfing and skateboarding. Plywood boards are ridden out into the surf from the shore or are used to perform tricks in the shallow water. This how to video demonstrates how to build your own skimboard and customize it to your liking. All you need is plywood board, a jigsaw, sandpaper, and paint. Happy skimboarding!
The slip knot, also called a running knot, is a very diverse knot. It's practical application ranges wildly from crochet and knitting to building a noose. The basic function of a slip knot is to create a flexible knot, with one end tied to the middle for greater mobility. Check out this how to video and learn how to tie a slip knot, because you never know when you might need it.
This lesson is part of a series of video language classes which will build a solid foundation for learning how to speak Arabic. The instructor in these instructional videos is a native Arabic speaker who started making his own teaching tutorials in an effort to demonstrate clearly how the language is really spoken back in his home in the Middle East. In this video segment, the instructor will focus on the ash-shaddah accent mark in Arabic
This lesson is part of a series of video language classes which will build a solid foundation for learning how to speak Arabic. The instructor in these instructional videos is a native Arabic speaker who started making his own teaching tutorials in an effort to demonstrate clearly how the language is really spoken back in his home in the Middle East. In this video segment, the instructor will focus on the last three letters of the Arabic alphabet.
This lesson is part of a series of video language classes which will build a solid foundation for learning how to speak Arabic. The instructor in these instructional videos is a native Arabic speaker who started making his own teaching tutorials in an effort to demonstrate clearly how the language is really spoken back in his home in the Middle East. In this video segment, the instructor will focus on three letters of the Arabic alphabet.
This lesson is part of a series of video language classes which will build a solid foundation for learning how to speak Arabic. The instructor in these instructional videos is a native Arabic speaker who started making his own teaching tutorials in an effort to demonstrate clearly how the language is really spoken back in his home in the Middle East. In this video segment, the instructor will focus on three letters of the Arabic alphabet.
This lesson is part of a series of video language classes which will build a solid foundation for learning how to speak Arabic. The instructor in these instructional videos is a native Arabic speaker who started making his own teaching tutorials in an effort to demonstrate clearly how the language is really spoken back in his home in the Middle East. In this video segment, the instructor will focus on at-tanween.
This lesson is part of a series of video language classes which will build a solid foundation for learning how to speak Arabic. The instructor in these instructional videos is a native Arabic speaker who started making his own teaching tutorials in an effort to demonstrate clearly how the language is really spoken back in his home in the Middle East. In this video segment, the instructor will focus on the Arabic letters ain and 'ain.
This lesson is part of a series of video language classes which will build a solid foundation for learning how to speak Arabic. The instructor in these instructional videos is a native Arabic speaker who started making his own teaching tutorials in an effort to demonstrate clearly how the language is really spoken back in his home in the Middle East. In this video segment, the instructor will teach the letters ra, zay, seen, and sheen in Arabic.
This lesson is part of a series of video language classes which will build a solid foundation for learning how to speak Arabic. The instructor in these instructional videos is a native Arabic speaker who started making his own teaching tutorials in an effort to demonstrate clearly how the language is really spoken back in his home in the Middle East. In this video segment, the instructor will focus on accent marks in Arabic.
This lesson is part of a series of video language classes which will build a solid foundation for learning how to speak Arabic. The instructor in these instructional videos is a native Arabic speaker who started making his own teaching tutorials in an effort to demonstrate clearly how the language is really spoken back in his home in the Middle East. In this video segment, the instructor will focus on the Arabic letter dal the-al.
