Absolute Search Results

How To: Use the Sony Vegas interface for beginners

Software manufacterers always advise you to read the instruction manual first before attempting to do anything on a new program. But who has the time to obsess over ever little boring detail in a 300-page tome when just playing around the controls on your own gets you attuned to the program immediately?

How To: Do a backflip

If done wrong, a backflip could be devastating. But if done right, a backflip just might make you the coolest person ever. This is a unique backflip tutorial that uses both video examples and instructional text. See how to do a backflip. Follow these steps, one by one, to see what you're doing wrong.

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: Make healthy and simple sweet potato fries

Fries are such a killer food. They're beloved as the favorite "vegetable" of kids and adults everywhere, yet they are one of the absolute worst foods you can eat if you want to, you know, live past 40, containing high levels of saturated and trans fats that clog your arteries and lead to lots of gnarly diseases.

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: Build a conditional average calculation table in Exel

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 583rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AVERAGEIF & IFERROR functions with absolute and mixed cell references to create a large table of conditional average calculations (averaging with criteria).

How To: Draw the "y=A|x-h|+k" graph

In this video, one teacher talked in detail about how to solve absolute value functions and how to translate different absolute value functions from one point in the matrix to another one horizontally and vertically. If the function is y=A|x-h|+k, generally, the diagram is symmetric based on the line of X and can be moved vertically based on k. The teacher gave several examples to explain how to illustrate the absolute value function. He started with a simple one: y=|x-h|, then continued with...

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: Play "Let it Be" by The Beatles on guitar (beginners)

This video will teach you how to play one of the Beatles absolute classics "Let it Be" on the guitar. Did you know that you only need to have four chords to play this song? That is one of the first secrets Marty Schwartz shares in this video. This breaks it down into very easy pieces even for absolute beginners. Marty begins to play "Let it Be" and goes through the song chord by chord, part by part. He uses repetition to help everyone learn even those just starting out who might be unfamiliar...

How To: Replace (or install) a brand new toilet in your bathroom

You're in drastic need of a new toilet, but you're scared of the cost of installation— don't worry, you can install it yourself with absolute ease. You don't need a plumber for this at all. It's actually one of the easiest home repairs you can DIY, right alongside a leaky faucet. This step-by-step tutorial will show you the whole process of removing your old "crap" toilet and install a bright, shiny new one. You'll need a putty knife, tape measure, crescent wrench, gloves and wax ring.

How To: Find the hidden error code behind your Xbox 360's RLoD

It goes by many names. The RLoD (Red Lights of Death), the RRoD (Red Ring of Death), absolute disaster. Whatever you call it, the XBox 360 error that causes many console's front LED's to turn red in rage and cessation of function has caused all sorts of headaches for consumers and Microsoft. It can be caused by a couple of different cooling-related issues, and determining the error code that has caused your console to malfunction can go a long way to helping you fix it. This video will show y...

How To: Fix other people's Microsoft Excel spreadsheets

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 26th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use spreadsheet construction guidelines to fix common problems:

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: Make an Excel dynamic named range across multiple rows

Teach Excel demonstrates how to make an Excel dynamic named range across multiple rows. Highlight the cells that you want to include in your named range and give it a name. You can then use that name in formulas. But it's not a dynamic named range so it won't account for added information. Ctrl + F3 is the name manager shortcut and the F3 is the paste name shortcut. Use the name manager and highlight the named range. Delete the absolute cell references and type in offset. Then, select the fir...

How To: Make natural elderberry syrup for cold and flu season

Learn how to harvest your elder tree! If you have an elder in your backyard, you can finally do something special with those elderberries. Mountain Rose Herb shows you the steps required to make delicious elderberry syrup with this video recipe. This herbal syrup can be used for colds, flu and coughs. It's a simple natural home remedy with dried elderberries.

How to Play Elton John: "Sorry Seems to be the Hardest Word"

Struggling to learn to play Elton John songs on the piano? This unbelievable video offers an excellent bird's eye view of "Sorry Seems to be the Hardest Word" being performed on the piano by an amazing, expert pianist. Video includes captioned Elton John lyrics to help you keep track of your place in the score. If you want to master the piano style of Elton John, this tutorial is an absolute must see.

How To: Install the D Focus DSLR Mount on a Canon 5D

When you're first working with a digital single-lens reflex camera, there's a lot to learn. Setting up a D|Focus DSLR mount can look particularly complicated, but in this tutorial you'll learn all the steps. Now you're ready to start taking shots like a pro. (Note that this tutorial is not for absolute beginners. You'll need to have some familiarity with these camera before you begin.)

How To: Play relas on the tabla

Interested in learning how to play the tabla? In this installment from his video series of free tabla lessons, Debu Nayak introduces the rela and demonstrates how to play one. While these tutorials are geared towards absolute beginners, even seasoned percussionists are likely to pick something up. To get started playing relas on your own tabla, take a look.

How To: Play kaidas on the tabla

Interested in learning how to play the tabla? In this installment from his video series of free tabla lessons, Debu Nayak introduces the kaida and demonstrates how to play it. While these tutorials are geared towards absolute beginners, even seasoned percussionists are likely to pick something up. To get started playing kaidas on your own tabla, take a look.

How To: Perform a peshkar on the tabla

Interested in learning how to play the tabla? In this installment from his video series of free tabla lessons, Debu Nayak introduces the peshkar. While these tutorials are geared towards absolute beginners, even seasoned percussionists are likely to pick something up. To get started writing your own peshkars on the tabla, take a look.

How To: Play the teen tall, or 16-beat, theka on the tabla

Interested in learning how to play the tabla? In this installment from his video series of free tabla lessons, Debu Nayak demonstrates how to play the teen tall, or 16-beat, theka on the tabla. While these tutorials are geared towards absolute beginners, even seasoned percussionists are likely to pick something up. To get started playing the teen tall theka on your own tabla, take a look.

How To: Play an uthan, or opening flourish, on the tabla

Interested in learning how to play the tabla? In this installment from his video series of free tabla lessons, Debu Nayak instroduces the tabla and demonstrates how to play an uthan, an opening flourish. While these tutorials are geared towards absolute beginners, even seasoned percussionists are likely to pick something up. To get started playing uthans on your own tabla, take a look.