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 582nd installment in their series of digital spreadsheet magic tricks, you'll learn how to understand and fix the nine most common formula errors in Microsoft Excel. Specifically, you'll learn how to interpret and resolve #######, #NAME?, #N/A, #REF!, #VALUE!, #NUM!, #DIV/0!, Circular Cell Reference, and #NULL! errors.
The University of Michigan teaches you how to use nasal irrigation to get rid of common nasal sinus symptoms without reaching for those over the counter medications. The best part of nasal irrigation is that it handles conditions that medication cannot - such as post nasal drip and the common "stuffy nose". This can work for most allergies, even if you are already on medication. Water used for nasal irrigation should be luke warm and should contain about a quarter teaspoon of salt into an 8 o...
This video illustrate us how to make a hovercraft with common household items. To build one, first of all, collect all of the items required for making it. You need a CD, bottle cap, balloon and super glue. Then start by applying glue to the lower end of the cap and sticking it to the center of the CD and let it dry. After it has dried, blow up the balloon and secure it up on the bottle cap tightly. Now open the bottle cap and let the balloon deflate.
Back pain is a common discomfort that women experience during and after pregnancy. Though a short, effective standing and seated series, this yoga how to video concentrates on alleviating some of these common aches and pains. Side bending poses help release lower back pain by stretching the latissimus dorsi (lower back) muscles. Forward bend and hip openers release and extend the lower back, hip and hamstring muscles. Twisting poses help stretch and release the back and shoulder muscles, crea...
This video tutorial is in the Education category which will show you how to subtract basic fractions in simple mathematics. You can do basic subtraction of fractions if the denominators are the same. If they are not, then find the lowest common multiple of the denominators and convert the denominators to their lowest common multiple. For example, to subtract 1/2 from 3/4 find the common multiple of 2 and 4, which is 4. So, the problem 3/4 - 1/2 can now be written as 3/4 - 2/4. Since, the deno...
In this tutorial, we learn how to identify common knitting abbreviations. A yfwd is also known as a yarn forward. An sl 1 is also known as a slip 1 and a k1 is also known as a knit 1. A psso is a pass slipped stitch over and a k2tog is known as a knit 2 together. These are common abbreviations in knitting patterns, when you learn these you will be able to knit more quickly when you are reading a pattern that is written on text. After this, you can make any creation you want and read the direc...
Want to know how to fix common Microsoft Windows 7 registry errors? This clip will introduce you to an application which makes the task a simple one. For details, including step-by-step information on where to download and install said app, watch this video guide.
Need help figuring out how to find the greatest common factor and/or the least common multiple of two given numbers? Learn how with this free video lesson. From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just finish your homework or study for that next big test).
Learning proper American English usage is a challenge, but fortunately this video is here to explain the usage of one common phrase to the non-native English learner. That phrase, one near and dear to the hearts of Americans, is "go shopping". This simple instructional video point out common mistakes that English learners make and shows how to use the phrase correctly in context.
In this video the tutor shows how to add fractions. Fractions are numbers in the form a/b, where a and b are normal numbers. He shows that to add two fraction we need their denominators to be same. If they are not same we need to take their least common multiple and change the fractions so that they have equal denominators. Now the numerators of these fractions can be directly added and the resultant fraction contains this numerator along with the original common denominator. Now this fractio...
The Microsoft HoloLens has a fairly passionate, yet relatively small group of users pushing the developer-centric device forward, mostly spreading the word about the device through word of mouth and meetups. But this weekend, during the annual NBA All-Star festivities, we got a look at how Microsoft may be planning to market the device if it ever goes truly mainstream.
If you've started bending your 3D animated character around in Autodesk Maya 8.5 and came across a broken bone sticking out that needs to pivot, then you've got a huge weighting issue. Check out this three-part video tutorial on how to correctly weight objects down in Maya. So, learn how to fix weighting problems by watching this how-to video.
In this video, we learn how to use secure online passwords. There are a ton of things to consider when creating a password. A weak password is something that someone can easily guess. If you are using a birthday, common dictionary word, child's name, or something common then you are at risk. Your password should combine letters and numbers, and be at least eight characters long. It should also be completely random and have upper and lower case letters. You can use a password assistant if you ...
Dead lifts have a great corrective capacity when done properly.The dead lifts can be done just by picking weights off the floor or in a smart and meticulous way.When doing dead lifts there is a lot of rotation in the upper arm,and many people or athletes are not doing the dead lifts properly.When you do an external rotation you automatically force extension and that can put you in a great anatomical position for dead lifts.The exercise itself is simple,you have an iron bar,lift it,draw the sh...
In this video, we learn how to identify common tree problems. If you use too much fertilizer you can find a burn scar that is left on the bark of the tree. You can avoid this by making sure fertilizer spikes are placed away from the tree. Tree splitting is also an obvious sign that a tree is in bad shape and needs to be cut and taken down. A common leaf problem is Pear Slug Damage. A great way to help this to use wood ash on the tree, which will kill the insects that cause this and it's safe ...
The above video is very informative to anyone who does not know the division of fractions. The author very neatly explains the meaning of a common divisor i.e. it is a number that divides two numbers evenly. Therefore, one must divide a fraction as many times until the remaining fraction has 1 as a divisor. It is very easy to find the common divisor. Both the numerator and the denominator must be divisible by that number. The author in the present video has done a good work.
Do you know how coiling effects golf swing? Swaying too far off the ball in the backswing and downswing is one of the most common power leaks in golf. Use five-time, Re/Max World Long Drive Champ, Jason Zuback's method for creating power through a proper coil and gain yards now. See how to create power in your golf swing with a proper coil.
Asking someone out on a date can be very intimidating, especially if you do not know them that well or if they are a complete stranger. This guide helps you learn how to confidently ask a stranger out on a date by introducing yourself, finding common ground, learning about the stranger, and then asking them out. Sometime's asking someone out is as easy as initiating a conversation.
This is a video tutorial on how to replace a damaged iphone 3GS home button/flex cable. It seems to be common for Apple's iPhone home button to get stuck, so replacing it without paying a fortune is a valuable skill.
You can easily make an inexpensive silicone mold in your kitchen for cheap! This is a great project to do with your kids, or just for fun! You can also use this method to easily make theatrical props and prosthetics.
The Mitsubishi Endeavor, like most vehicles, has it's own list of common problems. One of them is the back door locks not working. Watch this video for a guide to diagnosing your door opening problem and, hopefully, fixing it successfully.
If you recently unearthed your silver from storage hoping to use the pieces to set your holiday table, you may have been a bit disappointed at how tarnished all those spoons and forks look.
The phase-shift oscillator is one of the most common electronic parts, used in all sorts of mostly noise-making devices. If you like electrical engineering and new a new project, watch this video to learn how to make a phase-shift oscillator out of a single transistor, resistors, and capacitors.
For most synth players the goal is to acquire legendary pieces of 1980's gear with great amounts of money or luck. Why bother when you can make your own direct digital synthesizer (DDS) at home? Watch this video to learn how to make a DDS out of common electrical parts that will make a phat Theramin sound.
Electroluminescent (EL) materials light up when electricity passes through them, as opposed to more common incandescent lights that respond to heat. EL displays are becoming very popular in advertising and art,but getting them or the materials to make them can be expensive. Watch this video to learn how to turn an LCD into a simple EL display, and also how superglue can be used as a cheap dielectric in this sort of project.
Podcasting is a great way of doing your own form of radio broadcasting, among other forms of other recorded media from the comfort of your own home! But, you don't need to have an iPod to do it or listen to it (a common myth). In this video you will learn what a podcast is, how to create one, publish it and then get subscribers!
If you've got oil leaking into the spark plug wells on your Honda Accord, you're not alone. This a pretty common problem, and fortunately for you this video is here to show you how to fix it, assuming you're decent at auto maintenance already. Make sure you line everything up when you reinstall the rock assembly!
One of the most common problems that vacuum cleaners can have is the belt that drives their brush. They are actually pretty cheap and easy to fix yourself, and this video will show you everything you need to know to remove the old belt and install the new one quickly and easily.
Google is one of the most powerful forces on the Internet, and their technology can be the key to helping you find success in whatever your online endeavor might be, from web design to filmmaking. This video is a part of their Google Webmaster Series, offering help to webmasters the world over on how to best utilize Google in their work. This video will show you how to ensure that your Wordpress blog is safe from the hacker attacks that are so common for Wordpress users.
CCTV's (closed-circuit televisions) are more common than ever before, and have become more and more popular to depict in films and in video games like Manhunt. This video will teach you how to create a CCTV monitor effect akin to what a security guard would see on their camera monitor using After Effects. This will work great for any horror movie that you might be shooting, the effect is very creepy.
When you're a vegan, meals must be pre-planned in order to ensure you're not using animal products of any kind. Make your next cookie recipe a little bit easier by learning what sorts of things you can use to substitute eggs.
Shin splints are one of the most common, stubborn, and misunderstood injuries affecting athletes of every age, gender, and sport. This video features a doctor explaining what exactly a shin splint is as well as how to prevent, diagnose, and treat them properly. It turns out that shin splints are actually menial tibial stress syndrome, or MTSS. Try saying that five times fast.
Buttermilk is a great thing to have around in your kitchen. Unfortunately, most of us don't have buttermilk on our regular grocery list, so those buttermilk pancakes will have to wait for another day. Think again! You can easily make tasty buttermilk alternatives with common refridgerator items. This video will show three easy ways to make a buttermilk substitute.
In this video, Derrick Schommer, sales engineer, podcaster and host of Common Man Cocktails shows viewers how to mix up a Blue Mediterranean. This classy gin cocktail is based on Bombay Sapphire gin, teamed with lemon-and-lime Sprite and Blue Curacao for a sophisticated, slightly sweet drink. The Blue Curacao and gin are placed in a high-ball glass with ice, then the drink is topped off with Sprite and a squeeze of fresh lemon juice.
Systm is the Do It Yourself show designed for the common geek who wants to quickly and easily learn how to dive into the latest and hottest tech projects. We will help you avoid pitfalls and get your project up and running fast.
Systm is the Do It Yourself show designed for the common geek who wants to quickly and easily learn how to dive into the latest and hottest tech projects. We will help you avoid pitfalls and get your project up and running fast.
New to soldering? This how-to video answers the questions for these common beginner soldering questions: what is flux? what tip should be used? do solder fumes contain dangerous amounts of lead? why regularly clean and tin the iron tip? Watch this video computer-circuitry tutorial and learn how to solder correctly.
Datong Xu currently teaches Chinese calligraphy and painting in Tucson, AZ. Watch this instructional painting video to paint the symbol of eternity in Chinese calligraphy. The eternity character also means, "flowing water". In Chinese art aesthetics, calligraphy and painting are of common origin.
Learn about the basics of weaving with this stop motion weaving tutorial video. Several different weaving and knot techniques are demonstrated, even showing common mistakes in the weaving process. Watch and learn a simple technique for weaving on a cardboard loom.
You can add keywords as metadata to your images to enable you to search images by common characteristics or subject matter and to keep your library organized.
