Relative Search Results

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

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

How To: Buy flowers for your girlfriend

Sure, you can go online and send the first flowers you see, but a little thought and planning will go a long way toward impressing her. Sure, you can go online and send the first flowers you see, but a little thought and planning will go a long way toward impressing her. You will need a friend or relative of the recipient. Send her favorite. If she’s ever mentioned a favorite flower, buy that. You’ll get bonus points for listening to her. If you have no clue, ask a friend or relative of hers ...

How To: Use the Scale Node in the Blender 2.5 Compositor

In this tutorial, you'll see how to use the Scale Node in the Blender Compositor to manipulate an image. You'll see how to stretch it, spin/rotate, and have all sorts of fun with uniform linear distortion. The clip discusses the difference between resolution handling between the renderer and the node system. Hence we have the scale node to scale an input image at one resolution to match the render resolution. I discuss using Absolute scaling, and relative/percentage scaling, relative aspect r...

How To: Adjust brush size via keyboard shortcuts in Photoshop

See a number of useful key commands that will allow you to quickly resize and adjust the relative hardness of your brushes in Adobe Photoshop CS4. Whether you're new to Adobe's popular graphic editing program or a seasoned design professional looking to better acquaint yourself with the new features and functions of this particular iteration of the application, you're sure to benefit from this free software tutorial. For more information, watch this designer's guide.

Prev Page