Methods Search Results

How To: Use the SUMPRODUCT function in Microsoft Excel

Are you looking for a way to make your Microsoft Excel formulas more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the very first installment in his "Excel Formula Efficiency" series, you'll learn about the basics of Excel's SUMPRODUCT function — why some people use double negative and why other use times one.

How To: Get rid of screen flickering for Java game development

In this 14th video in a series about JAVA game development, "thenewboston" (Bucky Roberts) explains how to redefine your screen to avoid annoying flickering. Flickering in JAVA games often occurs because of time lags as the viewer watches the computer draw a new screen, pixel by pixel. Pre-installed code in JAVA can be used to eliminate this problem by taking advantage of "Buffering" and "Page Flipping". These functions permit you to delay the composition of a new screen until it is finished,...

How To: Lower your high blood pressure naturally

Lowering your blood pressure can have many positive effects on your health. Follow Dr. Matthew as he takes you through steps to lower your blood pressure through natural methods. The first place to start is by managing emotional factors such as life stress. These stressors can set the sympathetic system in motion raising your blood pressure. Deep belly breathing can decrease your blood pressure. These require taking deep breaths, taking in a lung full of oxygen, holding it, and then releasing...

How To: Get yourself out of thumbcuffs

Daniel Martin, a magician and escape artist, explains his technique for getting out of thumbcuffs. Disclaimer: We're pretty sure it's not illegal to know HOW to escape from thumbcuffs... but we're 100% sure it's illegal to actually escape when detained by law enforcement (just sayin').

How To: Rescue someone in the water as a Boy Scout

Second Class Boy Scouts work on building their outdoor survival and camping skills. Compass work, nature observation, camp tools, and swimming are areas where new skills are mastered and demonstrated. A second class scout, having completed all the requirements, should be able to lead a hike, care for his own equipment, set up a campsite, and perform basic first aid.

How to Train Your Python: Part 3, Basic String Manipulation

Last time in how to train you python, we covered the basics of variables and output. While we were covering variables, we talked briefly about strings. "String" is just a fancier way of saying "Word". A string is simply a set of characters encased in quotations, this lets python know that it is a word. Sometimes when we do things with strings we'll need to change them in order to do something. Python is case sensitive, for example "Null-Byte" is not the same as "null-byte". This is where mani...

How To: Move files to and from an Apple iPad

The iPad has many apps that can be used to create and view documents and those documents can be moved to and from the iPad using several different methods. This free video tutorial from MacMost presents an overview of a great number of those methods. For specifics, and to start moving files to and from your Apple iPad with ease, watch this free video guide.

How To: Use the ratio formula to find coordinates of a point

This video is recorded in a mathematics class room. It is very clear by the sound and picture. The faculty here is explaining that the ratio between two numbers can be found using various formulae and methods. For example, 3:1 is the ratio between p and q. Likewise he explained the other formulae and methods.

How To: Fake a Loch Ness photo

This video will show you some methods to create a fake Loch Ness monster photo. You will need a camera or a camera phone for this project. One method of faking a sea monster picture involves creating a clay model of a head and a neck of a sea monster and holding it underwater. The outline of your hand holding the clay will serve as the body of the monster. Another method which can be used to fake a sea monster can be done using a clothes hanger and holding it underwater. The hook of the hange...

How To: Create the illusion of 3D shapes in Flash

Want to create 3D shapes in flash easily, without doing any real 3D modeling work? Watch this video and learn a few basics. An Adobe Flash tutorial video that is essentially divided into three sections. The 1st section teaches how to create a rounded filled circle with spherical effect and depth. The second part teaches the same thing with rectangular objects while the third teaches how to create a cylindrical effect using a rectangle. The obvious uses of these methods is to create your own 3...

How To: Change eye color using Photoshop

This seven minute and three second how-to YouTube video, uploaded by user ranash19195, instructs it's audience to 'Change eye color in Photoshop'. There are two methods that are taught: using a hue/saturation mask or a color change mask. The instructor uses clear and concise language to teach both methods. He takes you on a step by step visual and auditory journey and makes learning to change eye colors (retouching photos) both exciting and extremely easy to accomplish.

How To: Cook broccoli

Yes, we know cooking broccoli is a pretty basic skill and you probably know one way to do it already, but let us ask you: Do you actually ENJOY eating that broccoli? If not, then it's prime time to give some new cooking methods a try. Mentioned in this food tutorial are several methods for heating up this cruciferous vegetable, including adding water to it (steaming), putting it on the stovetop, and even throwing it in the microwave.

How To: Grow tomatoes upside down in a bucket

Interested in less-conventional container gardening methods? Say, growing tomatoes upside-down in a bucket? This video will show you how it's done! It's easy. So easy, in fact, that this clip can present a complete overview of the process in about 7 minutes' time. For more information, including detailed, step-by-step instructions, take a look.

How To: Do a long-tail cast on when knitting

The long-tail cast on is one of the most common methods for casting on stitches. It is stable, neat and easy — once you get the hang of it. This knitter's guide walks you through the entire process. For detailed, step-by-step instructions, and to get started using the long-tail casting method yourself, watch this free video knitting lesson.

How To: Calculate a bonus in Microsoft Excel

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 24th installment in their joint series of digital spreadsheet magic tricks, you'll learn 5 different methods for calculating a bonus using VLOOKUP, MAX, Boolean, and 2 IF formulas.

How To: Use wildcard counts in Microsoft Excel

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 3rd installment in their joint series of digital spreadsheet magic tricks, you'll see three methods to count records that contain the letter D.

How To: Convert TRUE & FALSE values to 1 & 0 in MS Excel

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 314th installment in their series of digital spreadsheet magic tricks, you'll learn four different methods for converting TRUE and FALSE values to 1 and 0 (zeroes).

How To: Clean a Curling Iron

It’s inevitable – the sticky, messy buildup accumulating on your curling iron. Use any of the methods in this how-to video to de-gunk and get on with the business of beautifying. Your curling iron will work better, last longer, and make your hair look nicer when the curling iron is clean and in good condition. Check out this video and learn how to keep your curling iron and hair in styling shape.

How To: Clicker train your dog to take a bow

Clicker training tutorial on teaching your dog to take a bow. This tutorial utilizes BF Skinner's methods of operant conditioning. This will create a well regulated training schedule between you and your dog or other pet. Operant conditioning is great to get an animal to do bizarre tricks.

How To: Hack Windows shares

In this installment from the Unorthodox Hacking series of computer security tutorials, you'll learn a number of methods for hacking Windows shares as well as means of mitigating those hacks. For detailed instructions on Windows shares, and what you can do with them, watch this helpful video guide.