Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 56th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use an array formula and the COUNTIF function to count unique records that are greater than a given hurdle (in this case, $30). Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 52nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to have one workbook look into another workbook using a workbook reference. See also how to update workbook references. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 48th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the VLOOKUP, ISTEXT, ISBLANK, OR and IF functions in one formula to look up a time value. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
This video describes the process of split and cutting concrete blocks. For splitting concrete blocks, a hammer as well as a chisel are required. For cutting concrete blocks, you can either use a skill saw with a masonry blade or a masonry saw. Next, proper safety guidelines and equipment are discussed. For splitting masonry blocks, two types of blocks that are manufactured with splitting notches are shown. To split these blocks, they must be scored with the chisel along the entire length of t...
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...
In this Electronics video tutorial you will learn how to build and use a tinyCylon kit. The kit contains a battery pack, a PCB, LEDs, resistor, a momentary switch and a screw. The long end of the LEDs will go into the square shaped contacts. Don’t push the LEDs right up to the board. Instead, use some poster putty to hold the LEDs standing upright so that they can be bent later on. Fix all the LEDs in this manner and solder them on the other side. Then solder the leads of the battery pack. ...
In this video tutorial, viewers learn how to clean their shoes with a banana. The materials required are: a banana, dirty shoes and a soft cloth. Begin by peeling the banana. Users will only need the skin, so eat the banana. Rub the banana skin all around the dirty shoes. The natural oils of the banana will soak into the leather, helping the shoes to last longer. The banana skin also contains potassium, which is a key ingredient to commercial shoe polish. Then take a soft cloth and buff the s...
Fantastic Food with Scott Hargrove demonstrates how to carve a roasted chicken. First, use the appropriate knife. Make sure that your life isn't too large. Use a medium-sized carving knife. Use a carving board with a ridge to contain the juices. Place the chicken with the back bone down and breast up. Break the skin open on leg until you hear a crack. Take the point of the knife and run it along the crease where the bone meets the body to separate the leg. Repeat with the other leg. Next, car...
In this video, Extension Horticulturalist Curtis Smith talks with Master Gardener Marsha groves about controlling harmful pests that are damaging to plants throughout the year in both outdoor garden and greenhouse environments. The first part of the video covers the issue of plant eating snails, and how they might best be dealt with. Smith explains that there are a number of non-toxic methods which one can use to rid a plant of snails. The process of introducing predatory creatures such as tu...
This video explains how to build a home garden in a small space. The video begins with the first small garden example being show, this garden contains corn, tomatoes and summer squash. It is explained that it is very important to shake and loosen the pollen buds on many of the plants to ensure proper pollination. The second small garden shown consisted of tomatoes and various pepper breads. The need to loosen pollen and allow the wind to help the plants get on pollen on the female buds. It is...
In this video tutorial, viewers learn how to make a creamy chocolate oatmeal non-dairy milkshake. This shake has low fat, low calories and contains cholesterol. The ingredients are inexpensive. The ingredients required for this shake are: oatmeal, cocoa, banana and soy milk. Add all the ingredients into a blender and add 5-6 ice cubes. Then turn on the blender and blend it until the mixture is creamy and smooth. Users are also able to add in their own ingredients or substitute some of the ing...
Meter, specifically iambic pentameter, can be used to analyze a poem. Iambic pentameter is used in poetry and drama and describes a particular rhythm that words establish in each line. Rhythm is created through the stressing and un-stressing of syllables. Small groups of syllables are called feet. A foot is a group of two or three syllables and will often contain a stressed and an unstressed syllable. Iambic describes the type of foot that is used. Pentameter indicates that a line of poetry h...
In this video tutorial, viewers learn how to play the song "Mad World" by Tears for Fears on a ukulele. Tears for Fears are an English pop rock duo formed in the early 1980s. Begin by tuning the ukulele. On the ukulele, there are four chords to this song. The chords are: E minor, G, D and A . This video is very descriptive and clearly explains the procedures. This video contains step-by-step instructions and a visual demonstration for viewers to easily understand and follow along. This video ...
This video helps us understand the organic molecules and elimination reaction. Take some sugar in a beaker. Sugar has 12 carbon atoms, 22 hydrogen atoms and 11 atoms of oxygen. The sulphuric acid is poured into the sugar and the color change is observed. The color of the sugar gradually changes into black. The sulphuric acid causes an exothermic reaction which releases a large amount of sulphur dioxide gas. All the water (containing hydrogen and oxygen atoms) is eliminated out of the sugar du...
PrimeLoops teaches you how to use loops on Garageband. There are 2 different types of loops - regular and Apple. The last come in .aiff proprietary file format and the information contained has more information than a regular .wav file. To access them click on the small eye symbol in the lower part of the program window. You can switch to music, podcast and all loops. You also have a Favorites tab and you will see the loops that you mark as a favorite. You can also search for all loops in the...
This Photoshop tutorial on performing a nose job using Photoshop contains detailed instructions on the use of Photoshop tools to, depending on taste, enhance the appearance of an individual. The person narrating the tutorial specifies the necessity of subtlety with the modification of the picture in order to remove any appearance of modification. The way described is essentially to select the general nose area, feather the selection by an optional amount, and set it in a separate layer. Then ...
This is a video from Derrick Schommer of Everyday Drinkers: Common Man Cocktails. He describes how to make a "Sunday Snuggie," which has 2 oz Jagermeister and 2 oz Bourbon whiskey. This also contains cranberry juice, grenadine, and a mix of 1 oz of lime, 1 oz of lemon, and 1 oz of simple syrup which makes a sour mix. Use 2 oz of that. Once he explains all of the ingredients he goes on to a demonstration of how to make the drink. After he makes the drink he goes on to sip and describe it. He s...
Do you love to edit your photos in Photoshop? Watch this quick video that contains some really neat tips on how to use the healing brushes and patch tools in Photoshop. The spot healing brush makes it easy to brush away blemishes or other marks on the skin. It's good for small spots, not larger areas. You can use the patch tool for larger jobs. These two tools combined will give you a pretty impressive end look. It can remove tattoos, wrinkles, acne and so much more!
In this video by Tinkernut, we are taught all about the basics of converting and encoding videos into their various formats. He starts off by covering the video containers. Then he breaks down what is contained in these containers. He goes over the what data per second you need for each way of watching the videos. Then he suggests a couple of programs that help you convert your videos in the appropriate format for watching your videos in the many different ways out there.
This video explains how to play the song "Such Great Heights" by Iron & Wine on guitar. This song requires a capo on the sixth fret of the guitar and knowledge of the basic chord set shown. The key is F# major and the beginning chord is C Major with the song composed using finger picking. The majority of this songs constitution is alternating between F#, A and C major with the enharmonic chords being G and C. This video contains vocal instructions as well as a close up on the fret board of th...
In this video tutorial the author shows how to divide fractions by singing the songs "I Can Divide". He sings a wonderful and funny song about how he is petrified about fractions and in the song somewhere he says that to divide just invert and multiply. He says that division of fractions is nothing but multiplication of the first fraction with the inverse of the second fraction. He shows this trick in a funny manner by singing a song which is very catchy with humorous lyrics. This video conta...
Kids... it's dance time! Check out this dance video tutorial on how to do a body roll step in hip hop dance for kids.
PowerBook Medic is the ultimate resource for Mac computers and electronics repair. They have helpful tutorials on most Apple products including the MacBook, MacBook Pro, PowerBook, iBook, iPhone, iPod, and more, covering topics from disassemblies, to RAM upgrades, to replacement hard drives.
Ever wondered about the reproductive tract of a female pig? Well, these video tutorials will tell you all you need to know about the anatomy of a sow's reproductive tract.
The axillary fossa is classically known to most people as the armpit. Here, in this human anatomy video tutorial, you'll see how to dissect the axillary fossa, which in its technical definition is the hollow under the upper part of the arm below the shoulder joint, bounded by the pectoralis major, the latissimus dorsi, the anterior serratus muscles, and the humerus, and containing the axillary artery and vein, the infraclavicular part of the brachial plexus, lymph nodes and vessels, and areol...
The orbit. No, we're not talking about outer space here, were talking about the cavity in the skull containing the eye-ball; formed from seven bones: frontal, maxillary, sphenoid, lacrimal, zygomatic, ethmoid, and palatine.
It is important to have healthy teeth not only for your appearance but for your overall health as well. You can keep your teeth white by avoiding foods that stain your teeth and having a good cleaning routine including fluoride
We know the method for answering the question "What is the x percent of y" but, what about the answer to the following question "The x percent discounted price of an article is y. Find the original price." This is a reverse percentage problem that can be solved using the method shown in this video. This video contains three reverse percentage problems. The first two problems are essentially of the same type as explained above. A simple and easy to understand method of finding the original pri...
In order to get the Elegant Suit in Red Dead Redemption, you'll need about seventy dollars, which what it will cost you to get the Elegant Suit. You'll need to travel to Thieves' Landing, either by stagecoach or by foot, but the stagecoach will cost you about fourteen dollars. You'll need to find the tailor's shop, which contains the Elegant Suit, which allows you to cheat at liar's dice and poker in RDR. To see how to actually cheat, check out this video.
A wheel bearing doesn't have to be a costly fix for the mechanic. It could be a relatively cheap repair job for all you do-it-yourselfer types. There are different types of wheel bearings, but the type explained in this video, on a 1991 Ford Explorer, is a self-contained all-in-one assembly. If you have a '91 Ford Explorer, or a different vehicle with this kind of wheel bearing, then you're in luck… watch and learn.
In this video tutorial, viewers learn how to use the noise removal tool in Camtasia Studio. Begin by uploading the audio track into the time line. Then select and highlight the region that contains the noise. Now click on Edit and select Audio Enhancements. Under Background noise removal, users are able to select to automatically or manually remove the noise. Once selected, simply click on the Remove Noise button. Users also have the option to adjust the sensitivity. This video will benefit t...
In this video tutorial, viewers learn how to do a pedestal routine. This exercise circuit contains exercises. The exercises in this circuit are: 5 reps of prone leg lift, 5 reps of lateral leg lift, 5 reps of supine leg lift, 10 reps of donkey kicks, 20 reps of scorpions, 5 reps of Rockies, 5 reps of donkey whips, 10 reps of lower body crawl, 20 reps of iron cross, 20 reps of Australian crawl, 5 reps of pedestal lateral leg lift, 10 reps of groiners, 10 reps of hurdle seat exchange, 5 reps of...
In this video, Jennifer DiDonato shows us how to make healthy tuna salad and veggie dip. To begin, drain a can of your favorite tuna and place it into a bowl. Then, add in 2 tbsp fat free cream cheese, 1 tbsp mustard, dash of dill weed, salt, pepper, and your choice of diced veggies, and mix everything together until well combined. A half cup of this only contains 145 calories and has tons of nutritional value to it. It has a lot of protein so it will fill you up easily, without having to eat...
In this video tutorial, viewers learn how to the "Grant Green" exercise circuit. This exercise circuit contains exercises. The exercises are: 10 raps of donkey kicks, 20 reps of scorpions, 20 reps of iron cross, 8 reps of both lateral leg lifts with toe out and in, 5 reps of Rockies, 5 reps of donkey whips, 10 reps of lower body crawl, 10 reps of Australian crawl, 20 reps of pedestal lateral leg lift, 20 reps of groiners, 10 reps of hurdle seat exchange, 50 reps of Russian hamstrings, 20 reps...
In this video tutorial, viewers learn how to do a core-blasting workout without sit-ups or crunches. Users will only need a timer. This workout contains 6 exercises. The exercises are: right knee-to-elbow plank, left knee-to-elbow plank, right side plank twist, left side plank twist, sit through and X-up. Do 30 seconds for each exercise with no rest in between the exercises. When finished, take a 30-60 second rest and then repeat the workout 2-3 more times for a full 9 minute workout. This vi...
Just like a car, a lawn tractor contains a battery that is used to help make the vehicle start and move. without it, you would have a very expensive mower that is pretty difficult to move. So if your battery were to ever die, you may need to replace it, or easily charge it up.
At stores, imitation plastic or cloth baby booties (to be used to contain party favors or small gifts) can be quite costly, and a backbreaking expense considering all the other more necessary expenditures you're considering when planning a baby shower, including finger food, cake, party favors, and decorations.
Could you use a little help figuring out how to add and subtract fractions containing different denominators? Watch 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). With this free math tutorial, you'll learn how to sum and subtract f...
Need help wrapping your head around algebraic equations? Watch 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). With this guide, you'll learn how to solve algebraic equations containing variables.
Morocco has one of the finest, most savory culinary traditions in the world, and this delicious stew is a wonderful example of it. The Original Naked Chef here presents a recipe for a spicy lamb stew with loads of garlic, onion and chili. This is remarkably easy recipe for the massive amount of flavor it contains. The most challenging aspect of the recipe letting it cook long enough for the lamb to get tender without just diving right in and eating it!
