Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 36th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the VLOOKUP function to determine an increase in salary based on a rating scale.
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 555th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF and VLOOKUP functions to make one of two types of commission calculations based on what is put in the referral column.
To make a french spiral bouquet you first start with straight stemmed flowers such as roses. It is very important that you rid the stems of foliage such as leaves as well as removing all the thorns. You can do this by using a gardening glove or washcloth and sliding it down the stem. Once that is completed it is time to begin the bouquet. The first step is to pick a base flower. It is important to use a flower that has a straight stem. From there you begin to add flowers by crossing them with...
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 197th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM and VLOOKUP functions to create a grade book based on a specified total score with weights assigned to different categories.
With springtime here, there's no better time to make a beautiful hydrangea wreath for your home. Learn from a professional florist how to put together a wreath made of this lovely flower and a foam base. Impress visitors with this living decoration. You will really feel the burst of springtime with this wreath. Enjoy it!
Kevin demonstrates how to make a paper frog. Take a regular sheet of construction paper. Fold the outer ends towards the center forming a triangle. Fold a crease at the base of the triangle and cut it out. Open the folds and you can observe two creases. Create two X-shaped creases by bending the opposite corners. Hold the triangles on the side of the X and squash it down such that the other two triangles meet. Repeat the process on the other side. This forms a square with a diagonal cut conta...
Hand washing is something you learn from a young age, but how do you know you are doing it correctly? Keeping your hands clean is one of the best things you can do to keep others and yourself healthy. In this tutorial, Memorial Health will teach you the best way to wash your hands and prevent the spread of germs. There are two ways to clean germs from your hands: soap and water and alcohol-based handrubs. Watch this video to find out how to use both effectively. The video will show you how a ...
Princess Pink Cat demonstrates how to use Vaseline to apply pigments and hold them into place. Dip a finger into the jar, spread the tiniest amount possible across the lid. You can go all the way to the brow bone or just to the crease. Wipe the excess Vaseline off to avoid creasing. The remaining Vaseline will make your pigment colors pop by gripping the pigments to the skin.
Photoshop Universe presents a step-by-step tutorial on how to mask images over text. First and foremost you'll need to have a poem or some other block of text in mind to use. Once you've selected your text you'll use methods such as copying and pasting, using clipping masks, and mild typeface editing. By the end of this tutorial you will have the abilities you need in Photoshop to make your very own text based image!
This video is for those of you looking for unique and different styles to paint your finger nails with. The author takes us through the entire process to create a fantastic looking United States flag on our nails, just in time for Independence Day! From starting with a red base, adding the stripes and even creating actual stars on your nails with the appropriate nail brushes. What a great way to show your patriotism, love and support for Old Glory!
Anna Saccone shows which colors to wear if you are a brunette, pale, with cool undertones, having any eye color. She explains about some basic colors such as white, cream, and mint green, which work best with your skin undertones and hair color to best accentuate your features and look. Anna gives this general guide as a good base, though depending on specifics that work for you, may change a little since each person is different.
Have you ever wondered how to solve the Rubix Magic? Well, this video is designed to do just that. This is a very short video; the demonstrator shows us how to play this game, loosely based on the Rubik's Cube and how it is solved. Watch this video to find out more about the Rubix Magic!
From The Apprentice Doctor, a video regarding "Cavernous Sinus Thrombosis", which means a blood clot in the cavernous sinus. The cavernous sinus is in the base of the brain and contains several nerves, a vein and many other structures. The vein that sits in the Cavernous sinus carries deoxygenated blood from the brain & face and brings it back to the heart. This video shows how to spot Cavernous Sinus Thrombosis in a patient's protruding eyes.
Take a folder and organize documents based on the actions required. Actions:
Hunting predators can be difficult. As their entire lives are based on being stealthy enough to make a kill, while expending minimal energy, finding your prey can prove to be quite time-consuming. One hunter has made a homemade predator decoy for less than $20. Watch the video to find out how.
Grab some paper, pennies, and paper clips, and create this stealth weapon in the comfort of your own bedroom. Scaled to actual size, this craftable katana can be used to fend off paper-based attacks, or displayed for decoration. Add as many, or as few, foldable components to customize your sword size.
Anime is a unique drawing style, whose origins are based in Japan. In this video tutorial, you will be taken through how to draw anime boys.
The Möbius strip is a perplexing shape discovered by German mathematician August Ferdinand Möbius. In this video tutorial we learn how to make a scarf based on the Möbius strip, but with a few extra twists. The pentafold Möbius design loops back on itself five times, making it one of the more confusing-looking things you'll ever wear. (Fortunately, it's not that confusing to knit!)
When German mathematician August Ferdinand Möbius (also known as Moebius) discovered the weird, seemingly parodoxical shape that would later be known as the Möbius strip, he surely never imagined it would go on to be featured everywhere from the work of artist M.C. Escher to the recycling logo we now see on the back of milk cartons. In this video, we watch as a scarf is knitted based on the Möbius strip. This interesting and eye-catching scarf design looks more complicated than it really is.
Release your inner wild thing with a costume based on the classic children's book. You Will Need
Check out this informative video tutorial from Apple on how to import photos from a digital camera in iPhoto '09.
Check out this informative video tutorial from Apple on how to organize photos with Events in iPhoto '09.
Check out this informative video tutorial from Apple on how to add keywords, ratings or flags to photos in iPhoto '09.
Check out this informative video tutorial from Apple on how to crop your photos in iPhoto '09.
Check out this informative video tutorial from Apple on how to rotate or straighten photos in iPhoto '09.
Check out this informative video tutorial from Apple on how to reduce red-eye in iPhoto '09.
Check out this informative video tutorial from Apple on how to enhance your photos with a single click in iPhoto '09.
Check out this informative video tutorial from Apple on how to fix photos that are too light or too dark in iPhoto '09.
Check out this informative video tutorial from Apple on how to brush out or retouch problem areas in iPhoto '09.
Check out this informative video tutorial from Apple on how to apply photo effects in iPhoto '09.
Check out this informative video tutorial from Apple on how to email photos to friends and family in iPhoto '09.
Check out this informative video tutorial from Apple on how to create and share a slideshow in iPhoto '09.
Check out this informative video tutorial from Apple on how to publish photos to Facebook in iPhoto '09.
Check out this informative video tutorial from Apple on how to create your own photo book in iPhoto '09.
Check out this informative video tutorial from Apple on how to create your own greeting cards in iPhoto '09.
Check out this informative video tutorial from Apple on how to create your own calendar in iPhoto '09.
Watch this science video tutorial from Nurd Rage on how to make nitric acid. They show three ways to make nitric acid based on two different chemical approaches, both of which can be done using easily accessible materials.
The art of floral arrangement is a fun and valuable skill. Dana Plazyk lends useful tips and tricks on making simple flower arrangements.
Here's the secret to making a perfect pie crust for your holiday desserts. You can fill this crust with all sorts of fruits, nuts and filling. This recipes requires a pastry blender and uses shortening. Water varied based on the humidity of the kitchen.
Dave Wilson Nurseries, Ed Laivo shares ideas for growing blueberries in containers. You will need 1/3 acid based potting soil plus 1/3 peat moss plus 1/3 medium sized bark. For the best results, containerize your blueberry plants. We show you the proven way to do it.
