Every dollar that comes your way is a blessing, especially when it comes to trading in the volatile world of bitcoins. Thankfully, Coinbase rewards you for sending much valued customers their way, giving you more money to feed your cryptocurrency trading needs.
In this Excel basic video the instructor shows how to setup a spreadsheet and use cell references. Cell references are used in Excel to refer to other cells in a formula. When a formula contains data based on the cell reference the formula auto generates the result each time the value in the cell changes as the formula contains only the reference to the cell and not the actual data present in it. In this video the tutor goes on and shows how to write a few basic formulas using cell references...
Excel is a powerful tool, but sometimes you need a guide to navigate its possibilities. This clip shows the difference between absolute and relative cell references so that any given formula, when copied, gives the results you want. Sometimes you will want to refer to the same cell, even when you are copying a formula to a different place on the worksheet. Other times, you will want the items in the formula to change as you copy them across the columns. You will see how such actions work thro...
You can feel it in your bones. You may die if you don't get this phone. There's just one problem — the price. Suddenly, you come across what seems like manna from heaven. That very device, at a deeply discounted rate, can be yours.
If you are an optometry or opthalmology student, this is the perfect how-to video for you. Watch these these seven videos and learn how to test a patients vision with a refracting machine using plus lenses. It’s a little difficult to describe the controls used for refracting because every instrument is set up differently. If possible, refer to a manual for the specific refracting instrument that you’ll be using. This vision tutorial will walk you through all the parts of a optical refracting ...
If you are an optometry or opthalmology student, this is the perfect how-to video for you. Watch these these seven videos and learn how to test a patients vision with a refracting machine. It’s a little difficult to describe the controls used for refracting because every instrument is set up differently. If possible, refer to a manual for the specific refracting instrument that you’ll be using. This vision tutorial will walk you through all the parts of a optical refracting instrument, sphere...
Any medical student could benefit from this video lesson, whether you're training to be a doctor or a nurse. The very first step to finding out what's wrong with your patient is examining him/her for their vital signs. You must check the patient's pulse, respirations, blood pressure, and know how to use every kind of sphygmomanometer. To see the entire examination procedure, perfect for nursing students, watch the video to see how to examine a patient for vital signs, and refer to the steps b...
Most people refer to "long press" as "touch and hold", but no matter which way you say it, it's an awesome feature for Android cell phones. Long pressing lets you get more information, download photos from the web, edit pictures and more! Watch as Google teaches you about long pressing, a nifty feature that reveals additional functionality on your Android-powered phone.
Slideshow is such a dirty word. Most people immediately think of boring family reunions or 1980's corporate meetings when they hear it. That's probably why web designers prefer using the term image gallery to refer to their slideshow-like works. This video will teach you how to make an automatic image gallery using Flash CS4, which is a slideshow where the images advance automatically on a timer.
There are a lot of things out there in the design world that people have seen and liked, but didn't know how to make. LIke vector lights. Watch this Illustrator video tutorial to take a look at those cool glowing, color changing, fading, bright, neon-like, fanning spread of glowing colors. Maybe there's no specific name for them, but for now, refer to them as 3D Light Ribs. You can use these in photographs, illustrations, composites, print work, web design, and maybe even a logo or two! You w...
How to make TCPO or bis(2,4,6-trichlorophenyl) oxalate, used in glow stick reactions. WARNING: This procedure should only be performed by, or under the direct supervision of, an experienced chemist. Please refer to the material safety data sheets of all chemicals for their hazards. Synthesis must be performed in a fumehood.
First off, don't be frustrated. YOU CAN DO IT! Contrary to the message in the image above, it's NOT over. It's just beginning. And when it comes to solving the New York Times crossword puzzle, the old cliche does apply: practice makes perfect.
Someday, maybe not today, maybe not tomorrow, but someday, you'll find yourself on the road in your car, maybe on the highway, and you'll hear something.
Walk on water? Impossible. Walk on cornstarch? You bet! Check out this video to see what happens when you mix up a tub of cornstarch and water. It's goopy cool fun. Mix cornstarch and water in this classic experiment to form a gooey liquid and solid material that behaves like quicksand. Some people refer to this as the Oobleck recipe, others call it a Non-Newtonian fluid. After watching these video segments, you'll call it a great science lesson as your students learn about the amazing proper...
Consider this Beading 101. In this video, you'll learn the five basic beading terms used in many beading magazines and beading patterns. These terms refer to how you pass needles through your beeds (from the back or from the front), how you separate irregular beads out of your main beading inventory, rounds and rows (different ways of beading), waxing your thread, and thread tension.
As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 2nd installment in his "Beauty of Excel" series of free video lessons, you'll learn how to set up the input/assumption area for formulas so that subsequent formulas, functions and charts update beautifully. Learn how to build Excel spread...
Paul, an English teacher, gives a lesson on the difference between the word "live" as a verb and as an adjective. To make to "v" sound when saying the word, the lower lip has to touch the teeth. "Live" as verb is an action, so you say "I live in Minneapolis". The singular form is "live," and the plural form is "lives". Live" as an adjective is a describing word, so you say "Live TV is fun". "Live"" as an adjective describes the subject of a sentence. "Live" as an adjective can mean something ...
HTPC. It stands for Home Theater PC. Some refer to it as simply a Media Center. But no matter what you call it, you're going to learn how to build one today. Why would you want to do that? Because one of the main advantages of creating your own home theater system is that you are control, not only of the cost, but the features and functions, as well.
This video shows us how to build a garden bench out of cinder blocks. Before you get started, you need to refer to the How To sheet #320 for all your materials and make sure you have everything you need.
If you have never dealt with wire color-coding then Old64goat takes you through a very elementary tutorial that will give you the helpful aid needed to deal with common household wires. The first cord that is reviewed is the three pronged cord. The color wires contained within it is the green wire which is the ground prong, the white wire which is neutral, and the black wire which is the heat. Old64goat then demonstrates where the wires are connected to on the prong. He even gives out helpful...
Let us help you install your JVC Everio software and hook up your JVC HD Everio video camera to your computer. Just select your operating system.
Consider a normal and ideal height for a girl in 5feet 8inches in height. The book of Andrew Loomis is a good guide for drawing realistic human figures. It explains the body proportions, techniques, drawing the parts, human movements, and poses of the body.
Simon Solotko outlines the steps necessary to get a desktop PC up and running from scratch using AMD Dragon platform technology. Fragon technology is a combination of AMD Phenom II processors, ATI Radeon HD graphics and AMD 7-Series chipsets. This technology allows you to build incredibly powerful PCs for multimedia entertainment, gaming and advanced multitasking.
As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the very first installment in his "Beauty of Excel" series of free video lessons, you'll learn how to create a contribution margin income statement across various units sold.
This is a quick guide on how to use Vinyl/Fabric Spray to Custom Paint an Xbox 360 Controller. When people refer to vinyl dye they are referring to paint.
"Shamanism: Other Worlds" explores the ancient spiritual Amazonian enlightenment drug Ayahuasca. This documentary investigates Ayahuasca and its use largely as a religious sacrament. Those whose usage of ayahuasca is performed in non-traditional contexts often align themselves with the philosophies and cosmologies associated with ayahuasca shamanism, as practiced among indigenous peoples like the Urarina of Peruvian Amazonia. The religion Santo Daime uses it. While non-native users know of th...
Tying It All Together presents a video on the Etyszkiety knot, a decorative Polish knot worn by mounted brands. This knot also has connections to other cultures, where it is called the prosperity or the prolong knot.
Olla! In this lesson we will be learning how to tell the time in Spanish.
Let's build a SOLAR DEATH RAY!!!
Personal pronouns are used to refer to relationships between the speaker and the listener - such as 'I', 'me' and 'you.' This introductory lesson to German teaches you the personal pronouns used in German. You are also shown 'sein,' the German word for 'to be,' in the present tense.
If you're looking to add a little bit of heat to your words, this tutorial may be up your alley. Of course, words in this case refer to those you can type out on your computer. This great video shows you how to create an awesome looking fiery text using Photoshop. It's a little difficult but after watching this, you'll get it in no time. Enjoy!
Pete Sears guides you through different modes of playing the piano or keyboard. These refer to the step pattern intervals between the notes when playing a scale.
To replace a door, refer to Lowe's do-it-yourself for a step by step guide. Replacement is not very difficult. To replace just the door, tools and material required are: a new door, hammer, screw driver, tape measure, pencil, combination square, saw horses, clamps, chisel, a door lock installation kit, a drill with bits, circular saw, level, work gloves, dust mask, safety glasses, plane, shims, cardboard, and a utility knife. Before removing the old door, take a few measurements like the widt...
The Mad Hatter from Tim Burton's Alice in Wonderland not only makes a great costume but a great project. The hour-glass shaped hat, the striped pants, the fingerless gloves, and the Hatter's signature scarf are the most important components in this costume. If you're fairly skilled with costuming already, this shouldn't take more than four or so hours.
Fox hunting has become illegal is some parts of the world, but there are still places where fox hunting is an acceptable activity, where people ride on horseback, following foxhounds and other scent dogs on their hunt for foxes, most likely a red foxes.
This Halloween, forget store-bought prosthetics and expensive makeup artists. If you're looking for that creepy undead look, nasty nails are easily made at home. This video will show you how to make some horrific and ghastly fingernails for your zombie, vampire or other creature costume. The key to these Halloween nails are clear plastic report / presentation covers that you can get from any office supply store.
Nothing beats this delicious county ham when you're looking for a quick and easy 5 star recipe for the barbecue grill. The term "ham" generally refer to smoke cured pork butts(shoulder) and shanks. This is a ham butt, smoke cured and available most anywhere in the States. The additional smoke process on your grill or smoker makes it a 5 star premium ham fit for a kings table! In this how to video the BBQ Pit Boys show you step by step how to keep it moist and tender with a flavor that you can...
A reasonably in depth Talk & Walk around and eventual start up and run of my DIY Jet Turbine Go Kart. Please excuse my mistake when I stupidly say that Jet engines don't 'Squeeze' the air - of course they 'squeeze' the air !! The compressor wheel within the turbocharger see's to that! - What was I thinking of ?? Oh, AND the fact I refer to the OIL pump as a FUEL pump as well - what a chump. Also, the tacho didn't seem to want to work correctly, It wouldn't read over 5000RPM for some reason - ...
This video is about how to download torrent files. The first thing that you will have to do is to open your uTorrent. After opening your uTorrent, open your browser and browse torrent sites that suit you best. Once you have found the site that you like, search for torrent files that you are interested in. Once the results have been displayed, refer to the number of seeds since this increases the download speed. Once you have found the largest number of seeds, click on the title of the file. A...
It’s an evening of wining and dining and you want your meal to come out perfect. Whether a side dish or main course, please your crowd with pasta al dente.
