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 707th installment in their series of digital spreadsheet magic tricks, you'll learn how to rank values based on one criteria using the SUMPRODUCT function.
One achievement for you to earn in Starcraft 2: Wings of Liberty is the "My Precious" achievement, and you can get this in the Colonist mission of Save Haven. In order to obtain the achievement, you must successfully rescue two Colonist bases from the Protoss attack on HARD difficulty, i.e., destroy the Purifier while at least 2 Colony bases are left un-purified!
In this origami how-to, learn the art of folding a paper lily flower. This fold will start from the frog base, so if you already know how to fold the frog base, make one and skip ahead to the lily part. You'll need a sheet of origami paper and a pencil. If you use orange paper it could look like a tiger lily!
In this tutorial, we learn how to play baseball with Goofy. First, you will need to play in a ball park and have players for each team. The pitcher will throw the ball and the hitter will hit the ball, then run to the different bases. The uniform will be loose fitting so it's easier for the player to run around on the field. Players will also have to practice holding the bat and playing against other teams so they know how to get along with other players. After the pitcher throws the ball, if...
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 673rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT formula to calculate commission amounts based on varying commission rates based on cumulative sales totals for each month.
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 641st installment in their series of digital spreadsheet magic tricks, you'll learn how to create a PivotChart based on a PivotTable in one click.
Having Zbrush on your computer is like having a limitless stash of sculpting clay. This video tutorial will teach you how to sculpt a torso in Zbrush starting from a Zsketch base. Zsketch is one of the coolest features of Zbrush 3.5, so take advantage of it!
What do you do with origami flowers after you've made them and they're just sitting limply on the table? Stick them into a flower stem!
Do you have onions, carrots, butter, and celery? Then you can make a Mirepoux, a handy vegetable base that can be applied readily to all manner of soups, sauces, and other dishes. Having something like this pre-made in your refrigerator makes preparing flavorful food quickly much easier.
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 601st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the VLOOKUP & IF functions to make bonus calculations based on the number of years worked.
In this video tutorial, viewers learn how to wax a snowboard. The materials required for waxing are: wax (cold, warm, or all temp), an iron, scraper (plastic or metal) and a hard bristled brush (or rough side of a sponge). Begin by laying the board with the base facing up. Turn the iron on and melt the wax. Move the wax around to evenly distribute it on the base. Then use the iron to spread the wax in a thin layer. Allow the wax to cool for 30 minute and remove the layer with your scraper. Bu...
Lindsay Johnson, from lush life shows us how to make a gin based Bee's Knees cocktail in just 12 seconds. Firstly take 2 ounces of gin and then stir it with 3 bar spoons of running honey. Following that add 3 quarters of an ounce of fresh squeezed lemon juice. Shake and stream and it are ready to serve. She also shows us to make running honey which is really very simple. Boil some water and then add equal amount of honey to it. Then stir it together and put it into your cocktail. This adds so...
This video shows how to do audio side chain compression to improve your production audio mix. Side chain compression is an easy way to balance the base and the drums. Using a compressor, you can cause your base to drop in volume when the drums are hitting so that one is not over-powering the other. This video walks you through step by step instructions for configuring your compressor to balance based on threshold level, the attack time, and release time. This is an excellent source of audio p...
Tutorial on how to create realistic reflections on Photoshop with the objects. Take a base ball image then open layer pallet and duplicate the base ball layer its shortcut is Ctrl j. Go to image menu adjust the canvas size change height to 200 and anchor to the top then click OK then go to edit select transform change to flip vertical, select move tool then move the base ball vertically down change opacity to four percent. Finally go to filter select blur then motion blur with an angle 90 deg...
Using GoLive CS2, you'll learn how to create some CSS-based rollovers. This is really an easy way to create some rollovers, using CSS, which is an incredibly useful and powerful way to style and design your website pages. In this GoLive video tutorial, learn how to style not only your links, visited links, and active links using CSS, but you will also see how to give your links a rollover or hover style as well. You will quickly see how much more you can achieve by styling your links using CSS.
This is a tutorial on the SPH fluids nodes. This is a particle-based distributed fluid simulator application designed for Hewlett-Packard Scalabe Visualization Array. This application uses volume domain distribution among the nodes.
This collection of instructional videos from BaseballRox with baseball player Max Luckhurst will help you develop your infield mechanics in the sport of baseball. These baseball videos are aimed to help young players and coaches improve their performance on the field.
Steven Bann shows a chipping drill that teaches distance control through the air. Golf clubs are arranged into "zones" which represent the plates of a baseball field, so golf clubs arranged horizontally and evenly distanced apart from the next golf club. This represents "first base," "second base," "third base" and home plate. This is a landing drill where the object of the drill is to land in the designated "first base" zone and then subsequent bases until you get three-in-a-row for each zon...
To make a Paper Orchid you need to know the steps as follows: First fold a square sheet of origami stock paper into a triangle, bringing both points together. Use this as your flower base. Fold the paper again bringing both corners together. Rub your finger along the crease of the fold to make sure that it stays put. This step completes the triangle base. Begin making the flower base by taking the triangle base folded over twice and adding a third piece, folding it over as well to meet with t...
A mason jar is a great way to preserve your food, but did you know that you could use a mason jar with a blender?
Most people know atopic dermatitis by its common name, eczema—that dry, flaky skin that itches incessantly. Along with the scratching comes frequent skin infections, often with Staphylococcus aureus.
Start playing one of the most popular browser based science fiction games DarkOrbit! This tutorial gets you started, showing you how to create an account and choose your faction (Mars, Venus or Earth). Then the basic system is demonstrated, so you can start exploring space!
You can set up a dynamically driven Google Map widget that can display any sort of information - such as displaying a user's location based on what they have entered into their profile. This is a useful and interactive feature for any PHP/MySQL based website.
In this free video chemistry lesson from Salman Khan, we learn how to use acid-base titration to find the mass of oxalic acid. Whether you need help studying for that next big test or could just use a hand finishing your homework, you're sure to be well served by this video lesson. For more information, including detailed, step-by-step instructions, take a look.
In this video, we learn how to install a vanity and sink with Lowe's. A great way to give your bathroom a makeover is to give it a new vanity and sink. First, turn off the water from the water line, then take down the pipes from under the sink. Use a bucket to catch extra water that's falling out. Next, separate the top from the base and then remove the old vanity. Remove the old base unit from the bathroom and then install the new vanity. Measure out the area to make sure it will fit. Place ...
Here's a good tutorial for those who are looking for some easy origami projects. Starting with a water bomb base, this tutorial shows you how to make a four pointed star you can use to decorate binders, scrapbooks or even Christmas trees.
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 629th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the VLOOKUP, MATCH, DATEDIF, SUMIF, SUMPRODUCT and INT functions to look up salary based the number of relevant years worked.
Looking to add a rare and exotic specimen to your paper garden? Make a paper cherry blossom using origami, the traditional Japanese folk art of paper folding. Specifically, this free video origami lesson demonstrates how to make a cherry blossom taking an origami bird base as a starting point. For more information, and to get started making your own paper sakura, take a look!
Expand your cheesecake horizons by making white chocolate cheesecake the next time your in the mood for a rich and decadent dessert! In this video, learn from Sue McMahon, cookery editor at Woman's Weekly magazine, how to make a delicious white chocolate cheesecake. This cheesecake takes a total time of four hours and thirty minutes to make and you will need the following ingredients:
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 28th installment in his "Excel Business Math" series of free video lessons, you'll learn how to solve for base in a percent formula.
Finding the area of a trapezoid can be done easily by using a simple formula. The area can be found by adding the length of base 1 plus base 2 then multiplying by the height and then dividing the sum by 2. The bases of the trapezoid are the straight lines that are parallel to one another. The last number in the equation is total height of the trapezoid. Now all that remains left is to plug these number into the formula and find the area of your trapezoid.
In this video, they show you how to do French nails with purple and gold tips. The nail polish used for the gold color is Ooh La La. The nail polish used for the purple color is N.Y.C. You also need a clear nail polish for a base coat as well as a skinny brush in order to paint the French nails with it. The base coat used is a Maybelline nail polish. You first apply a base of clear nail polish. Then you apply the purple nail polish to the tips. Using the brush, you apply the gold stripes. Fin...
Whether you've just bought a brand new shiny surfboard, or your current wax job is a grimy, slick mess, here's how to get that perfect grip so you don't slip off.
Learn to make a white and brown roux with Professional Chef Gerald Hirigoyen. Roux is a great thickening base for sauces; just add your own flavorings or seasonings. Learn how to make a white and brown roux sauce by watching this video cooking tutorial.
Learn how to stop check washing with a pigmented gel pen or specifically the Uni Ball 207 Gel Pen instead of a typical dye-based pen. Most Bic ball point pens are dye-based.
This collection of instructional videos from BaseballRox with Max Luckhurst will help you develop your outfield mechanics with cutoffs and relays in the sport of baseball. These baseball videos are aimed to help young players and coaches improve their performance on the field. See how to practice outfielder's cutoffs and relays in baseball.
If you're a filmmaker or graphic designer, you need a good way to present your work, and in today's age, you need a website portfolio. But really, anyone in the visual arts could benefit form a web portfolio, and the easiest way to make on is in WordPress. This video series will guide you through setting up a WordPress site using pages to create a portfolio website.
Systm is the Do It Yourself show designed for the common geek who wants to quickly and easily learn how to dive into the latest and hottest tech projects. We will help you avoid pitfalls and get your project up and running fast.
Check out this overclocking tutorial from HotHardware.com! Intel's Core i7 processor offers a significant performance increase over previous generation Core 2 processors. In addition, like the legacy Core 2 architecture, the new Core i7 also has a bunch more headroom for wringing upside performance out of the chip, maximizing value, power and return on your investment with overclocking. In fact, Intel actually built-in a predefined overclocking feature called "Turbo Mode". We explain how not ...
Learn how to play a blues based intro to 11th position on harmonica with this tutorial. Pick up your C harmonica and play along in a minor cross harp position (2nd). We're playing in Gm but the music will switch to Bbmaj7. Watch this how to video and you will be able to play a blues based intro to 11th position on harmonica.