# Relative Search Results

### How To: Use relative clauses in the English language

In this episode you will learn how to use relative clauses in the English language. This video is great for advanced, intermediate, and beginner learning to speak the English as a second language (ESL).

### How To: Use an Excel macro with relative & absolute references

New to 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 Excel tutorial from ExcelIsFun, the 264th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a recorded macro to take a data set and add a new column, concatenate data from 3 columns, and delete unwanted columns.

### How To: Use floats and absolute & relative positioning in CSS

In this free video CSS tutorial, you will learn how to use floats and absolute and relative positioning. Whether you're using a fancy WYSIWYG (or what-you-see-is-what-you-get) page editor like Adobe Dreamweaver CS5 or a barebones text editor like Notepad, if you want to build websites, you'll need to have some understanding of HTML (for the structure of your web pages) and CSS (for their style). And this free coder's guide will get you started along that path.

### How To: Name cell ranges with relative references in MS Excel

Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 8th installment in his series of Excel name tricks, you'll learn how to name cell ranges with relative cell references instead of the default absolute cell references.

### How To: Create percent & relative freq. distributions in Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 25th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create quantitative data percent & relative frequency distributions with pivot tables. Also see how to create a histo...

### How To: Record absolute and relative macros in MS 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've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the nth installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how (and when) to record absolute and relative macros in MS Excel 2007.

### How To: Use absolute and relative cell references in MS Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 5th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use relative and absolute cell references to save time when writing formulas.

### How To: Use relative & absolute cell references in MS Excel

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 6th installment in his "Excel Business Math" series of free video lessons, you'll learn about the importance of cell References in Excel formulas and functions. Learn about a relative and absolute cell references in Excel formulas with th...

### How To: Learn the difference between relative and absolute positioning in CSS

This is a tutorial on CSS floats, which shows you the difference between relative and absolute positioning on your website. This also touches a little bit on the fixed position, so you can figure out which style is the best for your own website.

### How To: Know the relative stability of amides, esters, anhydrides & acyl chlorides

In this free video chemistry lesson from Salman Khan, we learn about the relative stability of amides, esters, anhydrides & acyl chlorides. 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 all of the details, take a look.

### How To: Use relative and absolute macros together 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 89.5th installment in their series of digital spreadsheet magic tricks, you'll learn how to use absolute and relative macros in concert with one another.

### Use MS Excel cell references: relative & absolute

If you're looking to learn how to use Microsoft Excel, a video series from digital spreadsheet guru ExcelIsFun is a great place to start. But which of his many series should you choose? The one titled "Excel Basics," that's which! In this free video MS Excel lesson, the 8th installment in said basics series, you'll learn how to use both relative and absolute cell references in MS Excel.

### How To: Find an item's relative position via MATCH in MS Excel

hether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 43rd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the MATCH function to find the ordinal position (relative position) of an item in a list.

### How To: Position the subject relative to the light source

Jerry Hyman has been interested in photography since he was 13 years old, and is a former professional photographer. n the premiere episode of Woven Shadows, Jerry describes the importance of positioning the subject of a photo relative to the light source.

### How To: Create a relative frequency distribution in MS Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 14th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create relative & percent & frequency distributions with formulas for categorical data. See, too, how to create a per...

### How To: Measure wood by relative dimensioning

The Wood Whisperer demonstrates how we can install hinges on a cabinet without a tape measure, using relative dimensioning. In this example, we use center lines instead of marking the top and bottom of each piece that needs to line up. Using shims at the bottom and top of the door, we center the door on the cabinet to the desired spot. At this point, it's as simple as marking the center lines where you want your hinges to go on both the door and the cabinet frame. Now we can simply attach our...

### How To: Support a relative through substance abuse

In this tutorial, Dr. Coral Arvon tells us how to support a relative through substance abuse. If you have a loved one who is suffering from an addiction to drugs or alcohol, you need to know that if they are using they are probably lying to you. If you are giving them money, they will most likely be using that for drugs or money. They will do anything to get what they want, including lie and manipulate. You need to try your best to get your loved one into a 12-step program or into a detox cen...

### How To: Set mesh details relative to camera in LightWave

In this tutorial, you will see how to use the APS tool (specifically the Pixel per polygon function) in LightWave 9 to change the detail level of your mesh (or model) according to how close it is to the camera. This is a great tool because it will give your model details when needed, and less geometry to move around when detail is not needed. Set mesh details relative to camera in LightWave.

### How To: Get unlimited XP and money in Dragon age 2 with a glitch

This video is a must-see for any Dragon Age 2 player. It will teach you how to use a small glitch to get as much money and XP as you want, quickly and easily. It has not been patched, and will allow you to cheat your way through Dragon Age 2 as much as you see fit.

### How To: Draw any face realisticaly in profile

Draw any face in side view completely from memory! This tutorial teaches you several proportion tricks, such as how to space the ears and eyes relative to each other or the shape of the head, when you're trying to draw someone in profile.

