Existing Data Search Results

How To: Tone your legs with leg slimming exercises

No pain, no gain honeys! Though there exist a few genetically gifted women in this world (we're looking at you, Megan Fox), the rest of us have to commit to eating right and exercising in order to maintain fabulous bodies. It isn't fun, but sticking to a strict diet and workout routine does produce a pretty sexy body.

How To: Use Biped to do motion capture in 3DS Max

Causing World of Warcraft characters to do what you want them to do in your machinima film can be a major challenge. Motion capture is one useful tool that you can use to solve the problem. This video will teach you the basics of using the Biped plugin for 3DS Max to animate WoW characters with motion capture data. Give your models the realistic stride that they've deserved all along.

How To: Pack a .blend file within Blender

When working in a production environment it is a common need to send a model, along with all of it's associated files off to another artist. Blender makes this quite easy by allowing you to pack (compress) all of the external data associated with the model into the .blend. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free ...

How To: Take good care of multiple cats in one household

In this tutorial, pet expert Marc Morrone will tell you all about how to take care of more than one cat at once and help them get along with each other. In this clip, Marc will walk you through all the stages of cat care and offer advice on how to introduce a new kitten into your home and to your already existing cats. If you think like a cat, you will be able to better raise your cats, so check out this clip for tips on how to do so.

How To: Highlight rows that contain unique values 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 621st installment in their series of digital spreadsheet magic tricks, you'll learn how to write a logical formula using the AND and COUNTIFS functions with mixed cell references in the conditional formatting dialog box to highlight entire row (whole record) in data set (table) when record is unique and matches the s...

How To: Return only even row data in an MS Excel spreadsheet

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 622nd installment in their series of digital spreadsheet magic tricks, you'll learn how to to write an array formula using the SUMPRODUCT, MOD, IF, ROWS, INDEX, SMALL, and ROW functions that will retreive only even row values.

How To: Get keyboard info from users when programming in Java

Want to program your own Java games and applications but don't know beans about object-oriented programming? Never you fear. This free video tutorial from TheNewBoston will have you coding your own Java apps in no time flat. Specifically, this lesson discusses how to receive and work with keyboard input data from a user when writing code in the Java programming language. For more information, including detailed, step-by-step instructions, watch this helpful programmer's guide.

How To: Extract the word that occurs most frequently 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 592nd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract word that occurs most frequently from a column of survey results that contain customer preferences for a product using the INDEX, MATCH, MAX and COUNTIF functions. This is a way to get the MODE for data that is made up ...

How To: Look up formulas in Excel with the CHOOSE 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 557th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the CHOOSE function look up a formula or function depending on your drop-down selection. See also how to create combo box form controls and data validation lists with the VLOOKUP function.

How To: Create dynamic ranges for formulas with Excel's OFFSET

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 584th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the OFFSET function and defined names to create dynamic ranges for formulas so formulas update each period when a new data dump (copy and paste) is completed.

How To: Remove the hard disk drive (HDD) from a G5 iMac

In this how to video, you will learn how to remove your hard drive from an iMac G5. First, open the cover of your iMac. There will be torx screws that have to be removed from the left hand side of the hard drive. Once this is done, you will have to unplug the two cables located on the bottom of the drive. From here, remove the hard drive up and out. Unscrew the screws attaching a bracket to the hard drive. Once this is done, you can swap in your old drive for a new one, or make modifications ...

How To: Format field names in Microsoft 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 378th installment in their series of digital spreadsheet magic tricks, you'll learn how to format field names. If field names have formatting, Excel understands that they are field names and should not be used as data.

How To: Install a hard drive in a Power Mac G5

This video is about installing second serial ATA drive into a Power Mac G5 system. The video is a step by step demo starting with the removing of the door to the machine and the air pack. The first hard drive is at the top rack and you have to remove the four screws at the bottom and insert them into the top and bottom screw alls on each side of the drive. The hard drive is inserted below the first hard drive and the data and power cables are plugged into their respective slots. The video is ...

How To: Edit WordPress blogs on an iPhone/iPod Touch

A new introduction into the iPhone community is WordPress which easily allows you to easily control things like your WordPress blog on the move. Start off by tapping in your blog details, start writing a new post with a single tap, setting your tabs or publishing data right from the main editor through this. This also allows you to add photos directly taken from your iPhone's camera, you can change your publish date and set a password on your posts to decide who has access to them. Finally yo...

How To: Use the PERCENTILE & QUARTILE functions in MS Excel

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 248th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the PERCENTILE and QUARTILE functions to calculate percentiles, quartiles and deciles in basic statistics.

How To: Find averages & standard deviation in Microsoft Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 243rd installment in their series of digital spreadsheet magic tricks, you'll learn how to find typical values, or averages – a single value that allows you to talk about all the data points in a given spreadsheet. Specifically, you'll learn how to find the mean, median, mode and standard deviation for a set of numbers.

How To: Make feather earrings & necklaces

Here is a way you can make your own jewelry for little money and have fun doing it. In this video we are shown how we can add feathers to existing earrings and necklaces. For this project we need some feathers, a pair of earrings, some silver plated copper wire, needle nose pliers, and scissors. The earrings used in the video are already made circle earrings. The first step is cut about a circle's length of copper wire and grab a feather. Wrap the wire nice and tightly around the quill of the...

How To: Wash a male horse's sheath

This video shows how to wash a horse's sheath. The instructor notes that you do not want to wash the horse's sheath to often because certain good bacteria needs to exist in the horse's sheath. It is noted that you can use soap but his method of choice is to just use water to clean the sheath. This sort of sheath cleaning is only necessary with tame horses and must be done very carefully. The instructor notes that you can just let water run into the sheath and just let it remove any dirt. It i...

How To: Properly burn an ISO file to a CD-R or DVD-R on a Mac

This video teaches the secrets of properly burning an ISO file to a CD-R or DVD-R on a Mac. First download the CD burning software from internet and open it. Now click 'Copy' and browse for the disk image. Find the required file and click 'Open' to open it. To see the data on the file click 'Mount' and check them. Click 'Burn' finally, wait for it to complete and start using your CD.

How To: Understand the basics of video encoding

In this video by Tinkernut, we are taught all about the basics of converting and encoding videos into their various formats. He starts off by covering the video containers. Then he breaks down what is contained in these containers. He goes over the what data per second you need for each way of watching the videos. Then he suggests a couple of programs that help you convert your videos in the appropriate format for watching your videos in the many different ways out there.

How To: Remove red eye with the channel mixer in Photoshop

If you or someone you know has light eyes, then you are no stranger to red eye sneaking into your photos. Red eye is an annoying addition to most photos taken with a flash camera. Luckily, if you have Photoshop, this is easy to fix. With this tutorial, learn how to use the Channel Mixer tool in Photoshop to edit your prints, and make it look like the red eye never existed. None will be the wiser when you display these altered photos. Using the channel mixer is an all time classic red eye remo...

How To: Do basic cloud computing

This video instructs the viewer about the basics of cloud computing, using more than one computer and managing your computing needs online. The instructor explains, "Cloud computing is a metaphor for using the Internet for your computing needs." A program called cloudo, allows the user to store information online through an interface that looks like a regular computer desktop; then the information can be accessed via password from any computer with an internet connection. Other programs also ...

How To: Construct your own headboard

Grace Bonney shows us an easy way to create an upholstered headboard for your bed. Using a low-end easy budget, you will be able to create a elegant looking headboard using wood, foam, batting, fabric, scissors, a utility knife, a staple gun, and flush mounts. After cutting out the shape of your headboard or starting with an existing headboard, cut out a piece of foam that is the same size. Pull batting over the foam to even out the surface, and then put the fabric onto the headboard. With th...

How To: Get pretty hands in a flash with a 3 minute manicure

This quick and simple technique shows viewers how to acquire a good manicure. After washing your hands and removing any existing nail polish, mix oil and sugar in a bowl and put it aside while filing your nails. Scrub the oil and sugar mixture over your hands and then submerge your nails in hot water for a few minutes. Push back any cuticles you may have and massage your hands in oil. Wet a damp cloth and put it in the microwave for a few seconds, then wrap it around your hands. If desired, a...

How To: Use multiple monitors with your Mac

Sometimes just one computer monitor is not enough. Whether you are working on a detailed art project, multiple files at once, or simple wish to open more windows, you may need to connect multiple monitors to your Mac. In this video, Gary Rosenzweig from MacMost.com shows you how to hook up another screen to your computer and make the most out of your desktop space. It is actually very easy to hook up a second monitor to most Macs. Once you get a monitor and the proper cables you are good to g...

How To: Get personalized traffic reports with Ford SYNC

Knowing what traffic lies ahead is detriment to getting home on time. If you get stuck in a traffic jam or road construction, then the only thing you gain is frustration. But with Ford's new SYNC system, you can get up-to-date real-time traffic reports for your local area or specific drive home. Real-time traffic reports help keep you posted on construction, accidents, and other accidents in your commute. You just need to set up some simple preferences on your online owner's account.

How To: Call 911 using Ford SYNC

If it's an emergency, sometime you just don't have enough time or energy to pick up your mobile phone and call 9-1-1. Sometime you just can't move and the only thing still working is your mouth. Ford's new SYNC system provides an option for hands free 911 Assist. In a crash involving airbag deployment, 911 Assist places a call directly to a 911 operator. Your bluetooth phone must be on and stored somewhere inside the vehicle.

How To: Pair your bluetooth phone to Ford SYNC

Sometimes pairing your mobile phone with your car is a difficult and unwritten chore to accomplish. But now with Ford's new SYNC system, you can easily pair your cell phone. It's as easy as pressing the Phone button. Let it search for already stored bluetooth devices, and if none are stored, simply press the Arrow buttons until you see the Add Bluetooth Device option. It's that easy!

How To: Use audible texting features with Ford SYNC

Texting is one of the biggest problems in automobiles today. It's very dangerous and distracting. Ford's new SYNC system makes texting safe for everyone, with audible texting. If you receive a text message on your mobile phone, SYNC can read the message to you out loud with the touch of a button. It can even translate LOL and smiley faces. See how!

How To: Customize your Ford SYNC online user account

Customizing your user account online for Ford's new SYNC system is a cinch. Simply go to the website and customize news and sports, vehicle health reports, and your personal favorites. You can even start out by adding your favorite destinations for turn-by-turn directions later. Learn how to customize your Ford SYNC online user account.

How To: Use turn-by-turn navigation with Ford SYNC

Turn-by-turn navigation is easy with Ford's new SYNC system. Cities, businesses, your favorite places - name your destination and SYNC returns with your turn-by-turn directions. To add your favorite locations, you simply need to visit your owner account online, then you're ready to find your favorite directions, or any other directions needed.

How To: Get a Zelda Zoras inspired makeup look for Halloween

This Halloween, take your costume to the next level with this three part tutorial on how to create the makeup of a Zelda Zoras inspired aquatic, blue-skinned humanoid creature who only exist in Hyrule, Labrynna and/or Termina... Did I loose you? Only Legend of Zelda fans know the "deets" on this look but this costume idea will definitely make for a great conversation starter at the Halloween party...? Part one covers creating the fins and gils, part two goes over the eyes, and lastly, part th...

How To: Use the sandbox tools in SketchUp 6

SketchUp 5 and up has a Sandbox. But there are a few rules to know before you're allowed to play. In this episode of The SketchUp Show, Alex leads you in creating a landscape from scratch, and a second way to model terrain from existing contour lines using the sandbox tools. Landscapers will love learning to use the sandbox tools in this episode!