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.
Did you ever want to know how to create Star Wars style lightsaber effects for your own home videos? Youtube user Comphelper225 has a way make this little bit of movie magic come to life using Adobe After Effects. Once you have a video of yourself or a friend swinging a base for your sword, the next step is to download Andrew Kramer's lightsaber presets from the Video Copilot website. Once it's installed, open up your video in After Effects to begin. Within the program, click Layer, New, and ...
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!
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!
Scene style makeup is in, and in this video we are given the essentials in creating this sort of look. Beginning as you begin with any makeup, we are advised to apply a base, consisting of either a general foundation or a powder. As we go, the video author offers specific brand recommendations and shows the results, via pictures. Now, after our base, the steps are as follows.
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.
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.
Netstat (network statistics) is a command-line tool that displays network connections (both incoming and outgoing), routing tables, and a number of network interface statistics. It is available on Unix, Unix-like, and Windows NT-based operating systems. This video tutorial presents a basic introduction to working with the netstat tool. Determine whether you've been hacked with this how-to.
The crochet square in this how-to video works with two colors. You will also need a crochet hook. Watch this instructional video on how to crochet a diamond tapestry square. You can use this diamond tapestry square as the base for many different types of projects.
One great feature of OnTime 8.1 is the ability to add color schemes to the main grids of OnTime Windows and OnTime Web. This installment from Axosoft's own series of video tutorials on the OnTime Project Management Suite covers how to activate this functionality to allow color changes for items based on their Priority, Status, Severity, and Workflow.
In this cooking ho-to video Dylan Lauren, of New York's Dylan's Candy Bar, demonstrates how to make a haunted gingerbread house for Halloween. This spooky haunted gingerbread house is a great way to decorate your tables and they also make great treats afterwards. Follow along and learn how easy it is to decorate a gingerbread base house for Halloween.
If you walk into your bathroom and notice there's a little moisture around the base of your toilet, or there's just a little more rock than there should be, it's time to get it off the floor and see what's underneath. There's a good chance your flange may be broken. Fortunately, this video tutorial will walk you, step by step, through the flange repair process. Take a look.
Inspired by Tim Burton's movies, this how-to video shows a theatrical Halloween look. The cosmetics used are Bare Escentuals mineral foundation, NYX White e/s, ArtDeco e/s Base, MAC e/s in Carbon, Copperplate, Shroom, Ben Nye black eyeliner, Max Factor 2000 Calorie mascara, MAC Prep & Prime Lash, MAC Velvetella lipliner, Nars Scarlet Empress lipstick, NYX Grape lipgloss, MAC Blue Brown pigment, and Jofrika theater blood. Watch this video makeup tutorial and learn how to create a Corpse Bride ...
Watch this training video for making Earth Loop Geothermal Slinkies. Geothermal technology takes advantage of the earth's natural heat-storing ability. A geothermal system include three main pieces of equipment: underground piping, a heat pump and an air-handling system. The geothermal process is based on a simple premise: Below the frost line - usually about six feet deep – the earth is a constant temperature of about 50 degrees Fahrenheit all year long.
This video tutorial takes a look at using gconf-editor in the Ubuntu Linux distribution. In particular this video addresses what gconf-editor is, how to use it, and what it offers. While this tutorial is Ubuntu-oriented, its lessons will work on other systems such as Fedora and gNewSense, but only if they are GNOME-based. To learn more about gconf-editor, and why you should learn how to use it, watch this how-to.
Learn how to use the cable key to tighten your Knit Picks Options Interchangeable Knitting Needles. Each needle tip has a hollow base that is grooved to accept the threaded stem of the cable. To insure a secure fit, use a cable key to tighten the knitting needle tip. You can also use the cable key to unscrew your knitting needle when you are ready to start a new knitting project.
In this video you'll learn how to log in to Webmin, a web-based Unix administration interface, which will allow you to manage your serve with a web browser. Watch this video tutorial to learn how to control your server with a web browser and the Webmin interface.
How do you choose colors for a drawing without it looking like a child's drawing? Watch this instructional drawing video to use a digital color palette effectively. Examine a photograph to choose accurate, subtle colors based on limited perspectives.
In this video you'll learn how to download Webmin, a web-based Unix administration interface, which will allow you to manage your serve with a web browser. If you're interested in running the Webmin interface, then watch and follow along.
This tutorial will attempt to explain the perspective principle of Field Of Vision. Learn how to draw perspective with a more realistic method than a classic one point perspective practice. This instructional drawing video demonstrates how to draw using a technique that focuses on field of vision, based on the human eye. Your drawing will take on a fish eye effect as you mimic the effect of looking up and down as you draw.
You know he cares more about you than his precious video games; he just needs a little help showing it. This video gives tips for luring a boyfriend away from video games, by compromising his love of competition and skill-based games with other activities you can enjoy together as a couple. Watch this video dating advice tutorial and learn how to compete with a video game for your boyfriend's attention.
Not sure what to serve at your next cocktail party? Why not try a decadent rum drink that doubles as a chocolate dessert? In this how-to video James prepares a rum based cocktail with Hotel Chocolat's Liquid Chocolat.
The bright colors and reflective sheen in this makeup look are really eye-catching. The cosmetic products used to create this look are ArtDeco eyeshadow base, MAC Sharkskin shadestick, Ben Nye Grande Lumier palette, Rimmel white kohl, Max Factor 2000 Calorie mascara, MAC Solar White, NYX White, Revlon Colorstay liquid eyeliner, MAC Corps de Ballet lipglass, Nars Desire Blush, and MAC Shimpagne MSF. Watch this video makeup application tutorial and learn how to do a reflective violet eye Ben Ny...
Want a change from your boring old pink and white French manicure? Learn how to apply a purple glitz French manicure with this tutorial. You will need a base coat, purple flat sparkled, purple glitter, a small flat top brush, a small round tip brush, tape and a top coat. With the techniques from this how to video you will be able to create a sparkly purple French manicure.
Tired of your boring one color nail polish? Learn how you can create this black with gold glitter nail decoration with this tutorial. You will need a base coat, black nail polish, gold glitter, a small brush and a clear top coat. With this how to video you can paint you nails black with faded golden sparkles.
Tired of your boring old pink and white French manicure? Learn how you can create blue glitter French manicure tips with this tutorial. You will need a base coat and top coat, MAC cosmetics jewel marine glitter, Q-tip or corrector to clean corners and tape. This look takes a steady hand and lots of practice. With this how to video you can create blue glitter French manicure tips.
Tone your body with tips from the experts and a jump rope. This fitness how-to video tutorial offers a series of SELF Magazine workouts based on working out with a rope. Watch and learn how to do heel clicks, power twists, leap frogs, pick up lunges and double hops with alternating jump roping in between each exercise.
