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.
In this video by Simon Leach, we learn how to fit a lamp base into pottery with Simon Leach. First, you will take the lamp base that has all the wires inside of it. From here, you will wire the cables through the proper fittings for the light. Then, you need to put a hole in the bottom of the lamp base so you can string the light base through and then place the light bulb on top. When you are finished, the pottery can sit on top of the base and then you can add a light shade to finish up the ...
Ticks. They're everywhere, and they're a pet owner's worst nightmare. Ticks can spread deadly diseases to your dogs and cats, even to people, so it's important to know all the tick prevention tips. Learn how to care for your pet with help from VetVid, and see how to prevent ticks from spreading disease in dogs and cats with this video tutorial.
In this Business & Money video tutorial you will learn how to write a great business vision statement. Why is the vision statement important? Because, it provides the inspiration for daily operations and motivation for strategic decisions. Vision and missions statements are different. Vision statement answers the question where is my business going; whereas your mission statement states why your business does exist. Vision statements are future focused and written with the end result in mind....
There is a reason the rest of the world calls 'soccer' 'football' - it's all about your feet! In this tutorial, from Zappos, learn how to kick a soccer ball the right way and win the game every time!
Your cats nails are always growing, and they can easily grow too long, which can cause problems. Indoor cats can catch their nail on the carpet, resulting in bleeding or possibly injuring the actual toe. Toenails that are too long can always result in an infection. Learn how to care for your pet with help from VetVid. See how to trim the nails on your cat with this video tutorial.
This how to video shows you how to create wallpaper for your computer desktop. Open Photoshop and create a new file. Change the dimensions to the size of your desktop. Click okay and go to edit and fill. Choose color and select black. Click okay to fill the screen with black. Duplicate the layer. Once this is done, go to filter, render, and lens flare. Make sure the lens flare is in the center. Edit the settings to your liking. Click okay to add the effect on to the image. Go to filter, disto...
Calculating probablities can be used to help us make decision. PatrickJMT explains how to calculate probability in an "either A or not A" scenario. The probability of A plus the probability of not A is equal to one. Therefore, the probability of A is equal to one minus the probability of not A ; P(A)= 1 - P(not A). The probability of a major earthquake in San Francisco over a period of time is used as an example. The probablity of an earthquake of a magnitude of 7.5 or greater in San Francisc...
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...
Your veterinarian may, at some point, prescribe some SQ fluids, or subcutaneous fluids to your cat. There are many reasons for having an SQ fluids prescription. But if you have a cat that needs these, you're going to have to learn how to give the fluid to your cat. Learn how to care for your pet with help from VetVid. See how to give subcutaneous fluids to a cat with this video tutorial.
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...
This is an electronic travel authorization system used to gain travel authorization to the United States. There are certain countries that fall under a visa waiver program, meaning that you do not need a visa to enter the US to visit. In that case you use the ESTA system. The countries that qualify in the VISA waiver program include Andora, Australia, Austria, Belgium, Brunei, The Czech Republic, Denmark, Estonia, Finland, France, Germany, Hungary, Iceland, Ireland, Italy, Japan, Latvia, Lich...
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?
Rock-paper-scissors is a great way to alleviate boredom or make decisions, such as figuring out who gets to go first in the next game you play.
If you're feeling unappreciated, underwhelmed, or just plain trapped, taking some time off may help.
Learn how to write a grant proposal. If your organization has come up with a great idea that needs money to get off the ground, you'll need a great proposal. Here's how to write one.
Make the most of your YouTube videos! Watch this video tutorial to see how to make the most out of the YouTube player by uploading widescreen video. Here's how to prepare your videos for widescreen viewing:
Augmented reality startup Nreal was a hit at this month's CES event, with some even calling the device a worthy challenger to the Magic Leap One.
A week after the L.E.A.P. Conference, our cup of Magic Leap news continues to floweth over, with the company's content chief giving us some insight into the company's strategy, and Twilio sharing what its virtual chat app looks like.
So much information exists online that it's easy to get lost in data while researching. Understanding the bigger picture can take a lot of time and energy, but narrowing the question to one that's easy to answer is the first step of any investigation. That's why analysts use open-source intelligence (OSINT) tools like Maltego — to help refine raw data into a complete understanding of a situation.
Dengue fever is a danger to anyone living or visiting tropical or subtropical regions. It can be hard to detect the infection in its earliest and most treatable phase, especially in children. Luckily, new research highlights better techniques for triaging the disease in infected children with more severe symptoms, potentially saving lives.
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.