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 272nd installment in their series of digital spreadsheet magic tricks, you'll learn how to count unique records and duplicate records using the SUMPRODUCT, COUNTIF, COUNT, COUNTA, IF and SUM functions.
Want to get rid of tan lines, reduce your chances of developing skin cancer but, like, nevertheless maintain a totally bodacious tan? With the self-tanning solutions made available by modern chemistry, it can be done. Discover how a spray tan booth can fix tan lines with help from a professional skin care specialist in this free video on tan lines and skin care.
Electromagnets are super cool to experiment with. In this educational video, Science Bob teaches us about electromagnets - what they are and how to build one of your own. These magnets are are very powerful and make an extremely neat experiment for the science fair. Electromagnets are unique in the sense that they convert electricity into magnetism. Try this experiment with your kids for a unique science lesson.
Seeking relief from a cold? There's more to using a neti pot than just pouring a saline solution down your nasal cavity – or is there? Find out with this how-to, which presents a complete guide to properly using a neti pot to relieve nasal congestion. Breathe easy with this free video guide.
Want to get rid of unsightly bare spots in your front or backyard lawn? In this video tutorial, home improvement expert Danny Lipford shows you three different solutions for fixing small dead spots of grass in your yard. For more information, and to get started reviving your own lawn, watch this helpful landscaper's guide.
If you're having trouble with your toilet, your first instinct might be to call the plumber. But many plumbing problems are easy to diagnose and solve yourself.
In repairing the dash pad, once you remove the dash pad it rips the metal clip off, where it is connected to the car. You can do this by using a j-b weld solution. After you mix the j-b weld, apply it to the broken stub and place the metal clip, with the ripped plastic, correctly on top of the j-b weld. Then wait until it dries.
Love free streaming music but hate the annoying ads that come with it? There might just be a solution to that. Use this video to learn how to remove the ads from Spotify. Just follow along and set the Proxy to the following:
This video tutorial offers advice and demonstrations on writing left handed for parents and teachers of left handed children. This comprehensive, educational left-handed writing guide covers the challenges for left-handers, writing problems, writing solutions, and helpful equipment. Check out this video teaching tutorial and learn how to make writing left-handed easier for the south paws in your life.
The Oregon Department of Transportation shows you how to install cable style tire chains in this video tutorial for the winter. These are tips and techniques for cable chain installation and removal from your auto's tires. The winter is here, and driving safely means protecting yourself against the snow and ice. Tire chains on your automobile is the perfect solution.
Find out a new way to solve the Rubik's Cube made famous by Erno Rubik, master puzzle maker. Try to get the OLL (Orientation of the Last Layer) using a new method that lets you look at the cube and figure out a two algorithm move solution to orienting them correctly. Just watch this video tutorial to see how to solve a Rubik's Cube with the Compound OLL method.
Lovely easy MAGIC with solution! Try it!! All you need is a match and some saliva. Be discreet about applying the saliva & impress your friends by balancing it on its head. Fun & easy bar trick.
Learning how to lucid dream—that is, to be aware during your dreams that you are, indeed, dreaming—will allow you to live out fantasies, stop nightmares, and even road test some solutions to real life problems. You will need a dream journal and an alarm clock.
How to use a banana skin to buffer up and clean your shoes!! Use the oils from the fruit to buff your loafers. This is a quick, easy and economical solution or replacement for shoe polish. Plus you get a great snack to eat in the meantime.
If you have a blocked sink, there are multiple solutions. This video tutorial will see to it that you find the right fix for your clog. For more information, as well as to get started unblocking your own sink, watch this helpful plumbing tutorial.
Microsoft and the Game Creators have joined forces to bring you a complete and free gamemaking solution. This video will show you what you need to download and install to get up and running fast. For more on how you can get started with the Game Creators Dark Game Development Kit, or GDK, take a look!
In this cooking how-to video Chef Mario shows you a new way to prepare shrimp with citrus. Follow along with this cooking lesson and learn how to make shrimp ceviche. This is dish that requires the shrimp or any other seafood to sit in an acid solution (such as lemon or limes) over night allowing it to cook the raw meat. Watch how easy it is to make shrimp ceviche.
Many flash movie players will disallow content to be shown to you if they determine that you're not in the correct region. This video tutorial presents a simple solution. (NB: While this works for the time being, it won't work forever, and so you'd be well served to take advantage of this while you can.)
Leather seats are expensive. Keep them looking that way with a little cleaning and conditioning. You will need a hand-held vacuum (or one with an attachment nozzle), a bottle of leather cleaning solution, a soft, dry sponge, clean, dry cloths, a spray bottle of water, a bottle of leather conditioner with sunscreen, lemon juice, and cream of tartar. Watch this video car care tutorial and learn how to clean the leather seats in a car.
Microsoft Office Live Meeting is a conferencing solution for online meetings, training, and events. Learn how you can schedule, join, or present a Live Meeting using features like audio, video conferencing, and uploading handouts. In this demo, learn about meeting permissions and how to record a meeting. Get an overview of meeting content options, see examples of meeting interactions, meet Microsoft RoundTable and really learn to use Office Live Meeting.
Microsoft Office Live Meeting is a conferencing solution that you can use to engage audiences in online meetings, training, and events. Learn how you can schedule, join, or present a Live Meeting by using new features such as audio, video conferencing, uploading handouts for distribution, and using Microsoft RoundTable.
Office Live Meeting is a conferencing solution that you can use to engage audiences in online meetings, training, and events. Learn how you can schedule, join, or present a Live Meeting by using new features such as audio, video conferencing, uploading handouts, and using Microsoft RoundTable. Watch the demo to learn how to schedule a meeting in Office Live Meeting.
Watch this instructional dog video on how to groom your poodle for show days. Mix a shampoo and water solution. Use a cleaning shampoo and a reconstructive shampoo. Follow these grooming guidelines to give your poodle a fashionable look.
Danny Lipford talks with Joe Truini about a simple solution to storing objects on your pegboard which may not be suited to using typical pegboard hooks. Keep your workspace organized with these easy to install pegboard shelves.
Here is the famous cold soup of Spain and the solution for that overflow of tomatoes in your garden. Watch this how to video as Chef Jim shows you how to make a healthy chunky gazpacho. Gather some onions, garlic, olive oil, red wine vinegar, tomatoes, bell peppers, cilantro, cucumbers and tomato paste for this delicious gazpacho recipe.
Watch this instructional cello playing video to learn how to space your fingers evenly on the cello for the beginners. The second and third fingers tend to be too close together but the Spock sign usually ameliorates this. The tutorial also offers effective alternative solutions to help the finger spacing. This is a great video for beginning cello performers and enthusiasts.
Keeping R/C vehicle clean is essential. Chris Chianelli shows you how to make your own RC cleaner so you can save a few bucks. You will need and empty spray bottle, denatured alcohol, Simple Green, and WD40.
Inside mount Roman shades are easy to install and can be the perfect solution to bare windows. In this short tutorial you will learn how to install inside mount Roman shades in your home. Watch this video and you can dress your windows with inside mount Roman shades in no time.
Horizontal Blinds are easy to install and can be the perfect solution to bare windows. In this short tutorial you will learn how to install horizontal blinds in your home. Watch this video and you can dress your windows with horizontal blinds in no time.
Bill Myers shows you a quick solution to the media offline problem in Sony Vegas and Sony Movie Studio.
This tutorial Korean cooking video will show you how to make your very own Korean vegetable pancake. This is a great solution for dealing with the left over veggies in your fridge.
Crock pot recipes are a great solution to your next potluck or tailgate. These baked beans are sure to be a hit with your family. The ingredients are baked beans, bacon, ground meat, tomato, brown sugar, and sea salt. Learn how to prepare this bacon and ground meat baked beans recipe by watching this video cooking tutorial.
Bed sheets can be a good solution for some household dilemmas. Watch this video tutorial to learn how to use bed sheets as a bed skirt, a Duvet cover, a sling or as a furniture cover.
Check out this video tutorial on how to use Omni Lights in 3ds Max. You'll learn how to make the light dimmer and create shadows in your 3D animation.
Clean your silver furniture, appliances and accessories to bring back the shine. Watch this HomeServe video tutorial on how to clean and polish silver in five minutes. This silver cleaning solution can be used for cutlery, jewelry and more.
Watch this 3ds Max video for an introduction to a complete series of tutorials for modeling and texturing a human head sponsored by Ego Farms. This is the very start of learning how to use this digital animating software. You'll also get insight on Adobe Photoshop, since you'll be working with that, too.
Breath some life into your animated scene by watching this 3ds Max video tutorial to see how to use keyframes for basic digital character animation modeling.
Watch this 3ds Max video tutorial to see how to get an object to follow a path with constraints to get procedurally control over your object with those constraints. Perfect for you digital animators/modelers.
Get the finest level of control over your animation with the curve editor. Just check out this 3ds Max video tutorial on how to do low level animating.
Hey all you 3D digital animators out there, check out this 3ds Max video tutorial on how to precisely align the texture/image on your object using projection UV coordinates.
