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 90th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the DSUM and DCOUNT functions to sum or count between an upper and lower limit.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 66th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to pull data from a table on one worksheet to a second worksheet using the VLOOKUP and DGET functions.
Of two old t shirts, one is taken and marked from the collar to under the armpit on all four sides of the t shirt. The marked lines are cut along. The shirt is tried on and pinched and pinned under armpit until the right fit and marked with chalk. Both sides of the shirt is cut off and along the chalk line is pinned. A straight edge and chalk is used to make a line from the pin to the bottom edge of the shirt on both sides.Both side of chalk lines are pinned down. The bottom is made even with...
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 521st installment in their series of digital spreadsheet magic tricks, you'll learn how to round numbers two different ways.
In this how to video, you will learn how to perform the full yogic breath with retention. Lengthen your spine and feel the back of the head extend towards the ceiling. Feel your shoulders move out towards the sides. Place your right hand on your abdomen and left on the chest to feel the movement of the body as you practice this. Inhale into the abdomen and feel it expand into the rib cage. Keep inhaling into the chest and collar bone. Exhale from the chest only and contract the rib cage. Last...
Want to attach an appliqué with a whipstitch? It's easy. So easy, in fact, that this guide can present a complete and thorough overview of the stitching process in just over two minutes' time. For more information, as well as to get started applying your own appliqués by whipstitch, watch this free video guide.
Want to make your own electromagnet? It's easier than you'd think. It's so easy, in fact, that this video guide can present a complete and thorough overview of the entire magnet making process in just over two minutes. For complete instructions and a list of necessary materials, watch this free home science how-to.
Sure, carbon and oxygen are two of very most fundamental building blocks of all life on Earth — but what have they done for you lately? With this free video guide, you'll learn how to build a safe, simple carbon-dioxide-powered bottle rocket with baking soda and a spent soft plastic waterball.
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 151st installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate the days, months or years between two dates using Excel's undocumented DATEDIF function.
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 9th installment in their series of digital spreadsheet magic tricks, you'll learn how to use Excel's EXACT function to check to see whether two text strings are equivalent and whether or not they have the same case.
For all your origami enthusiasts, take your art of origami to greater heights by using a dollar bill to create the impossible—fireworks! In this two-part video tutorial, learn how to fold origami fireworks from a single dollar bill. It's a great origami project for the 4th of July or New Year's Eve.
For all you origami fanatics out there... Why not try this project on for size? In this two-part video tutorial, learn how to origami a pretty impressive snowflake designed by [www.origamidennis.co.uk/ Dennis Walker]. For this project, the recommended paper size is a hexagon with a side length of 10cm (approx. 4in).
This two part tutorial will teach you exactly how to close a wound like a doctor would. This is a good skill to master for emergency situations where medical help may not be immediately available. Watch this video for step by step instructions on how to suture.
Nothing soaks up sauce better than a big piece of French bread. In this two part tutorial, learn exactly how to make bakery style French bread from scratch and impress your guests!
This two part video will show you how to make the Japanese 8 in 2 patter, an important part of making a chainmail cube.
This card trick is called Jack the Bounty Hunter. After a series of cuts, placements, and sorting, Jack the Bounty Hunter ends up adjacent to a card the spectator picked earlier in the trick. Brief synopsis of the procedure (you need to see the video for the full explanation): First, you set a Jack aside. Then you make two piles of 15 cards and set them aside. The spectator gets a pile, and you get a pile. Cards are cut. The spectator picks a card from the remainder of the deck. The spectator...
Garden of Imagination demonstrates how to make a real working miniature chandelier light for a doll house. We need some cord wires, beads, an electric bulb of 12 volt and plugs.
Show the world just how resourceful you are next time you get a flat bike tire. With the help of some local plant life and some gusto you too can ride your bike to safety without the help of a standard repair kit.
Want to share Internet connectivity between two computers without a wireless network but have an extra CAT5 ethernet cable? You're in luck. This home networking how-to will show you what to do to get your machines talking not only to one another but the web at large.
Learn how to treat cystic acne from a real doctor. 1 Painful cystic acne must be treated from within, topical solutions don't work. 2 If you have cystic acne you can consult your doctor and get a prescription for oral antibiotics. A two - three week course of oral antibiotics should help. 3 If that does not work ask your doctor for Accutane to help cure your cystic acne.
Jill Erickson from Art Jewelry Magazine demonstrates how to make a Jellyroll cane with polymer clay. Condition two different colors of clay by running them through a pasta machine set on medium. Then, trim off any rough edges. Stack the clay on top of each other and place a little bit of pressure on it to confirm the two layers. Using a blade slightly bevel the edges. Slide the blade underneath the two layers of clay for easier handling. Place a think snake of clay in the contrasting color on...
This is part one of two in how to make a beautiful tree of life pendant. It is very easy, and you'll only need a few items. Things you'll need: wire 2-3 mm thick, Round nose pliers, 4 pieces of thin wire, 12 inches long, wire cutters. With your round nose pliers, bend the thick wire about an inch form the end. Make a question mark shape, and twist the end around. Go down about 5mm, and make a 90 degree bend. Go across as far as you want, and make another 90 degree bend. Keep making bends unti...
Darci Larocque, Blackberry Expert, explains a quick way to hide sent messages from your inbox folder with a few simple clicks, leaving clutter and needless distractions behind. This easy-to-understand tutorial is fully complete from start to save with visible screen shots and clear concise directions. There is even a simple two-button solution to see your sent messages again as needed. With a few easy steps, your inbox clutter can be a thing of the past.
As your home ages, so does your deck in the backyard, but there are ways to resolve this issue. If that wooden deck is looking weathered or worn, you can simply replace the components with composite materials without a complete rebuild. Composite doesn't splinter or have knots, and it's low maintenance. This two-part video, brought to you by Lowe's, will show you exactly how to renew your deck with composite decking.
Learning American English is often difficult when faced with two words of similar spelling or sound. This is certainly true in the case of "we're" and "were".
Looking to get super creative with your shoelaces? In this video, fifteen different shoelace styles are gone over with diagram as to how they were done. Such styles include the checkerboard, the double back, loop back, sawtooth, riding bow, twistie, lattice style, footbag, ladder, bushwalk, bi-color, display, hidden knot, and the zipper style. Use two different colored laces when doing these styles to jazz things up!
In this video, learn how to make your own homemade electroscope. An electroscope is an early scientific instrument that is used to detect the presence and magnitude of electric charge on a body and for static electricity experiments. They are easy to make. This electroscope is made from a binder clip and two sheets of plastic (or overhead transparency film), and scissors.
In this two-part science tutorial, learn how to make a cartesian diver, easily & inexpensively. A Cartesian diver, sometimes known as a Cartesian devil is a classic science experiment, named for René Descartes, which demonstrates the principle of buoyancy (Archimedes’ principle) and the ideal gas law.
Too many people just drive their cars for a few years and then replace them. When treated right, cars can keep on running for decades. You may not be able to keep your car running forever, but you can definitely extend its life.
In this Jerk dancing tutorial, a young man by the name Young Maj teaches us in a few seconds how to do the basic Jerk step. After? He burst out into a crazy advanced Jerk dance full of dips and acrobats... Not for beginners or those with bad backs. 'A' for presentation however, Young Maj!
Lindyhopper49, a huge fan of the "King of Pop", will teach you how to dance like Michael Jackson. He's not a professional dancer, but he does have some great advice and information on how to to Jackson's most famous moves.
Basic 1pt and 2pt perspective drawing. This is a CAD video, but it is designed to teach you how to hand draw everything. The draw three dimensions, off the paper and in the Z plane, one must have a very good idea of how the setting appears.
Understand how binary numbers work, including how to read binary numbers, and create your own. This mathematics or computer programming tutorial is a zip to get through. It covers practical and theoretical use and need for binary code understanding. Binary means zeroes and ones in a series. This is paramount to digital transmission versus analog that transmits in a sinusodial wave form.
Don’t pay a handyman to do this simple job—learn how to become handy yourself! You Will Need:
Pouring a Guinness is not like pouring any old beer. Learn how to do it like a real Irishman. You will need Guinness Stout and a 20 ounce tulip pint glass. Did you know? According to Guinness brewmaster Fergal Murray, the perfect Guinness pour should take 119.5 seconds.
Light up your world with these beautiful and easy-to-make illuminated LED balloons. You will need:
Second Class Boy Scouts work on building their outdoor survival and camping skills. Compass work, nature observation, camp tools, and swimming are areas where new skills are mastered and demonstrated. A second class scout, having completed all the requirements, should be able to lead a hike, care for his own equipment, set up a campsite, and perform basic first aid.
Second Class Boy Scouts work on building their outdoor survival and camping skills. Compass work, nature observation, camp tools, and swimming are areas where new skills are mastered and demonstrated. A second class scout, having completed all the requirements, should be able to lead a hike, care for his own equipment, set up a campsite, and perform basic first aid.
Second Class Boy Scouts work on building their outdoor survival and camping skills. Compass work, nature observation, camp tools, and swimming are areas where new skills are mastered and demonstrated. A second class scout, having completed all the requirements, should be able to lead a hike, care for his own equipment, set up a campsite, and perform basic first aid.
Second Class Boy Scouts work on building their outdoor survival and camping skills. Compass work, nature observation, camp tools, and swimming are areas where new skills are mastered and demonstrated. A second class scout, having completed all the requirements, should be able to lead a hike, care for his own equipment, set up a campsite, and perform basic first aid.