### How To: Make a traditional Lancashire Parkin for Guy Fawkes Night with Gran Hilda

One of the most traditional foods that one can enjoy at a Guy Fawkes Night celebration is the Lancashire Parkin. It's a relative of gingerbread made with treacle (molasses) and oatmeal to give it a distinctive color and flavor. Watch this video to learn how to make a Lancashire Parkin from an old British gran named Hilda.

### How To: Use link constraints in 3D Studio Max

Link constraints are a simple and useful part of the toolset available to you in 3D Studio Max. They allow you to attach one object to another so that when one moves, it will only move in relation to some parameters governing its position relative to the other object. This video will teach you how to use link constraints to make a character toss a ball realistically.

### How To: Create an animated logo in Flash 8

Want to make animated logo that will pop for your business website or ad? Look no further. In this video, learn how to take a logo and go through some different stages of animation using masks and both shape and motion tweens, as well as a neat trick for creating animated sparkles with relative ease. Get your flash animated logo up and running with help from this free tutorial!

### How To: Make a Cricut spinner "dream" card

How to make a creative card. You can use different colors of paper and decorative embellishments. This is a great idea for a scrapbooker that has supplies already on hand and wants to give a special gift to a friend or relative. This activity is a great idea for someone who needs a cheer-me-up but if you change the paper and embellishments, you can make any kind of theme card.

### How To: Play "Paint It Black" by Rolling Stones on guitar

James from Handsome Alvin, the Australian, acoustic duo band who perform in pubs and clubs around Brisbane, wants to teach you an acoustic guitar lesson.

### How To: Use Smart Tool and Edit Modes in Pro Tools

This audio editing software tutorial will show you how to use the smart tool in Pro Tools. Besides showing you the smart tool, Connor Smith will cover the different edit modes (shuffle, spot, slip, grid, and relative grid) available in Pro Tools.

### How To: Make an easy Mother's Day lace flower brooch

Your mother puts up with your crap the entire other 364 days a year and constantly toils away making the most scrumptious meals and treats for you, so can you really even justify not making something for her in return on Mother's Day? Luckily, you don't have to be Martha Stewart to create this lovely lace flower brooch craft.

### How To: Use macros in Microsoft Excel 2007

Looking for an introduction on how to work with macros in Microsoft Excel 2007? Learn how to create linkage formulas in MS Excel 2007. Whether you're new to Microsoft's popular spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the unique features of Excel 2007, you're sure to be well served by this video tutorial. For more information, and to get started using absolute and relative macros in your own Excel 2007 workbooks, watch this free...

### How To: Tune your ukulele to itself with Ukulele Mike

There's no getting around it: if you want to get good at playing the ukulele or any other instrument, you'll need to practice. Fortunately, the Internet is awash in free, high-quality uke lessons, like this one from YouTube's preeminent tropical tutor, Ukulele Mike. This particular tutorial provides a detailed, step-by-step overview of how to tune the strings of your ukulele relative to one another. For more information, and to get started tuning your uke to itself, watch this helpful how-to.

### How To: Create frequency distributions with Excel pivot tables

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 15th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use create a frequency distribution, relative frequency distribution, percent frequency distribution and pie chart wi...

### How To: Solve the Rubik's Cube in under one minute

Learn how to master the Rubik's Cube puzzle... watch this video tutorial to see how to solve the Rubik's Cube in under one minute. You don't have to be a genius to accomplish solving the 3x3 Classic Rubiks Cube.

### How To: Run backup Wii games using USB Loader 1.5

The Wii is one of the most popular systems to mod because of the ease of doing so and the relative lack of high-quality games for it relative to its competitors. This video will show you how to run backup Wii games from an SD card using some basic free software. Get to modding!

### How To: Train your ear by memorizing intervals

In this video a question is asked by a viewer. What is perfect pitch and what is relative pitch? Perfect pitch is something that is developed at a young age and comes easily. When a note or tone is made, the person listening can tell what specific note is being played. Relative pitch is being able to hear the difference from one note to the next note. The next step is how to develop your ear for relative pitch. In a 'G' major scale, listen to the intervals between each note. Certain common so...

### How To: Draw precise lines with coordinates in AutoCAD 2008

This AutoCAD 2008 tutorial covers additional ways to draw more precise lines using coordinates: Absolute Coordinates, Relative Coordinates, Relative Polar Coordinates.

### How To: Make an Android Phone or Tablet Grandma-Friendly

By now, a mobile phone that isn't "smart" is about as hard to come by as a TV that isn't high definition. As a result, members of older generations who were previously reluctant to purchase a newfangled smartphone have no other choice but to cave into the more recent trends when their old device finally breaks down.

### How To: Add conditional formatting to data bars/icons in 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 21st installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to add conditional formatting to data bars and icons to show relative size, icons to show relative size, to highlight values within 1 standard deviation, to highli...

### How To: Record and use macros 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've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 52nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to record and use macros in Microsoft Excel 2007.