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 198th installment in their series of digital spreadsheet magic tricks, you'll learn three different methods for counting quantitative data in categories that include a lower limit but not an upper limit.
In this video tutorial, viewers learn how to make a crossover cable from scratch. Users will need an Ethernet cable. Begin by removing one side of the connector and strip off the outside casing. Then separate the wires. Change the sequence order of the cables to: white green, green, white orange, blue, white blue, orange, white brown and brown. Make the cables straight and close together. Then cut off about half of the wires and carefully put back on the connector. Use pliers to squeeze the c...
This video explores how to get the limit by getting a common denominator. When you try and plug in a limit, for example when the denominator goes to zero, you can get yourself into a situation where you get the answer (0/0) which is mathematically irrelevant. To solve this problem, you must find a common denominator and split the problem up into its various parts. By setting common denominators in the numerator, you can then flip the fraction around allowing you to properly calculate the limi...
This video explains how to adjust a rear derailleur using the limit screws in a bicycle. There is a limit screw which has low and high gear. When the limit screw is turned in, the pulley moves inboard and when turned out, it moves the other way. The derailleur moves along with the inboard. When turned in, it travels with the inboard and holds the chain. Care should be taken not to turn much deeper as the derailleur might throw the chain off. The viewer will get some useful information upon wa...
Central limit theorum is easily one of the most fundamental and profound concepts in statistics and perhaps in mathematics as a whole. In probability theory, the central limit theorum (CLT) states conditions under which the mean of a suffiently large number of independent random large variables (each with finite means and variance) will be normally distributed, approximately. Huh? If you are having trouble understanding central limit theorum and need help trying to solve it, check out this tu...
Get a crash course on HScript Expressions, Variables, and Attributes in Houdini 10. If you don't even know what this means, then you probably need to check this video tutorial series out. Understanding how to massage data in Houdini is key to giving yourself the creative edge and allowing you to unleash mind-blowing visual effects. This 18-part video series covers a variety of simple yet essential weapons in your arsenal including Global, Standard and Custom Variables to Math and String Modif...
In this video tutorial, Creative Cow leader Michael Park shows you how to recreate the opening gun barrel sequence from the two newest James Bond movies in 3d Studio Max using the default scanline renderer, minimal modeling, and only standard materials.
See how to build a weatherproof compact high gain WiFi antenna for under fifteen dollars! This homemade WiFi antenna should be enough for most applications, since it's three times more powerful than a standard antenna.
Aspirin masks are not something new, but many people are not aware of this amazing mask and the potential it has for clearing you skin!
Find out how everything in a chemistry lab works, from pipettes to burners to recrystallization to storage. You'll get precise instructions on how to work and perform certain scientific duties in the chem lab, whether it's chemical or just ordinary high school science.
Finnish is an unusual language, which can make it tricky for foreigners to learn. Instead of relying on a book, the Learn Finnish video language-learning tutorial series shows a photograph of a vocabulary term while pronouncing the word in Finnish. This technique allows the student to associate the object itself, rather than the term in their native tongue, will the Finnish word, thus allowing for maximum comprehension and absorption. In this video segment, numbers, or "numerot" in Finnish, f...
Finnish is an unusual language, which can make it tricky for foreigners to learn. Instead of relying on a book, the Learn Finnish video language-learning tutorial series shows a photograph of a vocabulary term while pronouncing the word in Finnish. This technique allows the student to associate the object itself, rather than the term in their native tongue, will the Finnish word, thus allowing for maximum comprehension and absorption. In this video segment, numbers, or "numerot" in Finnish, f...
Finnish is an unusual language, which can make it tricky for foreigners to learn. Instead of relying on a book, the Learn Finnish video language-learning tutorial series shows a photograph of a vocabulary term while pronouncing the word in Finnish. This technique allows the student to associate the object itself, rather than the term in their native tongue, will the Finnish word, thus allowing for maximum comprehension and absorption. In this video segment, the vowels, "vokaalit" in Finnish, ...
The mime materia is easily one of the best materias in Final Fantasy VII on the original Playstation. Take a look at this instructional video and learn how to use your mime materia to reuse your limit breakers without needing the limit gauge to fill up. With this trick you can easily take on Ruby and Emerald Weapons.
Here are some tips for playing No Limit Hold'em poker after the turn. Many of the turn cards in No Limit are the last card you are going to see. By this time, you usually have a good feel about your status.
The first thing anybody really thinks about after watching Rear Window is how much they want their own telephoto lens. These days, they aren't cheap, so how do you go about spying on your neighbors without putting down so much dough?
In this video tutorial, we learn how to shoot video in pitch-black conditions using a standard digital video camera. For more information, including a complete demonstration and detailed, step-by-step instructions, watch this how-to from the folks at CNET TV.
In this video tutorial, we learn a trick for speeding up a standard Logitech Harmony smart remote control. For more information, including a complete overview and detailed, step-by-step instructions, watch this home-theatre how-to guide from the folks at CNET.
In this tutorial, we learn how to play video clips from the Internet on a standard TV screen. For a complete demonstration of the process and detailed, step-by-step instructions, watch this handy home-theatre how-to from the folks at CNET.
When you think of burgers you probably picture a bun topped with a beef patty, ketchup, mayo, lettuce, and a slice of tomato, but there are so many different types of burger toppings you can try that you've probably never thought of!
In this video, you'll learn how to sew up a decorative tissue box cover for your standard tissue box. Add some decorative flair to your home. This video will walk you through each step of the way. Pretty soon you'll have a nice and artsy tissue box cover to show off to your family and friends.
Aspiring card shark? Sink your teeth into this simple illusion. In this free video magic lesson from YouTube user experthowto, you'll learn how to perform the "slip force" card trick to force aces or any other card from a standard deck of playing cards. For more information, including a step-by-step breakdown of the trick, watch this prestidigitator's guide.
Got a deck of standard playing cards? Looking for your next great illusion? Look no further. In this free video magic lesson from YouTube user experthowto, you'll learn how to perform the classic "million dollar" card trick. For more information, including a step-by-step breakdown of the trick, watch this prestidigitator's guide.
Got a deck of standard playing cards? Looking for your next great illusion? Look no further. In this free video magic lesson from YouTube user experthowto, you'll learn how to perform the "million dollar" card trick. For more information, including a step-by-step breakdown of the illusion, and to learn why a good card trick is like money in the bank, watch this prestidigitator's guide.
Graffiti maestro Wizard performs one of his trademark user-requested graffiti demonstrations. In this video creates an even more compact design than usual, creating the word UZI in fairly standard graffiti-script and elaborating it with some splatter patterns and a hatted figure popping out from the corner. His speed and technique, especially working without a pre-drawing, are simply remarkable.
This software tutorial shows you how to create cartoony blood effects in After Effects CS3. This isn't going to be realistic looking blood, but if you want to learn how to create a blood or fluid effect using standard After Effects tools and the CC Mr Mercury filter.
If you're new to the Mac OS X operating system, one of the first things you might like to do is set up an email client. In this how-to, Gary Rosenzweig looks at how to set up the Apple Mail application to receive and send email from a standard ISP email account.
This wavy shell crochet pattern uses three colors to make the design look complex and random. Actually it's quite simple. There are only two rows in this wavy shell crochet pattern. One row alternates between a few standard stitches and half pinwheel shape. The second row is completely plain. Try out this crochet project to achieve satisfying results.
This how-to video is an easy guide to essential kitchen knives every home cook needs. Chop, slice, pare and carve through any meat or veggie with the proper knife. Learn about carving, boning, pairing, steak, cake, serrated knives and a standard chef's knife. Find the one that's perfect for your needs.
This video origami tutorial shows how to fold and snip an advanced paper airplane: the JKF-168 jetplane. Be the envy of all your class or office mates who are stuck folding their standard issue paper airplanes. Learn how to craft the JKF-168 jetplane paper airplane by watching this instructional video.
Do you even know what the F key does? or what it stands for? We'll give you a hint - it helps you toggle between the different screen modes like full screen, standard screen, and maximized screen. So check out this Photoshop tutorial and see how to use the F shortcut key.
Learn how you can read the Arabic language with this how to video. Follow this language tutorial and you will be able to read modern standard Arabic script in no time at all.
In this carpentry / woodworking video, Bob Schmidt shows you how to redrill an old doorknob hole to fit standard new doorknob using basic boring bits on your home remodeling project.
From Prime It Up and for the beginning painter, an end to end tutorial about painting a 40K Ork to a tabletop standard. This video covers how to base your figure.
From Prime It Up and for the beginning painter, an end to end tutorial about painting a 40K Ork to a tabletop standard. This tutorial warhammer video covers how to paint the leather on the ork.
Blue tape works on standard windows, but when you've got six panes of glass in one window, using blue tape would be a pain. This video shows you how to use cardboard to paint the window. Makes it easy.
This free drum lesson features broken sixteenth note fills that work well within rock music. They are perfect for intermediate drummers that are looking for patterns that are a little more challenging than the standard sixteenth note fills.
This video describes how to do a different rhythm to the standard split stroke for the banjo uke. Some people pick this up naturally, other need it to be pointed out-like the demonstrator, for example!
The Glo Bug Yarn Egg. Tie it. Then it's hook, line, and sinker. This pattern is a standard for steelhead, salmon, and trout
Watch this quick screencast, to learn how to easily set your system to revert to the Classic Start Menu in Windows XP.