Ranges Based Search Results

How To: Incorporate Google Maps into your website

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.

How To: Defeat a Terran Mech unit as a Zerg in StarCraft 2: Wings of Liberty

As a Zerg, you'll be facing Terran armies, time and time again. But how do you beat them? How do you beat a Mech unit? This video will give you some strategic advantages to defeating a Terran Mech army unit as a Zerg in StarCraft 2: Wings of Liberty. For the Zerg, positioning is your largest factor in winning a battle. Can you surround, flank, can you sneak in, can you drop on them? Any of those allow your shorter ranged troops to close the gap and get into range of your enemies troops faster...

How To: Enter formulas in Excel with a macro

In order to enter formulas in Excels with a macro, you will need to open your spreadsheet. Formulas are used to do calculations. Go to the field, where you want to enter a formula. Type in the formula. Then, highlight the formula. Press Control + C to copy the formula. Next, delete the contents of the cell. Press Alt + F11.

How To: Calculate salary based on work experience in MS Excel

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.

How To: Fold a cherry blossom flower from an origami bird base

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!

How To: Use and work with tables in Microsoft Excel 2007

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 15th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to work with tables in Excel 2007. Specifically, you'll see the following:

How To: Name cell ranges and use names in formulas in MS Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 3rd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to name a range of cells; how to use names in formulas;

How To: Solve for base in a Microsoft Excel percent formula

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.

How To: Create a dynamic range with Excel's OFFSET function

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 219th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic range with the OFFSET function so a macro to create a pivot table will work even when new records are added.

How To: Use the range property in Excel macros

Microsoft excel is a powerful tool used to work with numbers and data by filling them down in rows and columns of a table. Excels also supports macros, which are small scripts to automate certain functions. In Microsoft Excel you can select entire rows and columns using the range property. You can also use macros to select individual rows and columns as well as multiple variations of rows, columns, and individual cells all at once. In Excel a horizontal line of data is called as row and a ver...

How To: Generate random numbers (integers) in Excel

1.Here 10-50 and 300-400 numbers are taken for example to generate the random numbers within the limit in Excel. We using the command of "randbetween" for generate the random numbers and we won't get the decimal or fraction values.2.Now type "=randbetween(10,50)" which means to generate the random value between the bottom value of 10 and top value of 50 and click enter now we will get 11 as random generated number.3.Do the same thing for 300-400 as "=randbetween(300-400)".You will the 303 wil...

How To: Play baseball with Goofy

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...

How To: Calculate Commission Based on Varying Rates in Excel

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.

How To: Wax a snowboard in a quick and easy way

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...

How To: Make a gin-based Bee's Knees cocktail

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...

How To: Do basic sidechaining in Ableton

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...

How To: Create realistic looking reflection in Photoshop

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...

How To: Fix extreme red eye in Photoshop using replace color

If you have a photograph with an extreme red eye problem, then you will have to take steps above and beyond using the built-in red eye reduction tool in Adobe Photoshop. In extreme cases, red eye will actually contain colors outside of the red spectrum of light. Since the red eye tool only works on this spectrum of light, you will have to manually fix extreme red eye by working on tools that are effective across all different wavelengths of light. The most effective tool at your disposal in t...

How To: Create CSS-based link rollovers for websites in GoLive

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.

How To: Touch up high dynamic range (HDR) images in Photoshop

This software tutorial shows you how you can blend three differently exposed images using Photomatix, and then demonstrate how to use some basic Photoshop techniques to touch-up the resulting image. [Note: the Flash overlay in this video doesn't sync completely with the audio; pausing for a second and then resuming it fixes the problem.]

How To: Calculate stock value based on the value of future dividend cash flow in Excel

As you might guess, one of the domains in which Microsoft Excel really excels is finance 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 61st installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate the value of a stock based on the present value of a future dividend cash flow.

How To: Determine if you have a function

In this tutorial, we learn how to determine if you have a function. You will start off with two functions and their points. The 'x' values make up the domain of the function and the 'y' values make up the range. The input values are the domain and the output are the range. If you're checking to see if you have a function, you will need one 'y' for every 'x'. This means that each value has another one that goes with it. Each of the points need to have one partner with them, no more and no less...

How To: Perform passive range of motion (PROM) exercises on your dog's hind legs

Stretching isn't just good for humans, it's a great way to keep animals loose and healthy, especially dogs who have suffered bone deformities, muscle aches or arthritis. This video will show you how to give your dog passive range of motion (PROM) exercises on its hind legs. Perform these exercises daily if your dog has recently had orthopedic surgery or suffers from arthritis. Doing so helps maintain flexibility, reduce stiffness and increase blood flow to painful joints. For more information...