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 2nd installment in their joint series of digital spreadsheet magic tricks, you'll see two methods for subtracting 35% from a column of values.
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 25th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to extract records from databases that do NOT contain a given text value.
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 46th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create scroll bars that will control a percentage in a cell.
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 15th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to use a pivot table with grouping and a count function to create a frequency distribution.
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.
The hip and thigh stretch works on the mobility of the hip joint. Learn how to do the hip and thigh stretch with a partner in this fitness tutorial. When performing this stretch with a partner you should bend leg up, put hands on shin & thigh, and press in, out. With this how to video you can perform the hip and thigh stretch with a partner more effectively.
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 ...
Less than a month after the worldwide launch of HoloLens 2, call center consultant BellSystem24 has already prepared an augmented reality solution for one of its clients.
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.
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.
