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 and Mr. Excel, the 13th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create formulas that will calculate the AVERAGE excluding zeros (0) in the original data set.
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 and Mr. Excel, the 8th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to deal with common filtering problems.
Sure, individually wrapped straws of the sort found at your favorite café, diner or fast-food joint might seem like a colossal waste — and actually be a colossal waste, for that matter — but there's no denying that there's a lot of fun to be had with the straw wrappers themselves. With this tutorial, for instance, you'll learn how to make a cinchy paper inchworm.
Tired of slipping on hard wood floors, but too cold to go barefoot? Make some of your favorite socks slip-proof. This how-to video project is an easy way to revamp your socks into a safer non-skid style. Your injury-free joints will thank you.
Here’s the scary thing about body odor: You can’t smell your own. Make sure you’re not stinking up the joint by reviewing your hygiene habits. Watch this Howcast how to video to figure out if you have B.O.
This medical how-to video demonstrates the proper technique for evaluating a patient's shoulders. Follow along and learn how to do a shoulder physical examination. As with all examinations of the joints it is important to follow a standard routine including range of motion, inspection, and to compare the affected shoulder to the unaffected shoulder. Please note this instructional video is intended for medical professionals.
Your 60s is the time to exercise and stay fit and flexible. Learn exercises and fitness tips for your 60s in this exercise and fitness tutorial. To exercise in your 60's you should use resistance bands, alternate resistance levels, and work joints and back. With this how to video you will be able to safely and effectively workout well into your 60's.
Watch this video tutorial on how to make a note card holder that holds four note cards and four envelopes. You will need a large piece of cardstock to complete this box. Use double stick tape to hold the joints together. You can decorate the outside with store bought cut outs or use recycled scraps of paper and ribbon.
This is a video tutorial on how to make a box with a scalloped lid. You will need a large piece of cardstock to craft this box. Use double stick tape to hold the joints of the box together. You might need a stenciling tool to make accurate cuts. You can use store bought or use recycled scraps of paper ad ribbon to decorate the outside of the box.
Watch this video tutorial on how to make a card organizer. You will need one large pice of cardstock to make this paper box. Use double stick tape to hold the joints together. When finished, you will enjoy having this homemade box to keep your hand crafted greeting cards.
Witness this step by step photo presentation of sculpting a mini monkey from polymer clay by Judy Dickinson. Bake the individual pieces of the face and body wrapped in aluminum foil. Delicately sculpt the monkey's arms and legs, leaving ball joints to sew on a fabric body. When the monkey pieces are done baking, paint it and sew a little outfit for your cute baby monkey doll.
Watch this instructional yoga video to do the stoop pose. This yoga pose is also called the Hindi squat. The stoop pose is a simple and efficient exercise, but you should make sure you are doing it right. The squat pose opens up the hips and pelvis. Use a blanket or mat to protect your joints.
Properly warming up is an important part of strength training and weight lifting. This fitness HowTo video tutorial shows you the proper way to warm up before any weight training workout. Keep watching to learn more about how to warm up your shoulder and knee joints.
This instructional painting video demonstrates how to prep and paint a room. First, go through the room and spackle any holes or dents in the wall. Sand it down after the joint compound dries. Paint the ceilings first. Follow these step by step instructions to paint a room; trim, window sills and all.
No brick oven pizza joints around? Miss that unique flavor and crust only high dry heat and bricks can produce? Wish you could make an authentic old time brick oven pizza, just like the famous pizza houses in New York and New Haven? It's easy to do with a few bricks, your charcoal grill, and some simple tips as shown by one of the BBQ Pit Boys in this how to video.
Pilates exercises involve strengthening the core and flattening the abs, so why are your instructors always talking about the pelvis? This how to video explains the importance of pelvic placement and how it relates to the lower back and the muscles around the hip joint. Just becoming aware of your pelvic placement as you drive your car, walk down the street or do any household activity can help you improve your alignment and strengthen the deep postural muscles of your body.
Tim Carter of Ask the Builder demonstrates how to flare the end of soft copper tubing to produces leak-proof joints. Tim explains how soft copper can be bent without kinking. Great video with minimal use of tools.
This video shows how to repair the damaged trailing edge of a wooden aircraft propeller using a scarf joint. It also shows how to fiberglass the repair.
The Swiss ball brings an element of instability to basic exercises like the straight leg bridge. This stimulates and conditions your deep core muscles improving spinalstability. In addition to these small but important joint stabilizer muscles the Straight Leg Bridge also targets larger prime movers in your back, glutes and hamstrings.
By Zech Browning Shihan of Gyodokan Martial Arts. Step 1: "Storm Within the Calm - Putting It All Together - Part 1"
Cinema 4D is an amazing program, but not a one-stop source for animation needs, especially if you're planning on making a 3D video game, for which you'll need Unity 3D. This three-part video covers the process of rigging a character in Cinema 4D and transferring to Unity 3D.
In this how-to video, you will learn how to maintain your recorder instrument. First, label your recorder with a permanent marker in case you leave it somewhere. This will allow someone to identify who it belongs to. First, use the cleaning rod and put a piece of cotton cloth on it. Push it through the opening of the recorder to get any spit and dirty out of the recorder. To clean the mouth piece, use an old tooth brush and scrub it. Once in a while, it is a good idea to wash the recorder in ...
With their first attempt at the mobile market, Razer introduced a device that looks at the smartphone differently. Instead of focusing on minimal bezels or an amazing camera, Razer decided to make a phone for gamers. So how could Razer target the growing mobile gaming market, which is projected to generate $40.6 billion in global revenue in 2017? It starts with the IGZO LCD Display.
To tile with large format and natural stone tiles onto walls you must first make sure the walls are flat, clean, dry, and free of any dust, dirt, oil, grease, and any other loose material. Ensure that surfaces are suitable and prepared as advised. Then use the Dunlop Universal Bonding Agent where you will be applying the tile. For gypsum plaster and gypsum plasterboard, apply two coats of Dunlop Universal Bonding Agent, diluted with one part bonding agent, two parts water. Then allow primer t...
Even if you're a seasoned yoga veteran, you know how hard it can be to roll out of bed at six A.M. in the morning and do that first down dog. Stiff joints, hamstrings that haven't been stretched out, and groginess probably don't help to wak you up pleasantly.
In this tutorial, we learn how to lay out and plan your drywall with Myron Ferguson. First, check the wall to make sure there is proper access inside to see what layout you're dealing with. Next, plan out what kind of materials you are going to have to deal with. Measure the ceiling and windows that are in the building and do the math to figure out how much drywall you need. Next, check for possible problems with the wall, so you can make sure your drywall will attach correctly and not pop ou...
Improve your acoustic and electric skills with this special Delta Blues piece. Watch the full video lesson to learn how to play Muddy Waters' "Can't Be Satisfied" on your blues guitar.
Check out this human anatomy video tutorial to see how to dissect a human for a deep look at the pharynx, the mouth, and the cervical joints.
When you dissecting a human body, the second thing you probably want to check out is the vertebral column. This video tutorial will give you just that, an anatomical look at the back muscles and the spinal cord.
Watch this video from the Concrete Network to learn how to use the cut-off saw, used to cut control joints in concrete in order to prevent cracking.
In this Blender lesson you will learn how create and use armature (arms or jointed objects).
Cory Norlund, a person living with HIV, and his mother Diana Norlund discuss how their family dealt with the news that Cory was HIV positive. He and his mother now make individual or joint presentations about HIV/AIDS under the auspices of the not-for-profit organization He Intends Victory.
Learn how to use weights for working multiple joints through multiple exercises. This video gives some great combo weight training exercises.
Learn some basic plumbing skills. Watch this video to learn how to glue PVC joint pipes together to form your drain lines.
Tim Carter explains when you should use the fast-drying joint compound. Great video to learn a time-saving compound process.
Tim Carter shows how to fix a leaky gutter. Watch the video for best results.The gutter seal material is easy to work with. It can be spread with a twig or stick and it sticks tight to the gutter. Your leak at that joint will be solved.Watch the video for best results.
The worst thing to clean up is a broken egg on the floor, it's not only smelly but gooey too. Here's a really fun booby trap you can pull off at home using an egg, it will require the use of 2 magnets and a paper cup like the ones you get a your local fast food joint.
This video will show you how to use a SharkBite c to joint together copper,PEX,CPVC pipe with out using solder and flux. Simple repair.
This wrap is intended to support and stabilize the ankle joint. Supplies needed include a 1 - ½'' – 2'' adhesive tape, pre-wrap, and heel and lace pads. Apply heel and lace pads at high friction areas, including the distal aspect of the Achilles tendon, and the dorsal aspect of the ankle joint. Apply under-wrap to secure them in place. It is critical that the foot remains at a ninety degree angle for this portion of the procedure. Apply an adhesive tape anchor strip at the lower leg, approxim...
If your decking boards need to be replaced it is really not that difficult. Start by removing the facia or edge boards that hold the decking boards in place using a crowbar. Remove the decking boards from the joists. Check the joists for dry rot while you have the decking boards off by poking them with a screwdriver. If the wood is soft and the screwdriver sinks right into the joist then you may need to replace that joint because it is dry rotted. When replacing the decking boards it is best ...
