Key Data Search Results

How To: Apply professional, flawless foundation with tips

There are lots of key parts to creating beautiful makeup, but if you had to ask us for the most important step we'd without a doubt say foundation. Good skin looks good no matter what other type of makeup you decide to you put on, whether it's smoky eyes or red lips. That's because beautiful, flawless skin acts as a smooth, pretty base.

How To: Take care of hermit crabs

Hermit crabs are a cool pet to own and are generally pretty low key. But taking care of them is a chore in itself and requires some very specific needs! In this video you will get some basic care tips including constructing his environment, foods and more!

How To: Clean out your old keyboard

After a few years, keyboards not only get older and harder to use, but they start to build up gunk and other nasty stuff in them, and if you drink anything at your computer desk, there's a chance of spilling something on the keyboard, and that's no bueno. In this video you will learn how to deep clean your keyboard including getting underneath the keys and really getting rid of the gunk.

How To: Use hydrogen for better mileage

Hydrogen can be used to improve mileage. The hope with this method is that hydrogen will increase the amount of gasoline combusted and increase fuel efficiency, as you trickle hydrogen into the tank. Often propane is used to increase gas mileage. The studies are still being done. There's no official data at present, but there is significant experimentation.

How To: Optimize Google's crawl of your website without using robots.txt

Google is one of the most powerful forces on the Internet, and their technology can be the key to helping you find success in whatever your online endeavor might be, from web design to filmmaking. This video is a part of their Google Webmaster Series, offering help to webmasters the world over on how to best utilize Google in their work. This video will show you how to ensure that Google crawls a particular section of your site without using any robots.txt.

How To: Create reports & pass parameters in C# programming with Visual Studio

If you're not sure about creating reports in Visual Studio, this two-part video will cover the entire process. This assumes that you already know a few things in Microsoft Visual Studio and the C# programming language. So, if you're not a beginner and still need help to create reports from data in the SQL Server, this is how you do it. Also, learn a quick and easy way to pass parameters to reports in C#.

How To: Add yearly totals from monthly data in MS Excel 2010

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 679th installment in their series of digital spreadsheet magic tricks, you'll learn how to summarize yearly totals from monthly totals when there Year Criteria is entered as a serial date. See the SUMPRODUCT and SUMIFS functions. Learn about criteria and how to enter it into the SUMIFS functions.

How To: Ignore filtered values making calculations 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 665th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to make calculations on filtered data. The SUBTOTAL function only has 11 functions, whereas the AGGREGATE has 19 plus options to ignore errors, hidden rows and nested SUBTOTAL or AGGREGATE functions.

How To: Keyframe audio in Avid Media Composer 5

Need to know how to keyframe (or key frame) audio within Avid Media Composer 5? Never fear: this guide will show you precisely how it's done. Whether you're new to Avid's popular non-linear editor (also known as "The Avid") or are a seasoned digital video professional just looking to better acquaint yourself with Media Composer 5, you're sure to enjoy this free software tutorial. For detailed instructions, and to get started using Avid 5 yourself, take a look.

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: Customize your background wallpaper on iPhone 4G HD

On the new iPhone 4 and in iOS 4 you are able to set a wallpaper as a background. In the past, wallpapers were only used on the lock screen and in this clip, you will see just how easy it is to set the old lock screen as well as the screen behind your app keys. This feature was only available on jailbroken devices in the past and now it is totally safe and made especially for you, by Apple.

How To: Create and edit keyframes in Blender 2.5

This clip presents a general overview on how to keyframes (sometimes written "key frames") in Blender 2.5. Whether you're new to the Blender Foundation's popular 3D modeling program or a seasoned graphic artist just interested in better acquainting yourself with the application, you're sure to be well served by this free video tutorial. For more information, including detailed instructions, take a look.

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: Play a jazzy chord vamp in G on the guitar

See how to play a fun, fast-paced R&B chord vamp in the key of G. With the guitar, as with any other instrument, if you want to improve, you'll need to practice. Fortunately, the Internet is awash with free, high-quality guitar lessons like this one. For more information, and to get started playing this chord vamp on your own guitar, watch this tutorial.

How To: Swap between applications with the OS X app switcher

Want to switch between various open applications via keyboard shortcut? With Mac OS X and the app switcher tool, it's a breeze. It's so easy, in fact, that this home-computing how-to can presenta complete overview of the process in just over two minutes. For more information, and to get started using this essential window- and life-changing key command yourself, take a look.

How To: Play an easy Hawaiian picking vamp in C on the ukulele

Learn to play the easiest Hawaiian picking vamp in the key of C. 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 uke lessons, like this one from Ukulele Live, which make the task not only easy but fun. For more information, and to get started playing this picking vamp on your own ukulele, take a look.

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: 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: 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: Convert between fraction, decimal & percent

This video is very informative in explaining the different ways to convert. The man in the video makes key points about the rules to make these conversions. He is also helpful in explaining how to convert from every type of number. A viewer watching this video will be able to understand the basics of converting and how to apply the rules.

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.